Question on SMF forum search function

[basis]

I recently moved my forum to a new host. I followed the instructions given in the docs to perform my backup.
http://docs.simplemachines.org/index.php?board=83.0

After moving over, the search function doesn't work. I can type in a search, and the forum will just display that it is in the process of searching and it never ends.

I am wondering is this an SQL issue? That I perhaps did not backup the original database incorrectly? Or is it more of an internal forum issue? ...

Because when I moved over to the new host, I had to hand over the physical forum files & SQL DB to upload etc. When it was completed, most of the layout looked similar to my original forum, however I noticed 2 changes...

1. The forum's title had change (Admin > Server Settings > Forum Title)
2. The Board Category's names had changed. (Boards > Modify Boards tab)

I was wondering if either of #1 or #2 might also affect the search?

Thanks in advance for any help or suggestions offered.

[JimM]

Is the only issue the search?  Does spell check work?  If the only issue is the search, try the following query in phpMyAdmin (What is phpMyAdmin?)

Code Select Expand

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

Post the result.

[basis]

Is the only issue the search?  Does spell check work?  If the only issue is the search, try the following query in phpMyAdmin (What is phpMyAdmin?)

Code Select Expand

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

Post the result.

Hi JimM, thanks for replying.

hmm... now that you mentioned it, spell check doesn't work as well. it 'stalls' just like when I try to attempt a search. what could be possibly wrong? I'll try the phpMyAdmin query, but I'm no longer admin so it would take time to get the result.

[JimM]

Usually this means you new host didn't include the dictionaries when php was compiled.  If you turn spell check off and the search works, then that is most likely the problem.

[basis]

Usually this means you new host didn't include the dictionaries when php was compiled.  If you turn spell check off and the search works, then that is most likely the problem.

yes! you are so right! when i disabled the spell check option, i could get abit further into the searching... well it turned up this error instead:

DROP command denied to user 'xyz'@'70.154.151.41' for table 'smf_tmp_log_search_topics'
File: /hsphere/local/home/xyz/forum.storum.org/Sources/Search.php
Line: 1010

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.9, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

hmm my DB is ver 1.1.4?

[JimM]

The database version is an easy fix but you will need to be able to do it through phpMyAdmin.  Run this query:

Code Select Expand

UPDATE `smf_settings` SET `value` = '1.1.9' WHERE `variable` = 'smfVersion' LIMIT 1

Of course replace the smf_ with your prefix if you didn't use the default.

[basis]

Thanks JimM. I'll let the host provider know about it and feedback how it went.

[JimM]

Sounds good.  I'll check back tomorrow.

[basis]

It worked! ... sorta.

well search is back, but only if spellcheck is disabled.

how do i get search back WITH spellcheck? or am i gimped?

[JimM]

Can you post a phpinfo.php? (What is phpinfo.php?)

Contact your host with the spell check problem.  Ask them about the dictionaries being included.  Once that is done you should be able to turn spell check back on.

[basis]

Can you post a phpinfo.php? (What is phpinfo.php?)

Hi JimM, sent you a PM regarding the phpinfo.php. if there is anything amiss, do let me know. thx.

Contact your host with the spell check problem.  Ask them about the dictionaries being included.  Once that is done you should be able to turn spell check back on.

will get them to try and update the dictionaries. i do hope they know what i'll be requesting from them

[JimM]

Everything looks ok.  Try the short script linked to this post and let me know what the outcome is.

http://www.simplemachines.org/community/index.php?topic=269852.msg1766472#msg1766472

[basis]

Everything looks ok.  Try the short script linked to this post and let me know what the outcome is.

http://www.simplemachines.org/community/index.php?topic=269852.msg1766472#msg1766472

sorry for the long absence. thx JimM for the link above. tested it and yes the dictionaries are borked. sigh.

[JimM]

Have you heard anything from your host about possibly fixing the problem?  Additionally it would be adviseable to upgrade to 1.1.10 at you earliest convenience. 

[basis]

Have you heard anything from your host about possibly fixing the problem?  Additionally it would be adviseable to upgrade to 1.1.10 at you earliest convenience.

well i don't know if they fixed it or not, we thought they did but clicking the spell check button brought up a pop-up window and then nothing. the window just froze there.

and when spell checker was active - it borked the search function as well - which just kept going and going and going ...

yeh i'll upgrade to 1.1.10 soon.

[JimM]

Doesn't sound like they have responded yet.  They could easily fix the problem.  Might think about looking for a new host.  If this is solved please mark it solved by clicking the Mark Topic Solved link at the bottom left of the page.