Previous Thread
Next Thread
Print Thread
Hop To
SQL error on search
#180861 03/18/2007 4:41 AM
Joined: Jun 2006
Posts: 136
Okusi Offline OP
member
OP Offline
member
Joined: Jun 2006
Posts: 136
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:


UBB Error
We encountered a problem. The reason reported was

Script: /home/webadmin/jakchat.com/html/forums/scripts/dosearch.inc.php
Line#: 510
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.


Okusi Associates -- Indonesian business and management services
Re: SQL error on search
Okusi #180879 03/18/2007 4:02 PM
Joined: Jul 2006
Posts: 4,062
Offline
Joined: Jul 2006
Posts: 4,062
Is this the Main Search Box or
the Search island (Portal Box)


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Re: SQL error on search
Mark S #180905 03/18/2007 8:42 PM
Joined: Jun 2006
Posts: 136
Okusi Offline OP
member
OP Offline
member
Joined: Jun 2006
Posts: 136
it's the search island.


Okusi Associates -- Indonesian business and management services
Re: SQL error on search
Okusi #180914 03/18/2007 9:56 PM
Joined: Jun 2006
Posts: 9,243
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
It appears that your new server is running an older version of MySQL that doesn't support Boolean mode searches. You'll want to check and see what version of MySQL is actually running. It sounds like it's maybe version 3?

Re: SQL error on search
Rick #180920 03/18/2007 11:18 PM
Joined: Jun 2006
Posts: 136
Okusi Offline OP
member
OP Offline
member
Joined: Jun 2006
Posts: 136
This the version string that mysql returns:

mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

version 11??


Okusi Associates -- Indonesian business and management services
Re: SQL error on search
Okusi #180922 03/18/2007 11:56 PM
Joined: Jun 2006
Posts: 136
Okusi Offline OP
member
OP Offline
member
Joined: Jun 2006
Posts: 136
which version of mysql is recommended? how simple/complex is it to upgrade versions of mysql?


Okusi Associates -- Indonesian business and management services
Re: SQL error on search
Okusi #180923 03/19/2007 12:35 AM
Joined: Jun 2006
Posts: 15,886
Likes: 5
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,886
Likes: 5
Your MySQL version (from that string) is 3.23.58; the lowest supported MySQL version for the UBB is 4.1 (if I recall)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL error on search
Gizmo #180924 03/19/2007 1:32 AM
Joined: Jun 2006
Posts: 136
Okusi Offline OP
member
OP Offline
member
Joined: Jun 2006
Posts: 136
my problem has been solved! within 30 minutes of my message to my VPS provider, they upgraded me to 4.1!



Okusi Associates -- Indonesian business and management services
Re: SQL error on search
Okusi #180925 03/19/2007 2:26 AM
Joined: Jun 2006
Posts: 15,886
Likes: 5
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,886
Likes: 5
Lol glad to hear it!


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Update General Settings doesn't work
by Baldeagle - 03/22/2020 10:58 PM
Photo Gallery, how about a Video Gallery?
by M4TT - 03/17/2020 11:32 PM
Stuck on an upgrade to 7.7.4
by Baldeagle - 03/16/2020 3:50 PM
Who's Online Now
1 members (1 invisible), 100 guests, and 35 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4