Describe the issue or problem
We have a lot of spam users, and we want to find a list of them so that we can delete in bulk.
Steps I took leading up to the issue
This is an on going issue with Spam users registration regardless of our Honeypot plugin implementation.
What application are you using?
For example, OJS 3.3.0-8
Additional information
In effort of finding spamusers to delete, we need a query to list all users who do not have an article/submission associated with them. Thank you!
Hi @dung,
This isn’t quite like what you mention, but gives a lot of good options for identifying spam users via SQL: Collaborative list of spam user patterns - #2 by marc (note that some of the more up-to-date suggestions can be found later in the thread)
-Roger
PKP Team
Hello @rcgillis , thank you for the link. I will definitely work on the low hanging fruits by using the instruction in the post while waiting for someone who can help us with the construction of the desired query.
Best,
Dung.