** Changed in: mahara
Status: Fix Committed => Fix Released
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask
on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1193117
Title:
SQL error for duplicate email filter
Status in Mahara ePortfolio:
Fix Released
Bug description:
from Bob on bug #1166499:
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1193117/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
