Bugs in external plugin serendipity_event_aggregator

[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.


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

[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