Previous Thread
Next Thread
Print Thread
Hop To
#3434 09/17/2006 11:05 PM
Joined: Sep 2006
Posts: 165
L
Member
Member
L Offline
Joined: Sep 2006
Posts: 165
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.
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Did you get that from here or on your own forums? From the looks of it, I'm guessing on your forums and that you have an older version of MySQL that doesn't support fulltext boolean searches. If that's the case you'll need to make sure that you are at least running MySQL 4+

Rick #3437 09/17/2006 11:31 PM
Joined: Sep 2006
Posts: 165
L
Member
Member
L Offline
Joined: Sep 2006
Posts: 165
I got that from my server and i will check to see what version of mysql I have. thanks again for your prompt reply.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)