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
Register User    Portal Page     Forum List        Calendar     Active Topics     Search     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (Ruben, Kayjey, SteveS), 34 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 12/20/03
Posts: 4420
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
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 2 of 2 < 1 2
Topic Options
#170085 - 12/11/06 08:58 AM Re: Search errors 7.02 (was 7.01) [Re: MartinBe]
MartinBe Offline
stranger 		Registered: 09/27/06
Posts: 20
Loc: Sweden
After upgrading to 7.02 and appropriate MySql, I get:
Code:
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.
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."
#170090 - 12/11/06 12:53 PM Re: Search errors 7.02 (was 7.01) [Re: MartinBe]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It's still not liking the BOOLEAN MODE portion. Are you sure that MySQL is version 4 or 5 now?
Top
#170152 - 12/12/06 10:06 AM Re: Search errors 7.02 (was 7.01) [Re: Rick]
MartinBe Offline
stranger 		Registered: 09/27/06
Posts: 20
Loc: Sweden
Hello
At least according to the Web provider, I will double check.
Top
#190523 - 07/09/07 05:47 PM Re: Search errors 7.02 (was 7.01) [Re: MartinBe]
nims2 Offline
member 		Registered: 07/04/07
Posts: 122
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?
Top
#190536 - 07/09/07 07:47 PM Re: Search errors 7.02 (was 7.01) [Re: nims2]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
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 ;)...


Edited by Gizmo (07/09/07 07:49 PM)
_________________________
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
Page 2 of 2 < 1 2



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33840 Topics
181693 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image
Board Rules · Mark all read
Contact Us · UBBCentral · Top