Comment 4 for bug 1166499

Revision history for this message
Robert Lyon (robertl-9) wrote :

i found a bug relating to the commit done for this bug:

I'm got this error:
[WAR] fd (lib/errors.php:749) Failed to get a recordset: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FALSE' at line 1] in EXECUTE("SELECT COUNT(*) FROM "usr" u WHERE u.id <> 0 AND u.deleted = 0AND FALSE")
Command was: SELECT COUNT(*) FROM "usr" u WHERE u.id <> 0 AND u.deleted = 0AND FALSE

Looks like the line 463 in search/internal/lib.php needs to be

 $where .= ' AND FALSE';

not

$where .= 'AND FALSE';

So I submitted a patch https://reviews.mahara.org/#/c/2281/ to fix it