Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: Surgical Aplomb on March 17, 2011, 12:31:59 AM

Title: Merging two user accounts?
Post by: Surgical Aplomb on March 17, 2011, 12:31:59 AM
Hello everyone,

I'm currently trying to merge two of my forum's user accounts with each other. One is a deleted member and the other isn't. I'm currently on SMF version 1.1.13.

My plan is to merge the two accounts together so that the posts from the deleted account will become the posts of the active account. I ran this query in PhpMyadmin:

QuoteUPDATE smf_messages SET ID_MEMBER = 'ID', posterName = 'NAME' WHERE posterName = 'NAME';

But rather than merging the two accounts into one, it has changed the deleted account's username to the active one's name but has remained deleted.

Does anyone know how I can merge them into one account?

Thanks.
Title: Re: Merging two user accounts?
Post by: JimM on March 24, 2011, 07:25:41 AM
This topic should help you:

http://www.simplemachines.org/community/index.php?topic=212588.0