MyBB Community Forums

today i got an error email from my mybb forum ...

Type: 20
File:  (Line no. 0)
Message
SQL 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 'LOWER(message) LIKE '%power supply diagram for wearable computer%' AND (  LOWER(' at line 1
Query: SELECT pmid FROM mybb_privatemessages WHERE uid='174305'  LOWER(message) LIKE '%power supply diagram for wearable computer%' AND (  LOWER(subject) LIKE '%power supply diagram for wearable computer%')  AND () AND folder IN (1)

i want to know which script is cause to produce this error and how to over come this ?

This sql call is made in functions_search.php but I don't see any problem with the code so I don't why you got the wrong query. What version of MyBB are you running?

Can you run the File verification under Admincp >> Tools and Maintenance and check for any changed files?

There are even two syntax errors in this query.