debdee_MI wrote: I have gotten the mod to run to completion, but still not receiving any search by keyword results.
debdee_MI wrote: I am using 2.0.21. I have moved my forum from one site to another. The search by keyword is not working. I have a little under 6,000 posts.
I have installed your mod and have run it numerous times. It keeps timing out, even when running 1 post per cycle. It will get about 1/3 done, after about 3 hours, and it will time out. I try to restart from where it stopped, and it will time out and not restart, even waiting hours after the timeout.
Lostboy wrote: Great mod! Thank you. I'm a bit new to mods, but I've done everything and it's worked out great. I have one question, which is probably very simple, however I thought I'd ask as I wouldn't want to mess anything up.
Now that I've used this mod to rebuild my search, how can I remove the mod. I like to have my forum nice and clean, free of mods.
I'm guessing that I just go backwards from what the installation instructions are, however just to make sure that in phpMyAdmin, I just simply delete the "phpbb_search_rebuild" file correct?
I don't think this is a hard question, but I just thought I'd ask to make sure before I go deleting stuff. Thank you!
chatasos wrote: Do you get any error?
What does the progress screen say when the mod timeouts?
fragile_swamp wrote: This mod is very useful, but it's a pity, that there are no any standalone version to run from unix console. So, such script could be protected from loosing http-connections, exceeding time limits and so on.
I just ran across a problem where the "Rebuild Search" function that - to the best of my knowledge - had always been part of the original PHPBB wasn't working. Mind you, I'd not used it in years, but it was always there in the ACP menu if I ever needed it again.MOD Database Manager wrote: Classification: 52 Admin Tools
MOD Name: Rebuild Search
MOD Description: This mod allows admins to index all posts in their forum by rebuilding the search tables. Rebuild progress can be stopped and resumed at a later time and some time/db statistics are displayed while rebuilding.
Code: Select all
File: /public_html/includes/functions_search.php Line: 368 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY word_id HAVING COUNT(word_id) = 1' at line 3 Code: 1064 Query: SELECT word_id FROM phpbb_search_wordmatch WHERE word_id IN () GROUP BY word_id HAVING COUNT(word_id) = 1