Bulk Deletion of Fake "Reader" Users in OJS with PostgreSQL

Hello everyone,

One of the OJS instances I manage is overwhelmed with fake users and spam. We are taking the necessary security measures to address this issue.

In the meantime, we have decided to delete all users who are only “readers.” Do you have a query to bulk delete this type of user without breaking the referential integrity of the database?

The OJS version is, and the database is PostgreSQL

Hi @Alfredo_Cosco,

They may not be Postgres or your version-specific, but there are a few posts on this that might be helpful:

PKP Team

1 Like