Hi everyone! A few years ago, we moved to discourse from vbulletin. As part of this migration, a lot of banned users were imported as well. That’s not the problem. The posts they created ended up showing up as visible in discourse. Almost all of these banned users created 1 or 2 posts before being discovered and banned, but whatever setting hid their posts in vbulletin ended up causing those posts to be shown in discourse. These posts being visible is the problem. Is there a way to find all posts from banned users who have made less than three posts and bulk delete them? Thanks, Kirupa

Hi Kirupa, [תמונה] kirupa: Is there a way to find all posts from banned users who have made less than three posts You can find all banned users with <3 posts using the following Data Explorer query: SELECT p.user_id, COUNT(p.id) AS qtt_posts FROM posts p INNER JOIN users u ON u.id = p.user_id WHERE suspended_till NOTNULL GROUP BY user_id HAVING COUNT(p.id) < 3 To delete the users you can use the API: /admin/users/{id}.json, you can see the documentation here.

Thanks a lot Michelle, Sam :slight_smile:

Deleting posts by banned users with < 3 posts?

תמיכה

sam (Sam Saffron) 18 במאי,‏ 2020,‏ 5:46am 2

Yeah a data explorer query can do that. Hopefully someone from the community can help.

נושא		תגובות	צפיות
Bulk deleting / mass modifying users Product Support	1	5379	10 בפברואר,‏ 2018
Bulk delete suspended users after import Product Support	2	1669	30 באוקטובר,‏ 2017
[Paid] Prune Spam users Marketplace	16	2452	6 ביוני,‏ 2017
I am getting 502 error while trying to delete topics created by specific user Product Support	18	1378	12 ביוני,‏ 2023
Deleting all posts by a user Product Support	5	2298	19 באוגוסט,‏ 2019

Deleting posts by banned users with < 3 posts?

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