XF 1.2 Merging existing user with deleted user?


Active member
I know there is an option to merge users but is it possible to merge an existing user with a deleted user? Basically, looking to merge posts of a specific "Guest" member to a real active member.


Active member
Ok I guess I can try manually changing in the db:

UPDATE xf_post SET username = REPLACE(username,'deleted_user','activeuser');

Hopefully there is nothing else that needs to be updated anywhere to keep everything working correctly.


Active member
You would have to use a query...

UPDATE `xf_post` SET `user_id`='<existing user id>' , `username`='<new username>' WHERE (`user_id`='0') AND (`username`='<guest username`);
UPDATE `xf_thread` SET `user_id`='<existing user id>', `username`='<new username>' WHERE (`user_id`='0') AND (`username`='<guest username`);
Note: Untested

@Moddis make sure you check the edit
Thanks, this looks good but dont you(or should you) also have to also chnage the username colum to the new username as well? Those just seem to change the username id.