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...A XenForo to XenForo importer doesn't exist.
Is there still no way to merge accounts?
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';
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
I did, I didn't lookDid you rebuild the user post counts? Do the posts themselves reflect the change?
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';
SET user_id = new_user_id, username = 'new username'
WHERE user_id = old_user_id, username = 'old username';
wouldn't I need?
Code:SET user_id = new_user_id, username = 'new username' WHERE user_id = old_user_id, username = 'old username';
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.wouldn't I need?
What version of XenForo are you using? 1.2 introduced easy way to merge users.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.
Really? I saw it in the "New Posts" tab and responded to the latest comment thinking it was new... aah my bad.That post is over a year old
Liam
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.Really? I saw it in the "New Posts" tab and responded to the latest comment thinking it was new... aah my bad.
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.What version of XenForo are you using? 1.2 introduced easy way to merge users.
We use essential cookies to make this site work, and optional cookies to enhance your experience.