mahara-contributors team mailing list archive

[Aaron Wells <1193117@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara
    Milestone: 1.8rc1 => 1.8.0

-- 
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 Committed

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