Is there a quick script which will allow me to bulk remove all users except either admins or a select few users identified by their IDs/emails? Whichever option is easier is fine. Will want to do this from the rails console. Thanks

You can output the usernames and their corresponding emails: User.where(admin: false).find_each do |user| puts "#{user.username}: #{user.email}" UserDestroyer.new(Discourse.system_user).destroy(user, delete_posts: true) end

Thanks, is destroy_all the same as UserDestroyer or is one recommended over the other. Saw UserDestroyer mentioned a few times in other posts. Thanks

Its now failing with this after deleting around 200, but its now stuck: ActiveRecord::RecordInvalid: Validation failed: Primary email can't be blank from /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3/lib/active_record/validations.rb:80:in `raise_validation_error' I’ve had a search and found one post about checking for blocked emails in Admin > Logs > Screened Emails and nothing is showing but not sure what to do next. Thanks

UserDestroyer is what you should use. It will delete other data associated with the user. Don’t know why you’d get that error. You might restore your backup to before you started the delete and try the destroyer instead.

I’ve restored and tried again with the UserDestroyer, but still getting that error. Anyway to track down whats causing it?

You can use a rails script or Data Explorer to check for the email addresses and see if one is blank… Though it would be weird. No email field is blank by default even for automatically generated accounts like discobot ou system (which are admins by default). Were your users imported? But even so, I’m pretty sure that account creation methods don’t allow blank email fields.

We’ve used oauth with a custom app. I did this yesterday but returned no users: User.joins(:user_emails).where(user_emails.email = "") and that returned nil so I don’t think any are empty. Must just be one or two users though because the majority work but its getting stcuk instantly on the same one now. My delete script is: User.where(admin: false).find_each do |user| UserDestroyer.new(Discourse.system_user).destroy(user, delete_posts: true) end Is there anyway to echo which user its doing as it loops round?

Thanks, this is great, will run this now and hopefully should tell me who it is struggling on.

Yeah, this worked, showed me which it was struggling with and it was an illegal character in the email somehow so updated that and it worked. Thanks

הסר את כל המשתמשים מלבד מנהלים או כמה משתמשים נבחרים, מה שיקל יותר

תמיכה

pfaffman (Jay Pfaffman) 17 בדצמבר,‏ 2022,‏ 3:15am 2

 User.where(admin: false).destroy_all

I think should do it. You can do the above without the destroy_all to see what users are selected.

נושא		תגובות	צפיות
Deleting Users in rails console Product Support	11	3760	23 ביולי,‏ 2023
Bulk delete users that match an email pattern Product Support	4	1235	9 באפריל,‏ 2020
Batch operations on multiple users Feature	6	1703	12 בדצמבר,‏ 2024
Delete all users not in a specific group Product Support	1	612	20 באוגוסט,‏ 2021
Bulk remove users Product Support	9	2382	13 בינואר,‏ 2023

הסר את כל המשתמשים מלבד מנהלים או כמה משתמשים נבחרים, מה שיקל יותר

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