Rake task for merging users

(Gerhard Schlager) #1

The rake task for merging users is now available on tests-passed. :sunny:

Users can be merged by executing

rake users:merge['source_username','target_username']

This merges the data of the source user into the target user before it deletes the source user. The content of 45 tables gets merged, so depending on the amount of data associated with the source user this process can take a while.

Plugin authors can hook into the merge process by handling the :merging_users event. I’ve already implemented it for the polls plugin, which merges the votes of the two merged users.

Known problems:

  1. Incoming links that still reference the source user (e.g. https://talk.example.com/t/some-topic/17/3?u=source_username) won’t be associated with the target_user.

  2. A user can have only one shadow user (from the allow anonymous posting feature). So, if both merged users had a shadow user, then the one owned by the source user will be lost… well, it’s still there, but not associated with an existing user anymore.

Discourse 2.0.0.beta4 Release Notes
Ability to merge users
Is there a way to merge accounts?
How to move posts from one account to other in Discourse
Merge/change accounts after SSO
Change email for SSO user?
Configuring Patreon integration with Discourse
(Dave McClure) #2

Ooh… That’s the most exciting part of this to me.

(Sam Saffron) #3

We should try this out on some of the accounts at rubytalk.org … a great little test site, Matz has like 5 emails.


Thank you for this feature, it is huge for my use case! I am currently porting our forums from phpBB to Discourse and wanted to use SSO via a custom provider. Since we could not easily link SSO accounts to our legacy accounts and works flawlessly!

If anyone else is going to use this make a note of this:

rake users:merge['mattbr_sso', 'mattbr_legacy'] will not work as expected, the SSO will not go through. However:

rake users:merge['mattbr_legacy', 'mattbr_sso'] works perfectly and allows you to migrate all the posts into the SSO account.

Thanks for the feature :slight_smile:

Merge/change accounts after SSO

I’m super excited about this, but can’t see any mention of webhooks in this topic. Is this planned @gerhard?

(Jeff Atwood) #6

How are webhooks relevant to this?


When using the ‘User Event’-webhook created or login (or approved?) the duplicates will be existent on a connected site as well and one might want an automatism to clean them up as well, if the connected site supports that.

I haven’t used webhooks yet but plan to. On my connected site (using Discourse as SSO provider) the users are only created at first login for now.
+ I had duplicate users in my old forum before migrating to Discourse which I was looking forward to consolidate once this feature becomes available.

(Andrew Waugh) #8

I had another user question about this today, He also asked about the “Created” field in his profile.

  1. Is this function going to be implemented in the GUI, or will it stay a rake task?
  2. Will (or has) the rake task be(en) changed to handle mentions and quotes?
  3. Would it be possible to set “Created” to the date of the oldest owned post?

(Gerhard Schlager) #9

It will stay a rake task for now.

Yes, it will. I should be able to make this happen for the 2.0 release.

You will have to update the user’s created_at manually if you want to set it to the oldest post. The merge process uses the created_at from either the source or target user – whatever date is earlier.

(Barry van Oudtshoorn) #10

This being the case, if as a hosted customer I have accounts to be merged, should I ping the details through to the Discourse team for actioning?

(Jeff Atwood) #11

Sure that sounds fine. We also need to exercise the feature internally to make sure it is working right.

(Gerhard Schlager) #12

Quick update: Merging users now updates mentions, quotes and avatars in posts and revisions. :tada:

Anonymize user quotes keeps username
(Tobias Eigen) #13

Any chance the staff action log could better show what happens to users when they are merged? Here’s how it looks now - just shows that system has deleted the user but no context. The details only show some info about the user that got deleted as a result of the merge.

(Jeff Atwood) #14

Sure what do you think @gerhard?

(Andrew Waugh) #15

How about adding a staff note along the lines of “Username with email was merged to this account, date

This is what I did when I was merging accounts manually. Probably more work than a staff action log entry, but might be useful information at some point later.

(Jeff Atwood) #16

@gerhard we should make sure the task is logged in the staff logs if possible, per above ↑ ↑

(Gerhard Schlager) #17

I’m currently writing my todo list for this week and it’s already on it. :slight_smile:

(Jay Pfaffman) #18

Is there an easy way to change which email address is primary?

Here’s my use case:

imported user with email user@defunctdomain.com emails from user@fancynewemail.com which creates a staged user. After a few PMs with the staged user, I merge the accounts, but the primary address is still the old one. And from the web interface I can’t change the email in his profile because it’s already taken. By him.

Perhaps this is a bug in the multiple email address model and not a complaint for here.

The simple solution, which took me much to long to come up with, is to delete the old address.

(Gerhard Schlager) #19

Merging users always preserves the existing data of the target_user, so the email address of the source_user is only added as secondary email address.

Yeah, that’s the solution.

Configuring Patreon integration with Discourse
(Jay Pfaffman) #20

Is there something easier that I should do?
I need to keep the old username with the new email. The staged user is the real problem. Perhaps I should just delete the staged user, but then I don’t have an easy way to reply to them to tell them what happened.

It’s pretty cumbersome to merge[‘newname_newemail’,'oldname_bogusemail"] and then have to do something like

ue=UserEmail.where(user_id: u.id)

is there some easier way that I’m missing?