Topic: Error: (1064, "You have an error in your SQL syntax;...) in search
Hello. After updating from 1.3.0 to 1.3.1 (MySql backend) I have an error in Search feature:
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 ''%elle%' OR description LIKE u'%elle%') ORDER BY domain' at line 1")
"elle" was the search term.
I checked libs/mysql/connUtils.py, but looks fine to me (... but have to say I'm not a Python programmer).
It worked fine in 1.3.0, and I remember we had a similar issue previously that was fixed.
Thanks for your help.