Previous Thread
Next Thread
Print Thread
Hop To
Problems with post counts #245504 09/16/2011 10:45 AM
Joined: Apr 2011
Posts: 31
Skyjammer Offline OP
newbie
OP Offline
newbie
Joined: Apr 2011
Posts: 31
Several users have lost post counts, some over a thousand and nothing was deleted from our forum.

Any idea as to what could be happening?

Re: Problems with post counts [Re: Skyjammer] #245505 09/16/2011 1:03 PM
Joined: Jun 2004
Posts: 207
cascadeclimbers Offline
enthusiast
Offline
enthusiast
Joined: Jun 2004
Posts: 207
Your user_profile table could be corrupted.


Won't you take me to Funkytown?
Re: Problems with post counts [Re: Skyjammer] #245506 09/16/2011 1:55 PM
Joined: Apr 2011
Posts: 31
Skyjammer Offline OP
newbie
OP Offline
newbie
Joined: Apr 2011
Posts: 31
Hmmm, OK how do I repair that?

Thanks!

Re: Problems with post counts [Re: Skyjammer] #245508 09/16/2011 3:22 PM
Joined: Apr 2011
Posts: 31
Skyjammer Offline OP
newbie
OP Offline
newbie
Joined: Apr 2011
Posts: 31
Nope, I haven't pruned anything yet. The forum is still pretty small.

Kind of perplexed, the total post count has not changed but our members counts under their names have.

Re: Problems with post counts [Re: Skyjammer] #245510 09/16/2011 4:14 PM
Joined: Apr 2011
Posts: 31
Skyjammer Offline OP
newbie
OP Offline
newbie
Joined: Apr 2011
Posts: 31
PHPmyadmin would be in cpanel?

My last b/u was 2 weeks ago and i figured I would lose recent activity if I restored from there.

If I manually edit the tables, I am not sure of the post counts for each member so I really don't want to do that.

Thank you Ruben!

Re: Problems with post counts [Re: Skyjammer] #245512 09/16/2011 4:43 PM
Joined: Dec 2003
Posts: 5,998
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,998
Yes cpanel should have phpmyadmin,usually.
Well if two weeks ago it was okay.
then I would make a additional current backup for safety.
Then just repair(if needed) and/or update the table user_profile
with the old backup.
You would of course loose any changes by the users to their profile since the old backup.

Then if all gets hosed up you can just restore the current backups to be what they are now.

Last edited by Ruben; 09/16/2011 4:58 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Who's Online Now
0 registered members (), 86 guests, and 378 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)