[NOTABUG] Search errors 7.01 - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Bug Reports
» Non Bugs » [NOTABUG] Search errors 7.01

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	49
DennyP	24
Gizmo	24
Dunny	17
SteveS	14
AllenAyres	12
dbremer	10
SD	9
drkknght00	9
driv	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Page 1 of 2

Topic Options

#168432 - 11/17/06 03:53 AM

[NOTABUG] Search errors 7.01

MartinBe Offline

stranger

Registered: 09/27/06
Posts: 20
Loc: Sweden

I get this when I search my board. My skills are limited, and some community help would be appreciated.

Quote:

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

Edited by Rick (11/22/06 05:27 PM)

Top

Express Hosting

Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."

#168435 - 11/17/06 04:26 AM

Re: Search errors 7.01 [Re: MartinBe]

Ian

Registered: 06/05/06
Posts: 4337
Loc: Essex, UK

Hi - You will need to be running MySQL version 4 at the minimum - my guess is you are running 3.x

Top

#168436 - 11/17/06 04:31 AM

Re: Search errors 7.01 [Re: Ian]

Ian

Registered: 06/05/06
Posts: 4337
Loc: Essex, UK

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 $\:\)$

Top

#168438 - 11/17/06 05:07 AM

Re: Search errors 7.01 [Re: MartinBe]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

That was my guess at:

Originally Posted By: MartinBe

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)

_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!

Top

#168490 - 11/17/06 05:27 PM

Re: Search errors 7.01 [Re: Gizmo]

MartinBe Offline

stranger

Registered: 09/27/06
Posts: 20
Loc: Sweden

PHP is 4.3.4.
AFAIK, My SQL Client API version 3.23.49

I�ll adress the host

Thanks!

Top

#168491 - 11/17/06 06:01 PM

Re: Search errors 7.01 [Re: MartinBe]

Ian

Registered: 06/05/06
Posts: 4337
Loc: Essex, UK

no problem - whilst many features will work under 3.x - the search is one that requires 4.x $\:\)$

Top

#168686 - 11/21/06 08:38 AM

Re: Search errors 7.01 [Re: Ian]

MartinBe Offline

stranger

Registered: 09/27/06
Posts: 20
Loc: Sweden

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.

Top