Page 1 of 1

sqlite problem with serendipity_plugin_popularentries

Posted: Sat May 26, 2007 11:17 pm
by costa
Hello,

I just installed the plugin and that's what I got:

Code: Select all

Warning: sqlite_query() [function.sqlite-query]: near "LIMIT": syntax error in /home/PATH_TO_BLOG/db/sqlite.inc.php on line 229
bool(false) string(529) "SELECT e.id, e.title, e.comments AS points, e.timestamp FROM serendipity_entries AS e WHERE e.isdraft = 'false' AND e.timestamp <= 1180213750 ORDER BY e.comments DESC LIMIT LIMIT 2, 5"
I tried with default settings of the plugin. Does this plugin work with SQLite?

Re: sqlite problem with serendipity_plugin_popularentries

Posted: Tue May 29, 2007 10:20 am
by garvinhicking
Hi!

Just updated the plugin to 1.7 so I think it shouldn't happen. It only happened if you chose the option to limit the display of entries to not incldue frontpage entries.

Regards,
Garvin

Posted: Tue May 29, 2007 9:46 pm
by costa
thanks garv, as always - problem solved :)

in exchange polish translation of the plugin is on the way.