I accidentally deleted one of my members, how do I get them, their posts, and all their information back?
I accidentally deleted a member, how do I get that member back?
Collapse
X
-
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.
-
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 usersComment
-
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
-
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.
MarkComment
-
try this...
'user name' instead of usernameComment
-
Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment