XF 1.5 Change User ID or Post user ID

[Mattia Del Franco]

Hello,

I'm importing my database forum from vBulletin 4.x to Xenforo, but I had a problem: in vBulletin I had the first registered user with ID 0, now the importer (I don't know why) didn't import this user and so I have many posts assigned to a guest user.

Is possible to reassign this posts and threads to my user (I recreated it with ID 1, it's the user that XenForo automatically creates after the installation) by changing my user id to 0 or by changing all the post user id to 1?

 

[Mike]

Well a 0 user ID isn't a valid or expected ID in the source database.

You'd have to manipulate the database directly to reassign guest posts like this. It's not something I would recommend, but it is potentially doable.

 

[Mattia Del Franco]

Well a 0 user ID isn't a valid or expected ID in the source database.

You'd have to manipulate the database directly to reassign guest posts like this. It's not something I would recommend, but it is potentially doable.

Isn't there any plugin that could do this? Or you have some advice on which query I have to launch on the database?