OJS OCS OMP OHS

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?
lednakashim
 
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.

Cheers,
James
jmacgreg
 
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 2 guests