|
Joined: Jun 2006
Posts: 136
member
|
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.
|
|
|
|
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
member
|
member
Joined: Jun 2006
Posts: 136 |
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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?
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
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??
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
which version of mysql is recommended? how simple/complex is it to upgrade versions of mysql?
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 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)
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
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!
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (Ruben),
1,248
guests, and
268
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|