i have just transferred my system to a new server. all seems to be working fine, but just now the following SQL error occurred when i tried to use the search box:
We encountered a problem. The reason reported was
SQL Error: You have an error in your SQL syntax near 'BOOLEAN MODE) ORDER BY t1.POST_POSTED_TIME DESC LIMIT 200' at line 9
SQL Error #: 1064
Query: SELECT t1.POST_ID FROM ubbt_POSTS as t1, ubbt_TOPICS as t2 WHERE t1.POST_IS_APPROVED = '1' AND t2.TOPIC_STATUS <> 'M' AND t2.FORUM_ID IN ('2','3','4','5','6','7','8','9','10','11','12','15','13','14') AND t1.TOPIC_ID = t2.TOPIC_ID AND MATCH ( t1.POST_SUBJECT,t1.POST_DEFAULT_BODY) AGAINST ('indonesia' IN BOOLEAN MODE) ORDER BY t1.POST_POSTED_TIME DESC LIMIT 200
Please use your back button to return to the previous page.