Announcement

Collapse
No announcement yet.

Restoring a deleted member

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

  • 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.

  • #2
    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
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      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?

      Comment


      • #4
        It's possible but not likely since that error was for the usergroup table.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          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!

          Comment


          • #6
            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.

            Comment


            • #7
              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

              Comment


              • #8
                Please start your own thread with all the relevant details. Thank you.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...
                X