XF 1.4 Assigning posts from a deleted user to a new user

[TimeWizardCosmo]

Hi there,

I just acquired a community which had some issues with accounts being deleted. I'd like to reassign these posts to users who are now returning, but I'm not sure how to do this.

Here's an example of a post I want to reassign to a NEW user who is also named PaulaJedi.



Does anyone know of a query I can run to reassign these posts to her?

 

[Amaury]

@Chris D has an add-on that changes the author of threads that may help: https://xenforo.com/community/resources/change-thread-starter.1320/

 

[Martok]

See this thread:

https://xenforo.com/community/threads/user-showing-as-guest.76007/