PDA

View Full Version : After importing IPB1.3-VB3, find all posts by x, crash the server


vip600
Fri 22nd Apr '05, 12:50am
Hello,

After importing IPB1.3-VB3 (with NO errors), When I view any profile and try to find all posts by x, the server crash immediately. On the other hand, The search in working fine, also Find all threads started by x is working fine.

I tried the following solutions but the problem still:

- I empty the indexes and rebuild search index (3 times)
- I used phpMyadmin to repair post,postindex, and posthash tables.

Now, I disabled the search temporary until this problem fixed.

My Forum Statistics are:
Threads: 28,098, Posts: 242,427, Members: 107,352

Could you please tell me how to fix this problem?

Thank you :)

Steve Machol
Fri 22nd Apr '05, 12:53am
What do you have set for:

Admin CP -> vBulletin Options -> Message Searching Options -> Maximum Search Results to Return

If the number is too large, it could overtax the server.

vip600
Fri 22nd Apr '05, 1:09am
The number was 500, I have change it to 10. Then the result of find all posts by x was a page of header and footer repeated 10 times.

P.S.
All files of the vBulletin 3.0.7 are original. I also did NOT install any hacks.

vip600
Fri 22nd Apr '05, 2:10am
Thanks a lot for trying to help me.

I have fixed the problem. It was from my style. When I revert (search_results_postbit) template the problem fixed.

Thanks for your time :)