sss638 Posted July 16, 2012 Share Posted July 16, 2012 (edited) Hi every body when a user open a ticket and i answer that, i have this error in Activity log and i have not found the right solution for it, So what should i do ? - 2012/07/16 18:07 - aval - 2.183.102.120 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 '%وقت%' OR article LIKE '%بخیر\r%' OR article LIKE '%من%' OR article LIKE '%تست%' OR article LIKE '%کردم%' OR article LIKE '%به%' OR article LIKE '%مشکلی%' OR article LIKE '%بر%' OR article LIKE '%نخوردم%' OR article LIKE '%سرور%' OR article LIKE '%هم%' OR article LIKE '%مشکلی%' OR article LIKE '%نداره،%' OR article LIKE '%شاید%' OR article LIKE '%اشکال%' OR article LIKE '%از%' OR article LIKE '%اسکریپت%' OR article LIKE '%شما%' OR article LIKE '%باشه\r%' OR article LIKE '%با%' OR article LIKE '%تشکر\r%' OR article LIKE '%اول%' OR article LIKE '%هاست%') AND id NOT IN () ORDER BY useful DESC LIMIT 0,5 regards Edited July 16, 2012 by sss638 0 Quote Link to comment Share on other sites More sharing options...
gOOvER Posted July 22, 2012 Share Posted July 22, 2012 I can confirm this. I got the same Error. MySQL-Server 5.5.25a 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.