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

  • OttoBomb
    replied
    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 11 Oct '07, 12:19pm.

    Leave a comment:


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

    Leave a comment:


  • charmer
    replied
    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

    Leave a comment:


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

    Any ideas as to what is wrong?

    Cheers

    Leave a comment:


  • mcahill
    replied
    try this...

    'user name' instead of username

    Leave a comment:


  • charmer
    replied
    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

    Leave a comment:


  • mcahill
    replied
    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

    Leave a comment:


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

    Leave a comment:


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

    Leave a comment:


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

    Leave a comment:


  • filburt1
    replied
    You can't, deleted is deleted. The post should still be there, only they'll be set as a Guest post.

    Leave a comment:


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

    Leave a comment:


  • 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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X