|
Joined: Sep 2006
Posts: 18
stranger
|
stranger
Joined: Sep 2006
Posts: 18 |
I get this when I search my board. My skills are limited, and some community help would be appreciated. Script: g:\home\admax.net\users\saabklubben.com\ubbthreads7\scripts\dosearch.inc.php Line#: 565 SQL Error: You have an error in your SQL syntax near 'BOOLEAN MODE) AND t1.USER_ID = '' AND t1.POST_POSTED_TIME > '116366665' 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 ('1','2','3') AND t1.TOPIC_ID = t2.TOPIC_ID AND MATCH t1.POST_SUBJECT AGAINST ('saab' IN BOOLEAN MODE) AND t1.USER_ID = '' AND t1.POST_POSTED_TIME > '1163666656' ORDER BY t1.POST_POSTED_TIME DESC LIMIT 200
Last edited by Rick; 11/22/2006 6:27 PM.
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
Hi - You will need to be running MySQL version 4 at the minimum - my guess is you are running 3.x
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
BTW - the minimum versions of PHP and MySQl are:- Minimum version of PHP: 4.3 Minimum version of MySQL: 4.0 You might want to check with your host as to your version, and get them to upgrade If you are on version 4.0+ of MySQL let us know
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
That was my guess at: Script: g:\home\admax.net\users\saabklubben.com\ubbthreads7\scripts\dosearch.inc.php Line#: 565 SQL Error: You have an error in your SQL syntax near 'BOOLEAN MODE)
|
|
|
|
Joined: Sep 2006
Posts: 18
stranger
|
stranger
Joined: Sep 2006
Posts: 18 |
PHP is 4.3.4. AFAIK, My SQL Client API version 3.23.49
I´ll adress the host
Thanks!
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
no problem - whilst many features will work under 3.x - the search is one that requires 4.x
|
|
|
|
Joined: Sep 2006
Posts: 18
stranger
|
stranger
Joined: Sep 2006
Posts: 18 |
OK, thanks for the response. Here comes my final(?) question.
I am running the live board on UBBT 6.5.5. The host also runs Mysql 5.0.15
Will a change to Mysql 5.0.15 affect UBBT 6.5.5? (I know it´s a bit OT, but it affects my upgrade to 7.0.x)
If so, I will wait until 7.02 is up and running before we do the Mysql switch.
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
I am not sure if 6.5x is compatable with MySQL 5 - I would guess that it is not - you may get some errors.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
You'll want to wait. 6.5 does not play nicely with MySQL 5.
|
|
|
|
Joined: Sep 2006
Posts: 18
stranger
|
stranger
Joined: Sep 2006
Posts: 18 |
OK, thanks for the assistance!
|
|
|
|
Joined: Sep 2006
Posts: 18
stranger
|
stranger
Joined: Sep 2006
Posts: 18 |
After upgrading to 7.02 and appropriate MySql, I get: Script: g:\home\admax.net\users\saabklubben.com\ubbthreads\scripts\dosearch.inc.php
Line#: 565
SQL Error: You have an error in your SQL syntax near 'BOOLEAN MODE) OR MATCH t1.POST_DEFAULT_BODY AGAINST ('martin' IN' 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 ('12') AND t1.TOPIC_ID = t2.TOPIC_ID AND (MATCH t1.POST_SUBJECT AGAINST ('martin' IN BOOLEAN MODE) OR MATCH t1.POST_DEFAULT_BODY AGAINST ('martin' IN BOOLEAN MODE)) AND t1.POST_POSTED_TIME > '1165240557' ORDER BY t1.POST_POSTED_TIME DESC LIMIT 200
Any ideas appreciated.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
It's still not liking the BOOLEAN MODE portion. Are you sure that MySQL is version 4 or 5 now?
|
|
|
|
Joined: Sep 2006
Posts: 18
stranger
|
stranger
Joined: Sep 2006
Posts: 18 |
Hello At least according to the Web provider, I will double check.
|
|
|
|
Joined: Jul 2007
Posts: 103
member
|
member
Joined: Jul 2007
Posts: 103 |
Same problem I have on my new installed board. It's MySQL 3.23.58 on an ensim box, so I cannot upgrade to 4.x . Any patches / changes I can do in making it work?
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Unfortunately, the minimum supported version is MySQL4; this is listed on the feature listing. As far as mysql in Ensim, I've seen MySQL4.1 on Ensim before; so it's not impossible, likely it's just a webhost not wanting to preform upgrades ...
Last edited by Gizmo; 07/09/2007 7:49 PM.
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
1 members (Ruben),
814
guests, and
236
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|