Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (SteveS, Bjab), 37 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 469
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 23
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#3434 - 09/17/06 11:05 PM [NOTABUG] Is this a Search bug?
Larry Miller Offline
member
Registered: 09/06/06
Posts: 141
Loc: Long Island, NY
I was testing the search feature and got this message.
Script: /home/virtual/site2/fst/var/www/html/scripts/dosearch.inc.php
Line#: 566
SQL Error: You have an error in your SQL syntax near 'BOOLEAN MODE) OR MATCH t1.POST_BODY AGAINST ('test' IN BOOLEAN M' 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') AND t1.TOPIC_ID = t2.TOPIC_ID AND (MATCH t1.POST_SUBJECT AGAINST ('test' IN BOOLEAN MODE) OR MATCH t1.POST_BODY AGAINST ('test' IN BOOLEAN MODE)) AND t1.POST_POSTED_TIME > '1157943491' ORDER BY t1.POST_POSTED_TIME DESC LIMIT 25



Edited by Rick (09/21/06 01:51 PM)
_________________________
www.backofthenet.com
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."
#3435 - 09/17/06 11:19 PM Re: Is this a Search bug? [Re: Larry Miller]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Did you get that from here or on your own forums? From the looks of it, I'm guessing on your forums and that you have an older version of MySQL that doesn't support fulltext boolean searches. If that's the case you'll need to make sure that you are at least running MySQL 4+
Top
#3437 - 09/17/06 11:31 PM Re: Is this a Search bug? [Re: Rick]
Larry Miller Offline
member
Registered: 09/06/06
Posts: 141
Loc: Long Island, NY
I got that from my server and i will check to see what version of mysql I have. thanks again for your prompt reply.
_________________________
www.backofthenet.com
Top



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

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 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
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image