Hi somehow, don’t ask why I am currently in the situation where: I as admin have three e-mails addresses listed: Primary: the correct one Secondary: the same one but unconfirmed Third one: truly a secondary different address and confirmed. Entering rails console I can lookup the user ID but don’t know how to list the multiple alternate e-mail addresses and strip one of them. Via the UI doesn’t work probably because the e-mail addresses are the same. How can I correct this?

Thanks so much, as it turned out I could only fetch one email ID for the duplicate ones. My guess is that the unconfirmed one that I couldn’t remove didn’t yet got listed with that ID? It is probably a bit in the air with an incomplete validation process? What I did to resolve was switch the primary to the 2 alternate e-mail address. The unconfirmed duplicate could still not be deleted but when I deleted the confirmed (now former-primary email) also the unconfirmed duplicate one got removed. Then added the original email address as a secondary and then switched it to be the primary. All sorted and learned a lot in the process :wink:

Hi yes that is exactly what I am trying to do. In the console I can lookup the user. But how I can then query for the multiple emails addresses and the remove the redundant one I don’t know. When I select the user I don’t see the emails it must be in some other record. Koen

[image] koen360: how I can then query for the multiple emails addresses and the remove the redundant one The email addresses are in the user_emails table. You can find them with the ID of the user: UserEmail.where(user_id: ) Replace in the command above with the user’s ID. Find the id value of the UserEmail record that you want to remove. With that ID, run the following to return the individual record that you want to remove: identical_email = UserEmail.find( ) Double check the result that is returned to confirm it’s the email you want to remove. Then run: identical_email.destroy Before running any destructive commands from the console, it’s a good idea to create a backup of your site’s database. If something goes wrong, you can restore the backup.

Cannot remove secondary e-mail identical to primary e-mail through UI

Product Support

osioke (Osioke Itseuwa) January 8, 2021, 3:48pm 2

Have you tried disabling the email addresses from the Rails console? I can’t recall the command atm though.

Topic		Replies	Views
Additional email address per user account support Feature	47	11353	March 18, 2021
Deleted user with rails console u.delete -> email still "taken" Bug	4	1654	September 22, 2020
How to change user email if email account has been deleted Product Support	4	998	December 16, 2020
How to fix email addresses when using SSO? Product Support	1	538	June 10, 2019
Make it possible to activate a changed email address in the Admin UI Feature users	4	281	June 14, 2026

Cannot remove secondary e-mail identical to primary e-mail through UI

Related topics