sqlite problem with serendipity_plugin_popularentries

Found a bug? Tell us!!
Post Reply
costa
Regular
Posts: 110
Joined: Wed Feb 08, 2006 5:29 pm
Location: Poland
Contact:

sqlite problem with serendipity_plugin_popularentries

Post 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?
"everything is under control" - kasparov demo
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: sqlite problem with serendipity_plugin_popularentries

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
costa
Regular
Posts: 110
Joined: Wed Feb 08, 2006 5:29 pm
Location: Poland
Contact:

Post by costa »

thanks garv, as always - problem solved :)

in exchange polish translation of the plugin is on the way.
"everything is under control" - kasparov demo
Post Reply