XF 2.0 Anonymous Users

[Noble™]

Good morning. when i imported my DB from phpbb i had a few banned users on my forum - the posts show up as anonymous user how do i find them in the DB? i went through many of the tables with no luck.

 

[Noble™]

Has anyone else seen this?

 

[Paul B]

If the user names are not linked to an ID then they won't exist in the user table.

 

[Noble™]

Thanks Brogan, I see their posts in the tables listed as id 0 - is there a way i can change them so they show up as a a user again?

 

[Paul B]

No, those are deleted user accounts.

It's potentially possible by creating new accounts and reassigning posts, etc. to those accounts, but there would be a lot of tables to update and you would need a robust solution to ensure there would be no corrupt/orphaned data.

Alternatively, you could unban them in phpBB and assuming they are valid user accounts there, do the import again.

 

[Noble™]

Perfect thank you