• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 Can i combine 2 accounts?

Robby

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

Brogan

XenForo moderator
Staff member
#4
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
#6

Brandon Sheley

Well-known member
#7
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
#9
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
#10
No ticks around the user_id.

You can change the username too with these queries:

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
#11
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
 

snoopy5

Well-known member
#15
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?