Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 106
member
member
Joined: Jun 2006
Posts: 106
When using the search:

Quote
Script: [redacted]forum/scripts/dosearch.inc.php
Line#: 485
SQL Error: 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 ') AGAINST ('wirelesspacket' IN BOOLEAN MODE) AND t1.POST_POSTED_TIME > '119' at line 8
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','14','4','5','8','6','9','10','11','12','13','16','17','18','19') AND t1.TOPIC_ID = t2.TOPIC_ID AND MATCH ( t1.POST_SUBJECT,t1.) AGAINST ('wirelesspacket' IN BOOLEAN MODE) AND t1.POST_POSTED_TIME > '1198700543' ORDER BY t1.POST_POSTED_TIME DESC LIMIT 200


Can someone please explain what this means and how I may fix it.

I'm using:
Apache/1.3.37 (Unix) PHP/4.4.7 mod_ssl/2.8.28 OpenSSL/0.9.7e-p1
MySQL 5.0.37

Thank you.


Last edited by usrbingeek; 01/02/2008 4:38 PM.
Joined: Dec 2003
Posts: 1,798
Likes: 2
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,798
Likes: 2
Looks like a bug in forum code, which version are you using? I ran into a similar problem when the client was using mysql 3.something.


- Allen
- ThreadsDev | PraiseCafe
Joined: Jun 2006
Posts: 106
member
member
Joined: Jun 2006
Posts: 106
This one is UBB 7.2.2

MySQL is 5.0.37

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It looks to me like your missing a config option. Open up your config.inc.php file and make sure you have this line somewhere in there. Either your missing it completely, or the value is empty.

'FULL_TEXT' => 'POST_DEFAULT_BODY',

Joined: Jun 2006
Posts: 106
member
member
Joined: Jun 2006
Posts: 106
That fixed it. Thank you Rick!


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Are any of these legitmate?
by Baldeagle - 09/06/2026 1:37 PM
After server reboot
by Morgan - 09/02/2026 8:27 AM
8.0.1 Patch Changelog Discussion
by isaac - 11/26/2025 1:34 PM
Who's Online Now
0 members (), 381 guests, and 101 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)