Merging two users as one

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
op76
Registered User
Posts: 111
Joined: Thu Oct 10, 2002 11:01 pm
Location: Finland
Contact:

Merging two users as one

Post by op76 » Wed Aug 20, 2008 2:12 pm

How can this be done? I merged two forums, and now I'm drowning to emails, where users want to merge two user accounts, some of them were same usernames already, but in merging, the script didn't recognise them to same, because email address was different.

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Merging two users as one

Post by ric323 » Wed Aug 20, 2008 11:41 pm

HOW did you merge two forums?
Should this question be in Support rather than Convertors?
(Convertors is for when you are converting from some other BB software to phpBB.)
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Merging two users as one

Post by D¡cky » Thu Aug 21, 2008 3:20 am

The easiest way is to make the user's name, email and password the same and run the merge again. Otherwise, you have to edit the database manually, updating the post counts and setting the user_id for posts, pms, etc.

Moving to support.
Have you hugged someone today?

op76
Registered User
Posts: 111
Joined: Thu Oct 10, 2002 11:01 pm
Location: Finland
Contact:

Re: Merging two users as one

Post by op76 » Thu Aug 21, 2008 9:34 am

Could some of you computer Wizards make me some sql-script, which I can just run on phpMyAdmin? I would be very greatful. Basically I need to:

@old_name
@new_name
@old_id
@new_id

Then just replace from all posts, poster_id (old_id) to new_id.
Count new_name's posts again.
Delete old user?

Is that correct? I'm not very comfortable with sql...I understand it somehow, when I see a script, but I'm not sure how to write one.

Locked

Return to “2.0.x Support Forum”