Deleting lots of Suspect Users


(Louis Rossouw) #1

I have a large number of suspect users I want to delete. They were migrated from our previous vbb forum and they have been sitting on our forum as suspect users for some time. Many of these have profile link spam.

My criteria are to delete any user meeting the following criteria:

  • users that were last seen say more than 3 years ago
  • users that have no posts
  • users that have not read any posts
  • (maybe users that have a web profile url)

I am able to select these using sql, but now want to bulk delete them.

How do I go about this?


(Jeff Atwood) #2

I don’t think there is any way to bulk delete users at the current time. The best you could do is script it from the Ruby command line.


(Louis Rossouw) #3

Ok deleted 80 by :raised_hand: so it’s done.


(RĂ©gis Hanol) #4

Change right gutter to vertical timeline + topic controls
(Kane York) #5

For future reference, the best way to handle this currently is to identify the criteria, code that into the import script, and rerun the import on a clean Discourse database.

Of course, that doesn’t work if you’ve been writing posts on the current database for weeks…