Rebuild Search Index after upgrading to 3.0.3

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Ingimar
Registered User
Posts: 6
Joined: Sun Nov 03, 2002 10:31 am
Location: Iceland
Contact:

Re: Rebuild Search Index after upgrading to 3.0.3

Post by Ingimar » Sun Feb 22, 2009 9:56 pm

I seem to be having the same issue here. The search indexing (native) is taking a long time and seems to stopped looping somewhere around post id 1500.

The board was upgrated from 2.0.23 to 3.0.4.

Board statistics: Total posts 410279 | Total topics 31125 | Total members 3101

We're running on Debian 5.0, PHP 5.2.6, Apache 2.2.9, MySQL 5.0.5. Tables are MyISAM

Any/all suggestions are welcome!

I have tried starting the indexing again after changing some search parameters but it always starts looping at the same place. The indexing has been running for many hours and I'm afraid that if it eventually will finish I just get the same problem with "common" words as mentioned in this thread. :-(

EDIT: I have auto-pruning enabled on one forum if that matters.. saw pruning mentioned somewhere when searching for this problem.

clight77
Registered User
Posts: 907
Joined: Sun May 11, 2003 11:09 pm

Re: Rebuild Search Index after upgrading to 3.0.3

Post by clight77 » Sat Mar 14, 2009 3:52 pm

Ran into the same problem looping at 1500 and search rebuild will not finish after 12 hours of running on a small board with 46000 posts.
Ended up using FullSearch Mysql but 5000 posts were not indexed and i can no longer search 3 letter words.
I Follow Up On My Posts.
So Should Everybody...

ekamei
Registered User
Posts: 31
Joined: Tue Jan 13, 2009 2:59 pm

Re: Rebuild Search Index after upgrading to 3.0.3

Post by ekamei » Thu Apr 16, 2009 10:09 pm

Same problem here. I have read thought this post and a few other and followed all the recommendation I can find so far. Nothing is working.

The site is a dedicated host.

clight77
Registered User
Posts: 907
Joined: Sun May 11, 2003 11:09 pm

Re: Rebuild Search Index after upgrading to 3.0.3

Post by clight77 » Fri Apr 17, 2009 3:04 am

ekamei wrote:Same problem here. I have read thought this post and a few other and followed all the recommendation I can find so far. Nothing is working.

The site is a dedicated host.
In my case i had my host run the rebuild and they found issues,I had them enable 3 character search,all is fine now.
I Follow Up On My Posts.
So Should Everybody...

Locked

Return to “[3.0.x] Support Forum”