Is it safe to delete users from the SQL?

OJS development discussion, enhancement requests, third-party patches and plug-ins.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
Posts: 33
Joined: Wed Dec 29, 2010 10:23 pm

Is it safe to delete users from the SQL?

Postby lednakashim » Sun Feb 19, 2012 6:09 pm

We had a little problem with a few thousand robots registering on our server. Looking at their account information it is rather easy to determine the robots. I was wondering if it were safe to simply delete the entries for their user accounts in on the SQL. Can anybody guess some scenario where this approach would go wrong?

Posts: 4191
Joined: Tue Feb 14, 2006 10:50 am

Re: Is it safe to delete users from the SQL?

Postby jmacgreg » Wed Feb 29, 2012 3:13 pm

Hi lednakashim,

See viewtopic.php?f=8&t=8271 for a discussion on how to merge larger numbers of users from your system. Note that simply deleting rows from the users table is not a particularly clean solution, as user information is stored elsewhere.


Return to “OJS Development”

Who is online

Users browsing this forum: No registered users and 1 guest