XF 1.2 Merging existing user with deleted user?

[Moddis]

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.

 

[Paul B]

That's not possible.

 

[Moddis]

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.

 

[Moddis]

Opps, almost forgot about the user id. Thanks!

 

[Jake Bunce]

It's possible to reassign posts with queries:

http://xenforo.com/community/threads/can-i-combine-2-accounts.23722/#post-415713

You need to match the old posts using the old username.

 

[Moddis]

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.

 

[Jake Bunce]

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.

http://xenforo.com/community/threads/can-i-combine-2-accounts.23722/#post-415795

 

[Moddis]

Cool!