XF 1.1 Can i combine 2 accounts?

[Robby]

I have recently imported old members, is it possible to combine two accounts? So that the old posts of the member can combine with the new...

 

[Paul B]

A XenForo to XenForo importer doesn't exist.

 

[Robby]

A XenForo to XenForo importer doesn't exist.

No that's not what i mean, i mean i have allready imported users but at the same time some users had created a new account. Can i combine those two accounts so that they merge...

 

[Paul B]

Oh, you mean merge two users.

That's also not possible, but it has been suggested.

You could have merged them during the import, if their user name or email address had been the same.

 

[Brandon Sheley]

Is there still no way to merge accounts?

 

[Jake Bunce]

Is there still no way to merge accounts?

Still nothing. Though you can run queries to reassign threads and posts by user_id.

UPDATE xf_post
SET user_id = new_user_id
WHERE username = 'old username';

UPDATE xf_thread
SET user_id = new_user_id
WHERE username = 'old username';

Then run this to rebuild their post count:

http://xenforo.com/community/resources/rebuild-user-post-counts-query.363/

 

[Brandon Sheley]

woohoo, that works for me
thanks Jake!

hmm.. it didn't work
I still have 2 users, one with 200 post and one with 100
there should be one account with 300

 

[Jake Bunce]

woohoo, that works for me
thanks Jake!

hmm.. it didn't work
I still have 2 users, one with 200 post and one with 100
there should be one account with 300

Did you rebuild the user post counts? Do the posts themselves reflect the change?

 

[Brandon Sheley]

Did you rebuild the user post counts? Do the posts themselves reflect the change?

I did, I didn't look
I know there are still 2 member profiles, and the post count on the member page is off

I'll check

nope, showing old username
I'll try again

do there need to be ticks around the user id?

SET user_id = 'new_user_id';

 

[Jake Bunce]

No ticks around the user_id.

You can change the username too with these queries:

UPDATE xf_post
SET user_id = new_user_id, username = 'new username'
WHERE username = 'old username';

UPDATE xf_thread
SET user_id = new_user_id, username = 'new username'
WHERE username = 'old username';

 

[Brandon Sheley]

wouldn't I need?

SET user_id = new_user_id, username = 'new username'
WHERE user_id = old_user_id, username = 'old username';

I'm just not seeing any changed and it's still showing 200 post on the old ID in mysql

thanks for the help

 

[DRE]

I had to learn this after I accidentally deleted a member. Unfortunately you lose likes and other stuff.

 

[Jake Bunce]

wouldn't I need?

SET user_id = new_user_id, username = 'new username'
WHERE user_id = old_user_id, username = 'old username';

The old username is enough for the where condition. Or you can change the condition to check the old user_id. But you shouldn't need both.

 

[Kevin]

wouldn't I need?

Only if you ended up in the weird scenario where you have the same user name assigned to two different user IDs. As Jake said, as long as the user name is truly unique then it is enough for the query.

 

[snoopy5]

Hi

I have a the same issue with one user and 2 accounts. I tried all the SQL code above, but it does not work. What else could I try?

 

[Divvens]

Hi

I have a the same issue with one user and 2 accounts. I tried all the SQL code above, but it does not work. What else could I try?

What version of XenForo are you using? 1.2 introduced easy way to merge users.

 

[Liam W]

What version of XenForo are you using? 1.2 introduced easy way to merge users.

That post is over a year old

Liam

 

[Divvens]

That post is over a year old

Liam

Really? I saw it in the "New Posts" tab and responded to the latest comment thinking it was new... aah my bad.

 

[Paul B]

Really? I saw it in the "New Posts" tab and responded to the latest comment thinking it was new... aah my bad.

That's because Liam W replied to it a minute before you did but then realised it was an old thread so deleted his post, making it look like it was you who necroed it.

 

[Afra]

What version of XenForo are you using? 1.2 introduced easy way to merge users.

I am using xenforo 1.3.3. Please tell me how can I merge two admin accounts in a single account? I couldnt find any option in Admin CP.
Thanks