XF 1.3 User showing as "guest"

[nodle]

I have a user that shows as a "guest" he is not associated with any group. He was leftover from a import from IPB way back in the day. He later joined under a different name. All his post show but there is no account associated with him such as a user, banned, etc. He is just a "guest". Is there any way to associate this with an account so I can have control to say merge it with his other account etc.? Or has anyone else run into this problem and were able to resolve it? Thanks for the help.

 

[AndyB]

I would like to go through and reassign many of those guest posts to current members (when I can ID who is who).

You can use this add-on:

https://xenforo.com/community/resources/change-author.2832/

 

[Movie Prop Sites]

@AndyB, that is SUPER slick! The only issue I am seeing is that I have thousands and thousands of posts like this and was hoping for something that could go through and pull all the guest posts with the same name and reassign them to an existing user as opposed to doing it one post at a time. Do you have any suggestions for that?

 

[unproperlypropagated]

Yes I tried but it would work importing him. This was what I used for him.

UPDATE xf_post
SET user_id = 21, username = 'C Pav'
WHERE username = 'Corey'
AND user_id = 0;

UPDATE xf_thread
SET user_id = 21, username = 'C Pav'
WHERE username = 'Corey'
AND user_id = 0;

I just wonder if it can't work because it can't find the old user named "Corey" because he doesn't exist? I also believe I tried his name as C_Pav since he has a space in it.

This still works in 2.3!
Any idea what cache to rebuild so the posts assigned to user show up in their profile?

EDIT:
after that query:
1) Rebuild user post counts
2) rebuild Rebuild search index