User search does not work

[Ruslan Kabalin]

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.

[Evan Goldenberg (naveg)]

Are you using the latest? I think I fixed this in 32f72753b3f121959c1b26db76d1498dcb741dc5. Could be wrong though.

[Richard Mansfield (richard-mansfield)]

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] ...

[Richard Mansfield (richard-mansfield)]

Ruslan's patch works for me in both pg & mysql.