mysql error when replying to a ticket

[leemason]

i just got this in my log when replying to a ticket in my admin area:

 

SQL Error: 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 ') ORDER BY useful DESC LIMIT 0,5' at line 1 - Full Query: SELECT id,parentid FROM tblknowledgebase WHERE (article LIKE '%nameremoved,\r%' OR article LIKE '%made%' OR article LIKE '%now.\r%' OR article LIKE '%bart%' OR article LIKE '%thing%' OR article LIKE '%language,%' OR article LIKE '%later,%' OR article LIKE '%tomorrow.\r%' OR article LIKE '%you.\r%') AND id NOT IN () ORDER BY useful DESC LIMIT 0,5 

 

 

i replaced one of the likes with name removed, as this was a client name. it looks like it could be a knowledge base suggestions issue on tickets.

Edited July 25, 2012 by leemason
added code tags to error message