Page 1 of 19

[2.0.21] Rebuild Search

Posted: Mon Oct 03, 2005 2:19 pm
by Extensions Robot
MOD Name: Rebuild Search
Author: chatasos
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.



MOD Version: 2.4.0 (Updated 07/21/06)

Download File: rebuild_search_2.4.0a.zip
mods overview page: View
File Size: 52273 Bytes

Support for this MOD needs to be asked within this topic. The phpBB Teams are not responsible or required to give anyone support for this MOD. By installing this MOD, the phpBB Support Team or phpBB MODifications Team may not be able to provide support.

This MOD has only been tested by the phpBB MOD Team with the phpBB version in the topic title. It may not work in any other versions of phpBB.

Posted: Tue Oct 04, 2005 9:13 am
by ycl6
MOD Validated/Released

Notes:
In case you encounter problems with your search table (in database), you can easily use this MOD to rebuild it.
Image

Thanks

Posted: Tue Oct 04, 2005 2:33 pm
by ellingsworth
Thanks for this mod. I was working with my DB recently and had trouble restoring the rather large search tables. For some reason i was getting a duplicate key error. In any case, i can now adjust my backup scripts to not backup those large tables and use this to re-create them.

The UI is VERY well done.

Posted: Tue Oct 04, 2005 3:18 pm
by chatasos
The following is from the author notes and i'm just putting it here in order to make it more clear about the usage of this mod:

Code: Select all

##	This mod will index every post in your forum, rebuilding the search tables. 
##
##	This is useful when :
##
##	- You have imported posts from another forum 
##	- You have lost/deleted/corrupted your phpbb search tables in one way or another
##	- You want to transfer your db to another server (you can skip the copying of search tables 
##	  which are usually quite a lot of MB and create them on the new server from scratch)
##	- When you have updated the "search_stopwords.txt" file (running the mod will remove these words from the search tables)
##	- Users cannot find what they are searching for in your forum (although there could many other reasons for this)
##
##	You can stop whenever you like and the next time you run it again, you'll have the option of 
##	continuing from where you left off.
##	
##	It may take a long time to show its progress (depending on "Posts per cycle" and "Time limit"), 
##	so please do not move from its progress page until it is complete, unless of course you want to interrupt it. 
Also here you'll find the topic in the development forum, where you can find possible answers to your questions.

Posted: Tue Oct 04, 2005 9:40 pm
by BladeOfAnduril27
Excellent mod!!! Thank you for creating it. I've been in need of something like this for a long time. As said before, the UI is very good!!

Posted: Wed Oct 05, 2005 3:57 am
by MoLew
I guess I jumped into this one a day too soon. Just last night I used the latest development version to repair the non-functional keyword search on my forum.

Brief background: after having my forum moved to several different servers by my web hosting outfit, there was bound to be something wrong. The first couple prolems were minor, and corrected via phpMyAdmin with simple "repair table" commands. Those were not related to the search funtioning however. Ever since my forum landed in it's current server, the keyword search was messed up. The search could only find items posted within the last couple weeks - the time frame of the last server move. The lack of a reliable forum search quickly proved to be a major irritation for myself, forum moderators and forum members.

I went searching for a solution. I found this mod, in it's developement/pre-approval stage. I looked to be just what I needed, and had the benefit of being tested and tweaked by many others before I found it. I'm usually reluctant to install mods not fully approved by the phpBB mod authorities. Especially mods that leave no doubt they intend to work your database hard. With more than a little trepidation, and fresh backups close at hand, I began the processing.

27,000+ posts were processed in 41 minutes.

Now my forum has it's full keyword search functionality restored. :D

My forum's members, moderators and I all thank you very much for this very useful tool. 8)

Posted: Wed Oct 05, 2005 9:15 am
by chatasos
Thanks a lot guys :wink: :D

Posted: Wed Oct 05, 2005 7:07 pm
by kukacomone
Very nice, very nice!! Thank you!

Posted: Thu Oct 06, 2005 1:17 am
by da_badtz_one
This is a wonderful tool, I was able to restore my forum back into working shape in no time because the database was big and by removing all of the search tables, it saved a lot of time. My members were already complaining about the search having problems, etc. And now that I've run this tool, everything is fixed with regards to the search part of phpBB :)

Thanks chatasos!!

Posted: Thu Oct 06, 2005 3:27 pm
by »»EDDY««
GJ.

Posted: Fri Oct 07, 2005 5:27 pm
by doddjames
I'm just doing a dummy-run move of my forum onto a different server and this is just what I've been looking for. Cool!

Does it work with 2.0.10 though? That is the version I've got installed right now and I really must move server before upgrading..

Posted: Sat Oct 08, 2005 4:02 pm
by chatasos
doddjames wrote: I'm just doing a dummy-run move of my forum onto a different server and this is just what I've been looking for. Cool!

Does it work with 2.0.10 though? That is the version I've got installed right now and I really must move server before upgrading..


Hi doddjames,

There should be no problem running this mod with 2.0.10, but i would really recommend to update to the latest phpbb first (security reasons) and then run the mod.

Posted: Sun Oct 09, 2005 12:02 am
by James78
Very useful mod. It fixes problems with the search table correctly and accurately :D

Posted: Sun Oct 09, 2005 6:09 pm
by cruisemates
chatosos...

We flapped gums on your development board. I am the one with 706,000 posts. I have already moved my phpbb to a new working server, but I got so wrapped up in my DNS-switch timeline (wanting to do the transition this weekend) that I forgot to do the indexing before I did it.

Let me ask you this; the phpbb tables on my old server are up to date through yesterday. Could I run your mod on THOSE boards and then import it to my new server, and then will my new server phpBB continue building this index based on the one I imported?

Posted: Sun Oct 09, 2005 6:30 pm
by chatasos
cruisemates wrote: chatosos...

We flapped gums on your development board. I am the one with 706,000 posts. I have already moved my phpbb to a new working server, but I got so wrapped up in my DNS-switch timeline (wanting to do the transition this weekend) that I forgot to do the indexing before I did it.

Let me ask you this; the phpbb tables on my old server are up to date through yesterday. Could I run your mod on THOSE boards and then import it to my new server, and then will my new server phpBB continue building this index based on the one I imported?


cruisemates, if the posts table on the new forum is copied from the old forum, then there should be no problem running my mod on the old forum and then transfering the 2 search tables to the new forum. But you'll have to transfer mod's table too, if you want to continue the rebuidling on the new forum.

Please note that if you have your new forum active, some posts may have been already indexed, so you can't transfer your old search tables unless you overwrite them.