I just had to migrate my database from one server to another, and there seems to be some kind of problem. I have a user (one that I can find now) that has his account gone, but some of his posts remain.
I've done searches through the database and found 7 threads and 29 posts that have his postuserid and postusername in there, but his user record does not exist.
What can I do to assign all of the things that remain in the database to an existing account? I imagine that if I run the update counters stuff, it will delete the rogue threads instead? I want to give this user back his previous existance, or as much of it as I can find...rep, attachments, profile, posts, threads, pm's, etc...
Whats the best way to go about that?
Are there any queries I can run to determine if there are any other things that are missing accounts?
__DEFINE_LIKE_SHARE__
|