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, [image] 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.

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

Thanks a lot Michelle, Sam :slight_smile:

Deleting posts by banned users with < 3 posts?

Product Support

kirupa (Kirupa Chinnathambi) May 20, 2020, 6:48am 6

Thanks a lot Michelle, Sam

Topic		Replies	Views
Bulk deleting / mass modifying users Product Support	1	5376	February 10, 2018
Bulk delete suspended users after import Product Support	2	1658	October 30, 2017
[Paid] Prune Spam users Marketplace	16	2437	June 6, 2017
I am getting 502 error while trying to delete topics created by specific user Product Support	18	1366	June 12, 2023
Deleting all posts by a user Product Support	5	2295	August 19, 2019

Deleting posts by banned users with < 3 posts?

Related topics