Bulk Deletion of Fake "Reader" Users in OJS 3.2.1.2 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 3.2.1.2, 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:

-Roger
PKP Team

1 Like

Hi all,
thanks for the help, sadly I don’t have traces in the comments (or whatelse) to detect fake accounts.

What if I merge all the users that are only Reader?

How to exctract from the db only those users?

Thanks
Alfredo Cosco