mahara-contributors team mailing list archive

[Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>]

It's a bit of a worry this, because the same kind of thing probably
happens in quite a few queries.  I can't reproduce any of these errors
using pg 8.1 on my dev server (or on master.dev.mahara.org) -- these pg
installs must be overly forgiving of type mismatches.

After pulling down 32f72753b3f121959c1b26db76d1498dcb741dc5 I still
don't get any pg errors but my mysql install won't search users any
more.

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 'INTEGER) <> 1)
                         AND (u.firstname LIKE '%' || '' || '%' OR' at line 7] ...

-- 
User search does not work
https://bugs.launchpad.net/bugs/544901
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.

Status in Mahara ePortfolio: Fix Committed

Bug description:
Branch: master

Any user searching attempt ends up with error message. The problem is related to real name search introduction (4339ecf6243f), there is a type mismatch in user search query. The patch is attached.