Announcement

Collapse
No announcement yet.

I accidentally deleted a member, how do I get that member back?

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

  • I accidentally deleted a member, how do I get that member back?

    I accidentally deleted one of my members, how do I get them, their posts, and all their information back?

  • #2
    I'm afraid there's no easy way to do this. You could try restoring a backup of your database but of course you'd lose everything that's happened on your board since the backup was created.

    Maybe someone can come up with a very clever way to extract this one member's info and posts from a db backup. I don't think it'll be easy to do though. Good luck!
    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
      You can't, deleted is deleted. The post should still be there, only they'll be set as a Guest post.
      --filburt1, vBulletin.org/vBulletinTemplates.com moderator
      Web Design Forums.net: vB Board of the Month
      vBulletin Mail System (vBMS): webmail for your forum users

      Comment


      • #4
        Is there any way that that person could register again and then somehow transfer their old posts to their new name?

        Comment


        • #5
          As long as you didn't delete their posts when you deleted this account, then this may be possible using a query. We'd need a MySQL query guru to figure out the exact query though.
          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


          • #6
            Okay, I just checked and the posts did not get deleted. The username still appears although it says guest under it. The avatar is gone too.

            Comment


            • #7
              Here's how I did it...

              Had the same problem last week. This is how I fixed it, but if you don't know databases, you may want to get someone to help you. Your mileage may vary, no warranty, etc.

              Assuming you know the old user name and new username, user id, etc...

              In phpmyadmin (that's the database viewer most hosts offer for mysql) look at the database.

              obviously you need to replace newusername, oldusername, etc. with the right info.

              in the run sql query window do

              update post set username = newusername where username = oldusername

              update post set userid = newuserid where userid = olduserid

              update thread set postusername = newusername where postusername = oldusername

              update thread set postuserid = newuserid where postuserid = olduserid

              Then go to admin and recalc post counts or do a select on username in posts to find out how many posts and manually update their post count in admin.

              Hope it works for you.

              Mark
              Mark Cahill
              Reel-Time, the Internet Journal of Saltwater Fly Fishing
              Allthingscahill.com
              Splitcoaststampers.com

              Comment


              • #8
                Hi. it was me who got deleted

                I own the webspace so I have access to the MySQL area.

                The problem is that I had a space in my username and it gives me errors.

                What do I do now?

                Thanx

                Comment


                • #9
                  try this...

                  'user name' instead of username
                  Mark Cahill
                  Reel-Time, the Internet Journal of Saltwater Fly Fishing
                  Allthingscahill.com
                  Splitcoaststampers.com

                  Comment


                  • #10
                    Everything's fine now - except that i don't appear on the member list anymore.

                    Any ideas as to what is wrong?

                    Cheers

                    Comment


                    • #11
                      Originally posted by charmer
                      Everything's fine now - except that i don't appear on the member list anymore.

                      Any ideas as to what is wrong?

                      Cheers
                      Never mind lol

                      I managed to use a query given in another thread

                      Thanx anywayz

                      Comment


                      • #12
                        Originally posted by charmer View Post
                        Never mind lol

                        I managed to use a query given in another thread

                        Thanx anywayz
                        Hey charmer, do you by any chance remember what thread you found the query in? I've got a couple members that need the 'undelete' treatment.

                        Comment


                        • #13
                          I just realized the post is from 2002, and concerning version 2.x not 3.x. I feel dumb now.

                          I did finds some leads using the mighty search function however...
                          Last edited by OttoBomb; Thu 11th Oct '07, 12:19pm.

                          Comment

                          Loading...
                          Working...
                          X