You are viewing the PKP Support Forum | PKP Home Wiki

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 http://forum.pkp.sfu.ca

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.

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: 33
Joined: Wed Dec 29, 2010 10:23 pm

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.

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

Return to OJS Development

Who is online

Users browsing this forum: No registered users and 1 guest