Restoring a deleted member

[CrashPush]

My vBulletin installation is acting crazy ever since I updated to 3.7.2 PL2. I now noticed a deleted member from my forum.

It now shows his username and postbit like this:

Ulmer Park
Guest

With his posts followed after. I did not delete this user and I never had any intentions of deleting this user. He is off the memberlist. I am the only administrator on my forum.

How did this happen? What is the best way to restore this member?

[Steve Machol]

1. I have no idea how it happened. Someone either deleted this user or you installed a mod that caused this.

2. You can't restore a deleted member. You can manually add a new user, then to add the old posts to the new user, run this query:

UPDATE post SET userid='xxx' WHERE username='Old Name';

...with 'xxx' being the userid number of the new account and 'Old Name' being the user name on those posts.

After that, rebuild the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

[CrashPush]

1. I have no idea how it happened. Someone either deleted this user or you installed a mod that caused this.

2. You can't restore a deleted member. You can manually add a new user, then to add the old posts to the new user, run this query:

UPDATE post SET userid='xxx' WHERE username='Old Name';

...with 'xxx' being the userid number of the new account and 'Old Name' being the user name on those posts.

After that, rebuild the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

Thanks for the response Steve I will do just that.

Quick question, last night my forum received a error 127 on mySQL, could it have been when I repair/optimized the tables that this user could have been deleted?

[Steve Machol]

It's possible but not likely since that error was for the usergroup table.

[CrashPush]

UPDATE post SET userid='xxx' WHERE username='Old Name';

...with 'xxx' being the userid number of the new account and 'Old Name' being the user name on those posts.

After that, rebuild the "thread" and "forum" counters in that order.

This worked flawlessly but I also had to run "update post counts" to get the post counts back to the user. Perfect!

Thanks Steve!

[creative-friends]

1. I have no idea how it happened. Someone either deleted this user or you installed a mod that caused this.

2. You can't restore a deleted member. You can manually add a new user, then to add the old posts to the new user, run this query:

UPDATE post SET userid='xxx' WHERE username='Old Name';

...with 'xxx' being the userid number of the new account and 'Old Name' being the user name on those posts.

After that, rebuild the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

i didnt get this bit.....

(UPDATE post SET userid='xxx' WHERE username='Old Name'; )
the same happend to me one of my team members is deleted i wana add all the post to the new user i have created.....

but i dont know how to do this

(UPDATE post SET userid='xxx' WHERE username='Old Name'; )

[creative-friends]

This worked flawlessly but I also had to run "update post counts" to get the post counts back to the user. Perfect!

Thanks Steve!

by updating posts i have lost alottt of posts of my other memberss

[Steve Machol]

Please start your own thread with all the relevant details. Thank you.