I have imported my old data from phpBB3 which went smooth. But I made a mistake by not first cleaning up the old inactive users and still importing them. I now have around 4000 users with no posts I wish to remove. What is the best way to bulk remove users?

If you really don’t care about these users, then I would do this make a backup (better safe than sorry) ssh into your server and type cd /var/discourse ./launcher enter app rails c User.where(post_count: 0).destroy_all

These instructions produce the following error: [1] pry(main)> User.where(post_count: 0).destroy_all ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column users.post_count does not exist LINE 1: SELECT "users".* FROM "users" WHERE "users"."post_count" = 0 ^ : SELECT "users".* FROM "users" WHERE "users"."post_count" = 0 from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/rack-mini-profiler-0.10.1/lib/patches/db/pg.rb:90:in `exec' This is not really documented I think but if it is please point me in the right direction?

“post count” != “post_count” ??

My bad, the post_count property was moved to another table for optimization reasons. Here’s the updated query User.joins(:user_stat).where("user_stats.post_count = 0").destroy_all

One of my sites uses SSO and we’re looking to remove users that have never posted and haven’t been seen in a year (to avoid killing users who are just quiet). Is this query valid in the rails console? User.joins(:user_stat).where("user_stats.post_count = 0 AND previous_visit_at <= '2016-05-20'::timestamp").destroy_all

I have the same issue, but with users I need to remove before doing the final import. I have been working on creating a base setup with all settings/themes/whatever before doing the import - now (after a lot of work) I discover I had done this on a partial import that had imported 4000 users already. I wish to delete those so nobody will accidentally get any emails of digests or whatever (when I forget to change those settings). How do I adapt that query so only the admin user will remain ? There are 4000 or so in the active userlist and 30 or so in the suspended users list. thank you in advance :slight_smile:

Note: nowadays there is a specific class for destroying Users and associated records cleanly: UserDestroyer. So instead of this: [תמונה] Régis: User.where(post_count: 0).destroy_all This should be done: destroyer = UserDestroyer.new(Discourse.system_user) User.joins(:user_stat).where("user_stats.post_count = 0").each { |u| destroyer.destroy(u) }

Bulk remove users

Product Support

yavuz (Yavuz) 28 בנובמבר,‏ 2016,‏ 9:25pm 6

Thank you, the updated query works!

נושא		תגובות	צפיות
Bulk delete suspended users after import Product Support	2	1669	30 באוקטובר,‏ 2017
Bulk deleting / mass modifying users Product Support	1	5379	10 בפברואר,‏ 2018
[Paid] Prune Spam users Marketplace	16	2452	6 ביוני,‏ 2017
Bulk deactivate users with SQL query Product Support	1	801	31 במאי,‏ 2018
Remove all users except admins or a few select users whichever is easier Product Support	10	918	17 בדצמבר,‏ 2022

Bulk remove users

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