Previous Thread
Next Thread
Print Thread
Hop To
#180861 03/18/2007 4:41 AM
Joined: Jun 2006
Posts: 136
O
member
member
O Offline
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
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
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
Joined: Jun 2006
Posts: 136
O
member
member
O Offline
Joined: Jun 2006
Posts: 136
it's the search island.


Okusi Associates -- Indonesian business and management services
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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?

Rick #180920 03/18/2007 11:18 PM
Joined: Jun 2006
Posts: 136
O
member
member
O Offline
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
Okusi #180922 03/18/2007 11:56 PM
Joined: Jun 2006
Posts: 136
O
member
member
O Offline
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
Okusi #180923 03/19/2007 12:35 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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!
Joined: Jun 2006
Posts: 136
O
member
member
O Offline
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
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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
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
1 members (Havenofsobriety), 458 guests, and 91 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)