Can't change an imported user's primary email

[rahim123]

Hi there, I’m trying to help a user that was imported from my Drupal forum into Discourse with a password reset email. We’re having trouble with the primary address, and so I added a secondary one to his profile. But he says it says that no such registered email exists when he tries to request a password reset. So I tried to change the secondary to primary and the primary to secondary. But the change simply gets reverted, it won’t stick. And now Discourse is telling me (the admin and moderator) “You’ve performed this action too many times” when I try to change it (using a different browser in Discourse safe mode, just to eliminate that as the cause of the problem). I found this tip for changing it in the Rails console, but it doesn’t look right where it says wmail instead of email :

How can I change user primary email?

There are many topics discussing this. You can visit the user’s profile page and change it but they’ll still need to verify their address, which is almost always a good idea. If you want to take matters into your own hands, you can do it from the rails console. It’s much safer than direct database queries. This might work u=User.find_by_username("pat") UserEmail.find_by(user_id: u.id).first.update (email: "pat@gmail.com")

[pfaffman (Jay Pfaffman)]

So try it without the typo.

[rahim123]

Thanks Jay. It doesn’t seem to work:

SyntaxError: unexpected label, expecting ')'
..._id: u.id).first.update (email: "user@email.com")
...                         ^~~~~~
SyntaxError: unexpected ')', expecting end-of-input
...email: "user@email.com")
...

[rahim123]

Re-categorizing this as a bug, as the UI should always allow changing a user’s email and it shouldn’t rate-limit the admin.

Would clearing the Redis cache help I wonder?

[pfaffman (Jay Pfaffman)]

There were two more typos in that.

@rahim123

Would clearing the Redis cache help I wonder?

I don’t think so.

My best guess is that you imported the email address with caps or some hidden character, perhaps. I would try to change to a different email rather than add a secondary.

[rahim123]

@pfaffman

My best guess is that you imported the email address with caps or some hidden character, perhaps. I would try to change to a different email rather than add a secondary.

Hmm, nope, the address is good, I pasted it into my email client and sent a message to it. I did try to change the primary, but it just keeps the primary and puts the secondary one after as unverified.

[sam (Sam Saffron)]

@rahim123

Re-categorizing this as a bug,

It is unclear what the bug is from the first post. I am moving back to support

Please see:

Writing a Good Bug Report

Writing a good bug report is essential to help us fix your bug! While writing your bug report you should have exactly one goal: maximizing the chance of this bug to get fixed. To reach this goal you absolutely need to include reproducible steps and be very specific/concise. Security bugs have a specific workflow You should always try to reproduce your bug with safe mode unless you already know the issue is coming from a customisation. Bugs are more often than no…

We need more info here.

[rahim123]

Hi there, I’m sorry if there wasn’t enough information, but I honestly don’t understand what was missing. I did try it with safe mode as mentioned earlier.

@rahim123

So I tried to change the secondary to primary and the primary to secondary. But the change simply gets reverted, it won’t stick

Is this the expected behavior?

@rahim123

And now Discourse is telling me (the admin and moderator) “You’ve performed this action too many times”

I would say that the administrator should never be rate-limited.

[Anmol_Saini]

This worked for me

u=User.find_by_username("XXXXXX") 
UserEmail.find_by(user_id: u.id).update(email: "XXXX@XXX.com")