Ok am back on line now. Thanks for your support and reporting on a few glitches. The server has been running very good after the database re-import. Response times still under 200ms. I think the database backup and following restore must have purged some deep corruption that the standard database tools could not get rid of. Here's hoping we have some stability for a while and can simply improve upon that. Looks like the crash, although stressful may have helped in the end. We'll see how it goes. There are still several issues with bad database queries (this is from poorly designed code or add-ons). I have a guru coder available to make new, more efficient codes that put far less strain on the server. I will setup a clone of APUG on a hidden domain for any further testing.
One more bit of corruption: clicking the "My Posts" link is showing up a couple of threads ("Identify this old Gitzo" and your friend's masters research thread) that I've never posted in.
i probably need to rebuild the search since we restored will do that in a few.
For those having trouble getting to the last page of some threads, I found the fix for that. A vBulletin utility is running right now that updates the thread/page counts. This will probably need to run for another 10mins before it completes, then the last pages should work fine. If not let me know. Thanks
*Actually just noticed, still some weirdness there with not showing additional pages in search results, investigating
search indexes have been rebuilt, any weirdness with "my posts" "my threads" should be ok now. At the moment I cut results back to 100 max, but will increase this again soon.
Ok I think all searches are working properly now (my posts) etc
Sean- Thanks for all you do.
Hi Sean, not sure if you've discussed previously, but I can't customise the sidebar any further than having "Recent Classifieds" appear, even though I've selected "My Recent Posts" to appear.