vBulletin Crashing Database each morning

[hilaryl]

Hi Zachery,

We are actually on 4.1.9 Patch Level 9 (I was incorrect earlier) - I don't imagine that makes things any better though.

We don't believe it's the hardware, because it's only started happening yesterday - and then again this morning. And there weren't any big changes made the day before the big crash.

I will talk to my host about vBulletin sphinx - but right now, we just need things going again.

We have managed to repair the tables and everything seems to be working now. With the exception of a glitch in certain threads where you can't get to the last page. One example being there are 12 pages, and even if you click on page 12, it only shows you the content of page 11. It even says page 12 in the URL.

I've read that this can fixed by Rebuilding Thread Information. Though there are 420,000 threads - should this be done with the forum offline?

Are there any other steps I should take after repairing database tables to kind of refresh the forum? Anything to do with the System Cache perhaps?

Thanks,
hilaryl