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 …

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

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

[תמונה] 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 a…

[תמונה] 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…

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 be…

No fire! :crazy_face: Thanks Felix!

עריכת תבוצע לכל המשתמשים במייל

תמיכה

codinghorror (Jeff Atwood) 18 באוקטובר,‏ 2016,‏ 11:59pm 4

Yes, they can-- edit it like a user would, from the profile settings.

As an Admin, how to change user's Primary Email or add Secondary Emails when 'email editable' is off?

נושא		תגובות	צפיות
Change user's email without verification Self-hosting rails-console	10	5251	22 באוגוסט,‏ 2021
Changing users email address Support	16	4710	15 במרץ,‏ 2019
Is there a way to bulk-change user 'names' (note: not usernames) Support	8	711	1 בנובמבר,‏ 2019
Bulk Update Email of Users Support	1	601	9 בדצמבר,‏ 2021
Allow admins to always be able to edit Emails when "Edit email after signup" is disabled Feature	13	170	28 במאי,‏ 2026

עריכת תבוצע לכל המשתמשים במייל

נושאים קשורים