SQL error for duplicate email filter

Bug #1193117 reported by Kristina Hoeppner
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
High
Robert Lyon

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

Son Nguyen (ngson2000)
Changed in mahara:
status: In Progress → Fix Committed
Aaron Wells (u-aaronw)
Changed in mahara:
milestone: 1.8rc1 → 1.8.0
Aaron Wells (u-aaronw)
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.