|
Joined: May 2003
Posts: 3
Lurker
|
Lurker
Joined: May 2003
Posts: 3 |
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!]
Last edited by Foxtrot_Xray; 08/08/2003 12:10 PM.
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
Addict
Joined: Aug 2000
Posts: 1,609 |
Yeah. .there are....I'll look for them and get back to you....
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
Addict
Joined: Aug 2000
Posts: 1,609 |
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
Addict
Joined: Aug 2000
Posts: 1,609 |
As far as your ranks...did you make sure you set them up after you "tinkered" with your DB?
|
|
|
|
Joined: May 2003
Posts: 3
Lurker
|
Lurker
Joined: May 2003
Posts: 3 |
[] As far as your ranks...did you make sure you set them up after you "tinkered" with your DB? [/] Aw, schweet, thanks for those. Looking at them now.. Actually, I really DID have a DB failure - even lost a user account (possibly why some posts are 'missing'.) However, to answer your question (because I DID tinker with it, a while ago for the user name/title effects..), 'No'. Didn't even occur to me that that woulda been necessary. Again, thanks! Mike.
|
|
|
|
Joined: May 2003
Posts: 3
Lurker
|
Lurker
Joined: May 2003
Posts: 3 |
Okay, strange. I still get differing counts, after running both scripts. (Only one found a wrong count, not in the board I was expecting.) If you look at my forums setup (not the best, I know. I'm NOT a designer..!) here, Go to "General", then look for the post "The Webmaster Chuckles Evilly..". In index it shows 19 replies. View the thread, and only 14 are found. Time to get down and dirty with the database, I'm fraid. Muhaha. Me. [Edit: Found the issue. Because that one user account got trashed and taken out of the table, none of the "B_PosterId" fields got updated. Since they were pointing to an invalid "U_Number" in the _Users table, they were getting skipped, but being counted in the index page. If anyone is interested (and since I actually haven't oeefered anything back to ThreadsDev yet..) I can make this into a small script to add onto the Admin menu, similar to the two utilities that were offered me earlier..]
Last edited by Foxtrot_Xray; 08/08/2003 5:05 PM.
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
Addict
Joined: Aug 2000
Posts: 1,609 |
So everything's groovy now? I suggest you get into the habit of backing up your database every so often.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 87
Joined: December 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|