UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports [FIXED for 7.5.5] Search engine error (+ solution)

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

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

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.