SQLite broken in r1311

[tinyau]

r1311 using SQLite

After upgraded to r1311, the web site no longer work. The following message is shown when tried to connect to the site.

Uncaught Exception: Exception: PDO::prepare() [function.PDO-prepare]: SQLSTATE[HY000]: General error: 1 unrecognized token: "{"

After amended the version number from 1310 to 1170 in version.php, the site can access again. Seems like add cronjob in r1311 cannot be worked properly under SQLite.

[rickc]

Utils:truncate_log() uses MySql syntax. The Sqlite equivalent to

DATE_SUB(NOW(), INTERVAL 14 DAY)

should be

date('now', '-14 days')

http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions has a list of all Sqlite's date and time functions.

[ringmaster]

Fixed in r1332.