I get this when I search my board. My skills are limited, and some community help would be appreciated.
Quote:
Script: g:\home\admax.net\users\saabklubben.com\ubbthreads7\scripts\dosearch.inc.php Line#: 565 SQL Error: You have an error in your SQL syntax near 'BOOLEAN MODE) AND t1.USER_ID = '' AND t1.POST_POSTED_TIME > '116366665' 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 ('1','2','3') AND t1.TOPIC_ID = t2.TOPIC_ID AND MATCH t1.POST_SUBJECT AGAINST ('saab' IN BOOLEAN MODE) AND t1.USER_ID = '' AND t1.POST_POSTED_TIME > '1163666656' ORDER BY t1.POST_POSTED_TIME DESC LIMIT 200
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
That was my guess at:
Originally Posted By: MartinBe
Script: g:\home\admax.net\users\saabklubben.com\ubbthreads7\scripts\dosearch.inc.php Line#: 565 SQL Error: You have an error in your SQL syntax near 'BOOLEAN MODE)
After upgrading to 7.02 and appropriate MySql, I get:
Code:
Script: g:\home\admax.net\users\saabklubben.com\ubbthreads\scripts\dosearch.inc.php
Line#: 565
SQL Error: You have an error in your SQL syntax near 'BOOLEAN MODE) OR MATCH t1.POST_DEFAULT_BODY AGAINST ('martin' IN' 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 ('12') AND t1.TOPIC_ID = t2.TOPIC_ID AND (MATCH t1.POST_SUBJECT AGAINST ('martin' IN BOOLEAN MODE) OR MATCH t1.POST_DEFAULT_BODY AGAINST ('martin' IN BOOLEAN MODE)) AND t1.POST_POSTED_TIME > '1165240557' ORDER BY t1.POST_POSTED_TIME DESC LIMIT 200
Same problem I have on my new installed board. It's MySQL 3.23.58 on an ensim box, so I cannot upgrade to 4.x :(. Any patches / changes I can do in making it work?
Previous Topic
Index
