Long story short: I screwed up an import from phpBB. :facepalm: Well okay, that’s not the full story. The import itself worked flawlessly! And at this point let me shout out to the whole team for creating an awesome piece of software (from a users point of view, an admins point of view and a devs point of view)! :slight_smile: But… … I wanted to be on the safe side and edited every users email in the sql file from phpBB. So Discourse won’t send out any mails after the import, because we needed some time to restructrue posts and categories after the import. Please, don’t ask why and how. :joy: After we finished all refurbishing tasks we wanted to edit the users emails back to their original one, only to find out admins can’t edit emails. We ended up impersonating every user and changing their email address back… only to find out the activation link may only be valid for a few (?) hours. At least we now have users who click the link they received, but Discourse doesn’t change their address. Luckily I didn’t screw up THAT bad. When editing the users mail in the first place, before the import, I just appended kinda nonce to the @-sign, so the domain is invalid. This means the original data is still there. My plan is to replace the nonce with an empty string on the database. And that’s where I need help, as I have zero experience with Ruby/Rails. I already found [image] Edit a user preference for everyone or a subset of users Self-Hosting bookmark This guide explains how to edit a user preference for everyone or a subset of users in Discourse. person_raising_hand Required user level: System Administrator warning Console access is required. If you need to update the user preference for all of your users or a large subset of users, you can do so via the rails console. Summary In this guide, you’ll learn: How to access the Rails console for making bulk changes Examples of modifying user preferences How to identify se… And that’s quite a good start, but I need further help here. What I think I need to to - in pseudocode: ./launcher enter app rails c User.where("email contains nonce").update_all(replace nonce with empty string) Or even User.update_all(replace nonce with empty string in email field) As the nonce is really just some gibberish behind the @-sign, but the same gibberish for every user. And the ones I already corrected manually won’t be affected by this. I don’t have a clue what I’m supposed to write in between the parantheses. Or if this (a replace) is even possible.

User.update_all("email = replace(email, 'nonce', '')")

Worked like a charme! Thank you, Falco! :slight_smile:

[image] Raku: only to find out admins can’t edit emails Yes, they can-- edit it like a user would, from the profile settings.

[quote=“codinghorror, post:4, topic:51687, full:true”]edit it like a user would, from the profile settings. [/quote] Oh my… it seems we really overlooked this! :badpokerface: We impersonated each and every user and changed it there. Will Discourse send out a mail asking for verification of the adress, if an admin changes it in the profile settings (without impersonating the user)?

[image] Falco: User.update_all(“email = replace(email, ‘nonce’, ‘’)”) I’m trying something similar, but getting a readonly error. How do I get around it? This is not a production instance, so it’s OK if I screw up. User.update_all("email = replace(email, '@', '@invalid_email')") ActiveRecord::StatementInvalid: PG::RaiseException: ERROR: Discourse: email in users is readonly : UPDATE "users" SET email = replace(email, '@', '@invalid_email') from /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-mini-profiler-0.10.5/lib/patches/db/pg.rb:90:in `async_exec'

Emails have moved to a separate table called user_emails (behind the scenes, users now can have multiple email addresses), so this command will have to be rewritten. This may work: UserEmail.update_all("email = replace(email, 'nonce', '')") …or it might set fire to the database. :fire: You’ve been warned :slight_smile:

No fire! :crazy_face: Thanks Felix!

Mass-edit email of all users

Product Support

Raku (Raku) October 18, 2016, 4:40pm 3

Worked like a charme! Thank you, Falco!

Topic		Replies	Views
Change user's email without verification Self-hosting rails-console	10	5448	August 22, 2021
Changing users email address Product Support	16	4966	March 15, 2019
Is there a way to bulk-change user 'names' (note: not usernames) Product Support	8	826	November 1, 2019
Bulk Update Email of Users Product Support	1	639	December 9, 2021
Allow admins to always be able to edit Emails when "Edit email after signup" is disabled Feature	13	317	May 28, 2026

Mass-edit email of all users

Related topics