Previous Thread
Next Thread
Print Thread
Hop To
Problems with post counts
#245504 09/16/2011 11:45 AM
Joined: Apr 2011
Posts: 31
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
Skyjammer #245505 09/16/2011 2:03 PM
Joined: Jun 2004
Posts: 207
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
Skyjammer #245506 09/16/2011 2:55 PM
Joined: Apr 2011
Posts: 31
newbie
OP Offline
newbie
Joined: Apr 2011
Posts: 31
Hmmm, OK how do I repair that?

Thanks!

Re: Problems with post counts
Skyjammer #245508 09/16/2011 4:22 PM
Joined: Apr 2011
Posts: 31
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
Skyjammer #245510 09/16/2011 5:14 PM
Joined: Apr 2011
Posts: 31
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
Skyjammer #245512 09/16/2011 5:43 PM
Joined: Dec 2003
Posts: 6,183
Likes: 28
Online Yawn
Joined: Dec 2003
Posts: 6,183
Likes: 28
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 5:58 PM.

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

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Disaster!!! Files became empty.. Please advise.
by Morgan - 07/27/2020 2:38 PM
Unable to Update Censor List
by BOTCuser - 07/22/2020 9:15 AM
7.7.4 error on rebuilders
by Ruben - 07/21/2020 3:06 PM
[STOCK] UBB.threads Group Image Pack
by isaac - 07/19/2020 9:03 PM
Who's Online Now
2 members (Ruben, 1 invisible), 63 guests, and 67 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
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