sqlite problem in serendipity_event_entrypaging

[costa]

latest version downloaded and installed, problem occurs when showing random entry function is enabled. this is what i got:

Code: Select all

Warning: sqlite_query(): no such function: RAND in /_my_path_/include/db/sqlite.inc.php on line 229
bool(false) string(394) "SELECT e.id, e.title, e.timestamp FROM serendipity_entries e WHERE e.id <> 595 AND e.isdraft = 'false' AND e.timestamp <= 1153854335 ORDER BY RAND() LIMIT 1"

ok garv, no more private e-mails with bugs. we go into public with problems

[garvinhicking]

Hi!

Yes, sadly random entries simply don't work with SQLite.

There's no way to get "random" data using SQLite. You would need to fetch ALL data frmo the table and then randomize it with PHP. You wouldn't want that.

Best regards,
Garvin