Page 1 of 1

Bugs in external plugin serendipity_event_aggregator

Posted: Thu Aug 03, 2006 7:00 pm
by Boris
Sqlite seems to have problemes with the "key"-statements in the creation of "{$serendipity['dbPrefix']}aggregator_md5".

Additionally it has problems with the ALTER TABLE
Warning: sqlite_query() [function.sqlite-query]: near "ALTER": syntax error in /home/boris/public_html/serendipity-nightly/include/db/sqlite.inc.php on line 229
bool(false) string(83) "ALTER TABLE serendipity_aggregator_feeds DROP categoryid;"
Warning: sqlite_query() [function.sqlite-query]: near "ALTER": syntax error in /home/boris/public_html/serendipity-nightly/include/db/sqlite.inc.php on line 229
bool(false) string(119) "ALTER TABLE serendipity_aggregator_feeds ADD COLUMN charset varchar(255) NOT NULL default '';"
DROP is not supported [1], but ADD COLUMN shoud be (perhaps it's because I only have sqlite 2.8)


I guess I'll have to setup a db-server. :)

Re: Bugs in external plugin serendipity_event_aggregator

Posted: Fri Aug 04, 2006 10:55 am
by garvinhicking
Hi!

Yes, certain plugins are not fully SQLite compatible because of the lacking ALTER TABLE capability of SQLite. This can be work-arounded, but is a lot of work (see the *sqlite db update files in s9y on how it can be done).

Anyone willing to go through this? :)

Best regards,
Garvin