I was testing the search feature and got this message.
Script: /home/virtual/site2/fst/var/www/html/scripts/dosearch.inc.php
Line#: 566
SQL Error: You have an error in your SQL syntax near 'BOOLEAN MODE) OR MATCH t1.POST_BODY AGAINST ('test' IN BOOLEAN M' 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') AND t1.TOPIC_ID = t2.TOPIC_ID AND (MATCH t1.POST_SUBJECT AGAINST ('test' IN BOOLEAN MODE) OR MATCH t1.POST_BODY AGAINST ('test' IN BOOLEAN MODE)) AND t1.POST_POSTED_TIME > '1157943491' ORDER BY t1.POST_POSTED_TIME DESC LIMIT 25
Last edited by Rick; 09/21/2006 1:51 PM.
