XF 1.1 Can i combine 2 accounts?

Robby

Well-known member
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...
 

Robby

Well-known member
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...
 

Brogan

XenForo moderator
Staff member
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.
 

Jake Bunce

XenForo moderator
Staff member

Brandon Sheley

Well-known member
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
 

Brandon Sheley

Well-known member
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

XenForo moderator
Staff member
No ticks around the user_id.

You can change the username too with these queries:

Rich (BB code):
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

Well-known member
wouldn't I need?
Code:
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

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

Jake Bunce

XenForo moderator
Staff member
wouldn't I need?
Code:
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.
 

snoopy5

Well-known member
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

Well-known member
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.
 

Afra

Member
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
 
Top