No announcement yet.

How to undelete a user or restore the posts for a user that was deleted

  • Filter
  • Time
  • Show
Clear All
new posts

  • How to undelete a user or restore the posts for a user that was deleted

    An administrator deleted a user with lots of posts by mistake.

    Is there a way to restore the user and all the posts? (all messages were sent to the generic "Guest" user)

  • #2
    You cannot undelete a user. You would have to create a new user.

    If you don't let guest users post, you can re-assign the posts to this new user using a SQL query like "UPDATE node set userid=XXX where userid=0;" XXX would be the userid of the new user. Though, I recommend making a complete database backup before doing this.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.


    • #3
      Wayne you are a lifesaver, it worked great!


      • #4
        The same deleted (now undeleted) user lost his avatar. Do you know a way to restore or get the .gif from somewhere?


        • #5
          Originally posted by avega View Post
          Wayne you are a lifesaver, it worked great!
          I just noticed that in the forum and searches some topics still say that it was initiated by 'Guest' is there a maintenance tool to update this?

          If I hover over 'Guest' the profile link is

          how to change the 10196-guest to the real nickname?


          • #6
            You have to remember you haven't "undeleted" the user, you have recreated it from scratch. You will need to manually upload any avatar or other profile elements, as these no longer exist.

            Updating the topic and forum counters and clearing the system cache should make the correct user show, if you've done it correctly.

            TalkNewsUK - My vBulletin 5.4.2 Demo - FEATURING "ROUTE BY NODE"!
            AdminAmmo - My Cloud Demo