XF 2.2 Assign posts by unregistered user with specific name to registered user

[Race Sim Central]

Hi,

Is it as simple as inserting a user id into a posts table where the name of the unregistered poster matches? Or is there something else that needs to be done somewhere else in the database?

This has happened after importing, where some users were not imported and merged for some reason but their posts were.

Thanks

 

[Paul B]

Is it as simple as inserting a user id into a posts table where the name of the unregistered poster matches?

No.
A lot of data needs to be updated.

It would require an add-on or a script with custom queries.

 

[Race Sim Central]

It actually seems that changing the user_id to match the registered users id in the xf_post table then rebuilding caches does absolutely everything that's required. No? What am I missing?

 

[jmmp]

@Race Sim Central

Did that work what do you say? I want to do the same as you.