PDA

View Full Version : Has anyone tried this as a forum fix?


BWD
4-16-05, 06:39 PM
I know we are having problems with MySQL and it's affecting php bulletin boards (corrupting the databases when users try to post, thus requiring 'repairs' that don't last long before more repairs are needed).

My question is this....has anyone tried closing their forum and DELETING all the posts made since this problem arose? (by my estimation on my own board it started yesterday afternoon). I'm just wondering if the posts made when the MySQL servers were being 'maintenanced' are causing forums to corrupt. Even when I repair my forums some information is still incorrect (ie. number of posts in a thread is wrong, for example, and posts made when the board was in a semi-corrupt state don't show up on the last post line) and I just wonder if it's those posts made in that time frame that are causing the repeated subsequent corruptions and if just deleting them all would restore the forum to a more stable place.

Anyone?

phoginator
4-16-05, 07:18 PM
No- but let me know if it works. ;)
And it's not just forums having the problems- though forums are more susceptible to crashes since new data is being added regularly. I was adding a bunch of images at the time of the crash- thinking of deleting them all and trying again though- bettter than doing nothing for the last 24 hours.

phoginator
4-16-05, 10:42 PM
Well that worked for me BWD- thanks for putting the bug in my ear. Hopefully can at least solve a few other's problems as well.

msxsecurity.com
4-16-05, 11:00 PM
for a invision fix go here http://forum.powweb.com/showthread.php?t=50071

Cocomoe
4-18-05, 04:31 PM
I did not work for me. I put up a new site with a DB all to it's own. Ran for most of the setup processes then I had to repair the tables while I was creating the user groups for it.