Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 registered (packlite, Rick, Sirdude), 27 Guests and 24 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/07/06
Posts: 28
Top Posters (30 Days)
Ruben Rocha 103
Rick 81
Mark S 72
Thelockman 56
Gizmo 54
driv 35
ntdoc 32
Sirdude 30
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Topic Options
Rate This Topic
#3434 - 09/17/06 08:05 PM [NOTABUG] Is this a Search bug?
Larry Miller Offline
member

Registered: 09/06/06
Posts: 111
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 10:51 AM)
_________________________
www.backofthenet.com

Top
#3435 - 09/17/06 08:19 PM Re: Is this a Search bug? [Re: Larry Miller]
Rick Administrator Online   content

*****

Registered: 06/04/06
Posts: 7993
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+
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3437 - 09/17/06 08:31 PM Re: Is this a Search bug? [Re: Rick]
Larry Miller Offline
member

Registered: 09/06/06
Posts: 111
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


Shout Box

Today's Birthdays
GOTMYSELFA...., smilinjack
Recent Topics
New members don't get access and are not displayed in the config panel
by Yomar
Today at 03:32 AM
How to Change Link Color / Underline in styles?
by ECNet
Yesterday at 10:00 PM
Chaging the "max online" number and date
by wanted
Yesterday at 02:22 PM
7.4.1. In Threaded Mode - "Mark All Read" Doesn't Work
by packlite
Yesterday at 10:26 AM
Custom island with sql connection
by Robje01
Yesterday at 09:13 AM
Forum Stats
4296 Members
33 Forums
30687 Topics
156016 Posts

Max Online: 978 @ 06/24/07 08:19 PM