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

[GGFan]

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

[Steve Machol]

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!

[filburt1]

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

[GGFan]

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

[Steve Machol]

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.

[GGFan]

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.

[mcahill]

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

[charmer]

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

[mcahill]

try this...

'user name' instead of username

[charmer]

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

Any ideas as to what is wrong?

Cheers

[charmer]

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

[OttoBomb]

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.

[OttoBomb]

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