Serendipity Forums

Posted: **Tue Jul 25, 2006 9:16 pm**

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

Posted: **Wed Jul 26, 2006 12:26 pm**

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

Serendipity Forums

sqlite problem in serendipity_event_entrypaging

sqlite problem in serendipity_event_entrypaging

Re: sqlite problem in serendipity_event_entrypaging