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
i found a bug relating to the commit done for this bug:
I'm got this error: 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")
[WAR] fd (lib/errors.
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