Announcement

Collapse
No announcement yet.

Restoring a deleted member

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    Please start your own thread with all the relevant details. Thank you.

    Leave a comment:


  • creative-friends
    replied
    Originally posted by CrashPush View Post
    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

    Leave a comment:


  • creative-friends
    replied
    Originally posted by Steve Machol View Post
    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'; )
    Last edited by creative-friends; Thu 3 Sep '09, 4:23pm.

    Leave a comment:


  • CrashPush
    replied
    Originally posted by Steve Machol View Post
    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!

    Leave a comment:


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

    Leave a comment:


  • CrashPush
    replied
    Originally posted by Steve Machol View Post
    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?

    Leave a comment:


  • Steve Machol
    replied
    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

    Leave a comment:


  • CrashPush
    started a topic Restoring a deleted member

    Restoring a deleted member

    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?
    Last edited by CrashPush; Mon 25 Aug '08, 6:42am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X