SMF search not working correctly.

[bitmovel]

Hi!

SMF search is not working correctly.

I am using 2.0 b3

Search results shows sometimes old search results.

sample:
i search 'heroes' and everything is ok

then i search 'prison break' and i get old search results for heroes, as other users who did not even searched same phrase will also see them

And sometimes, it will not show results at all, even if I am sure there are some results.

I do nothing, and a few minutes later (or hours) it does the same search fine.

Edit: Maybe its not related, but I have this critical error in LOG:

The database value you're trying to insert does not exist: all_word_body_2
Function: PlushSearch2
Apply Filter: Only show the errors from this file
File: /home/cs/public_html/Sources/Search.php
Line: 1531

What is going on?

Best Regards

[greyknight17]

Can you try clearing the search index and then recreating it to see if it helps? To do this, just to into Admin > Search > Search method tab and change it to No Index. Save it and then create a new index.

[bitmovel]

i have been testing that for last 2 days.

It didn't work

search results are messed up sometimes, as described in first post.

Any other solution?

Best Regards

[ThorstenE]

your mysql user must have the CREATE TEMPORARY TABLES privilege for using the search function.. please ask your host to enable this for your mysql account. after changing the privileges go to forum maintenance - Empty out unimportant logs.

[bitmovel]

mysql user is root.

it has all privileges.

any other solution?

problem remains.

best regards

[ThorstenE]

have you created an search index? I recommend "Full Text"  > Admin - Search - Search Method - Create Full Text Index ... after creating the Index enable it an check "Force the use of a search index"..

The Sources/Search.php seems to have a bug.. download SMF 2.0b4 from our downloads page, extract the package and re-upload this file with FTP to your server..

[Eleglin]

This reminds me this problem on 1.1.3 :
http://www.simplemachines.org/community/index.php?topic=189110.0

[bitmovel]

wow

that looks exatly the same problem I have

how could that be fixed?

[ThorstenE]

from the other topic

This bug exists (at least) in the *official* SMF 1.1.3 search function, and will affect all SMF 1.1.3 forum owners without MySQL privilege to CREATE TEMPORARY TABLES.

can you verify the permission? open phpMyAdmin with the same user SMF connect to the database, then execute the following query in the sql window:

Code Select Expand

CREATE TEMPORARY TABLE tmp (test INT(4));

is there an access denied?

[bitmovel]

successfully created the table

any other suggestion?

[LOADING...]

looking forward to know more

[ThorstenE]

bitmovel,
can you post a link to your forum?

The Sources/Search.php seems to have a bug.. download SMF 2.0b4 from our downloads page, extract the package and re-upload this file with FTP to your server..

have you already tried this?

[bitmovel]

I am already using 2.0 b4 now. I have updated 2 days ago, and that didnt fix it

link? sure: nsubs(dot)com

[ThorstenE]

from my view the search looks fine.. is it possible that only words from your special charset (it's spain?) are not working? Words in Standard ASCII were found always: tested with "novo forum", "The Seeker", "administradores" ..

maybe it's an UTF-8 problem?! which collation is used for the database? your language file seem to be standard ISO-8859-1..

[bitmovel]

thank you for the reply.

as stated before, I will place an exact sample of the errors.

Allow me to remember that this is a temporary error. Now it works, and now it doesnt.

This is a really strange error. Its not easy to explain.


Here is a sample:

1. I search 'war' and it shows correct results
2. A few hours later, i search 'war' again, and it shows search results for the word 'heroes' (this was an earlier search made by another user. It was not me who made it, but search results were stored and shown again by some readon)

This exact error happened, with exact words searched. It is a real example. As you see, its not utf-8 related.

btw. its portuguese, not spanish.

[LOADING...]

Any new updates on this subject!!

[bitmovel]

no. no updates

problem remains

[ThorstenE]

bitmovel,
I noticed from other topics that you have modified the Sources/Search.php

http://www.simplemachines.org/community/index.php?topic=265265.msg1730920#msg1730920

Can you please undo all these changes to Sources/Search.php and /Themes/yourtheme/Search.template.php and then test it again..

maybe it's the best solution to replace both files with a fresh downloaded version..

[LOADING...]

This could help 

[bitmovel]

I have done it already.

It did not work.

For some strange reason, i found a temporary bug fix

check homepage nsubs(dot)com

you have a custom search.

if i search in all topics, it works ok every time.

i I search on a specific board, it doesnt.

in default smf search same thing happened. searching current board, or current topic, generated the error results.

but searching all boards it worked.

Why could that be?