Previous Thread
Next Thread
Print Thread
Rate Thread
#275678 06/30/2004 10:28 PM
Joined: Jan 2002
Posts: 674
Junior Member
Junior Member
Offline
Joined: Jan 2002
Posts: 674
My site had a hiccup yesterday and it deleted one of my users(paying one). I can't get the mysql logs to show because of timing out. Nothing shows in the admin log for deleting members either. We did experience max online users yesterday, perhaps this contributed to the deletion.

I am wondering if I lost other members on this one and they haven't found it yet. Ideas?

Sponsored Links
Kelly #275679 06/30/2004 10:42 PM
Joined: Sep 2003
Posts: 488
Code Monkey
Code Monkey
Joined: Sep 2003
Posts: 488
I had something like this occur as well a few months back. One of our members mysteriously vanished from the database for some unknown reason (the database has never been altered in any way either, nor had any tables been repaired up until that point). Luckily it doesn't occur very often.

Perhaps merely optimizing it could occassionally cause this, not entirely sure.

Kelly #275680 07/01/2004 12:54 AM
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Actually your user's table was corrupt - and when I ran the repair table command, the record count was off by one. Which usually either means the record count was off.... or there was one record that it couldn't be repaired. That happens from time to time when a table get's corrupt, that's what the repair table command does, remove the corrupt data.

The mysql logs were probably huge because MySQL on the box you were on did go down briefly yesterday- so you might not be able to open them through admin, you'd probably have to open them directly. But they won't really have any clues.... lots of unable to connect to messages, because MySQL wasn't running while everything had to get rebooted.

If you know who the user was - and if we can figure his usernumber, we can simply recreate him (with the same user number) and all shoudl be fine (he'll still have all his posts etc....)

If you know who he was, and can help me figure out his usernumber etc.... PM me the details and I'll recreate him.

Daine #275681 07/01/2004 1:01 AM
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
OK - actually you were missing 2 users.

User# 421 had 153 posts.

User# 3963 had 1 posts.

I created placholders for both. View the profiles and click to see all their posts, then tell me what the usernames should be and I'll edit the usernames/login names. Then all they will need to do is recomplete their profiles.

Daine #275682 07/01/2004 4:04 AM
Joined: Jan 2002
Posts: 674
Junior Member
Junior Member
Offline
Joined: Jan 2002
Posts: 674
missing1 #421 one is bbob with 153 posts he registered again today and had pointed it out to me. No idea on #3963

Sponsored Links
Kelly #275683 07/01/2004 4:05 AM
Joined: Jan 2002
Posts: 674
Junior Member
Junior Member
Offline
Joined: Jan 2002
Posts: 674
appreciate the help

Kelly #275684 07/01/2004 4:12 AM
Joined: Jan 2002
Posts: 674
Junior Member
Junior Member
Offline
Joined: Jan 2002
Posts: 674
user bbob is new user # 4171

Kelly #275685 07/01/2004 9:23 PM
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
He's all reconnected to his posts. Back at user #421.

Daine #275686 07/02/2004 3:22 AM
Joined: Jan 2002
Posts: 674
Junior Member
Junior Member
Offline
Joined: Jan 2002
Posts: 674
tank ye


Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)