Movable Type Community Forum > Dynamic Publishing In Sqlite 3 On Php5

Full Version: Dynamic Publishing In Sqlite 3 On Php5

Movable Type Community Forum > Installing and Upgrading > Databases

The Baron

Sep 8 2007, 07:07 AM

Is it possible to use dynamic publishing in MT4 with an SQLite 3 database? The release notes indicate that it is with PHP5:

QUOTE

Dynamic publishing does not work in SQLite 1 or SQLite 3 (only SQLite 2) on servers running PHP 4.x. SQLite 1, 2 and 3 works on systems running PHP 5.x.

However, the changelog for MT4 beta 6 indicates that it is not possible (note that DBD::SQLite is the library that supports SQLite3):

QUOTE

54218: Hide Dynamic publishing option when MT is run on DBD::SQLite (not SQLite2)
CHANGE: Because database created using DBD::SQLite does not support dynamic publishing, MT4 now hides the option to avoid confusion.

I am running MT4 on SQLite 3 with PHP5, and would very much like to use dynamic publishing, but I don't seem to have that option.

The Baron

Sep 18 2007, 07:12 AM

It turns out to require remarkably few changes to update the MovableType code from SQLite 2 to SQLite 3. In all, commenting out 13 lines in 3 files, and adding 9 new lines of code in 2 files will get SQLite 3 working for dynamic publishing in MT4. I've put all the gory details in my blog.

The PDO functions which are used for SQLite 3 are apparently somewhat compatible with SQLite 2 (it's not clear from the PHP documentation exactly how compatible), which means there's some chance that the changed code will work with SQLite 2 too. Anyway, my fingers are crossed that official SQLite 3 support for dynamic publishing is added to MT soon.

Note: these changes are for PHP5.1 and above only.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.