Maintenence? - 08/08/2003 6:56 PM
Hey guys.. Gotta quandary...
Either one of my tables is messed up, or my entire database is..
A week or so ago, I had my _Users table get majorly corrupted, so I had to do a MySQL "REPAIR TABLE" on it. Since around the same time period, some replies and posts have been found missing.
For example: On the main Index page, it will say that a post has 19 replies. Yet when you view it, it only shows 14 (threaded mode.) I just had a user get their "Post Count" past a new-title level, and their title did not automagically change.
Are there scripts that will go thru and fix counts/posts, etc? Any ideas?
Thanks!
Mike.
[Edit: This may have been brought up before.. I did a search, but I'm not sure what keywords to use, and the ones I chose came up with nothing. So if there are already threads that may help, please lemme know! Thanks!]
Either one of my tables is messed up, or my entire database is..
A week or so ago, I had my _Users table get majorly corrupted, so I had to do a MySQL "REPAIR TABLE" on it. Since around the same time period, some replies and posts have been found missing.
For example: On the main Index page, it will say that a post has 19 replies. Yet when you view it, it only shows 14 (threaded mode.) I just had a user get their "Post Count" past a new-title level, and their title did not automagically change.
Are there scripts that will go thru and fix counts/posts, etc? Any ideas?
Thanks!
Mike.
[Edit: This may have been brought up before.. I did a search, but I'm not sure what keywords to use, and the ones I chose came up with nothing. So if there are already threads that may help, please lemme know! Thanks!]