[Phalynx]

Originally Posted by RenatoMN

Hello, Phalynx.

I just upgraded a vB from 3.7.2 to 3.8.4 using ImpEx, instead actually doing an update. I was not careful enough to create the admin account in the new vB with a diff. e-mail from the admin in the old vB, so this user was NOT migrated. The posts and threads are there, with "RenatoMN" as a unregistered user.

May you explain how can I find all posts/threads from this unregistered user and change the owner to my new user without need to browse all the forums? The posts aren't returned when I search posts by author username.

Regards,
Renato

You will need to run SQL Queries to accomplish this to all postings:

PHP Code:

update post set userid=1 where username="User"
update thread set postuserid=1 where postusername="User" 


Replace userid/postuserid with the UserID of the new owner, also replace "User" with the Username of the old user.