Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (57-Vette, Chosen), 43 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 03/24/10
Posts: 8
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
#230886 - 11/09/09 02:35 PM [FIXED for 7.5.5] Search engine error (+ solution)
Big_Red Offline
stranger
Registered: 02/20/05
Posts: 6
Hi,

I found another bug (BTW there are lots of them).
This time it's in "Search". If you search anything and select option: "in body", you'll get maximum allowed posts with no searched word.
For example try to find phrase: "abcabcabc" on your board. Compulsory check "in body". You'll get 37 results, all wrong.

Problem is in "dosearch.php" file.
You have to put the following lines:

AFTER:
if ($where == "sub") {$andquery .= "$andconcat (p.POST_SUBJECT LIKE '%$word%')";}

INSERT:
if ($where == "body") {$andquery .= "$andconcat p.POST_DEFAULT_BODY LIKE '%$word%')";}


AFTER:
if ($where == "sub") {$notquery .= "$notconcat (p.POST_SUBJECT NOT LIKE '%$word%')";}

INSERT:
if ($where == "body") {$notquery .= "$notconcat (p.POST_DEFAULT_BODY NOT LIKE '%$word%')";}

AFTER:
if ($where == "sub") {$orquery .= "$orconcat (p.POST_SUBJECT LIKE '%$word%')";}

INSERT:
if ($where == "body") { $orquery .= "$orconcat (p.POST_DEFAULT_BODY LIKE '%$word%')";}



That's all. Enjoy smile

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."
#230913 - 11/09/09 08:42 PM Re: Search engine error (+ solution) [Re: Big_Red]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
yes, it applies to THIS forum as well.. i noted that in the changelog discussion thread, because i was searching for if a keyword 'mysqli' was mentioned there..

it came up with hits that had nothing to do with the keyword..

thanks for the info smile
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#231029 - 11/13/09 05:12 PM Re: Search engine error (+ solution) [Re: SD]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
So maybe we will have a 7.5.4.3 before v8.0?
The search feature is a big item for me.
I would also like to see the advanced search window improved and get rid of the greater than or less than date field.
Build a search then have the ability to add filters.
It never seems to work correctly, I just blank them out.
Maybe the issue mentioned has been the problem all along.
_________________________
Blue Man Group
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