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
Developer Resources:

Documentation: The OJS Technical Reference and the OJS API Reference are both available from the OJS Documentation page.

Git: You can access our public Git Repository here. Comprehensive Git usage instructions are available on the wiki.

Bugzilla: You can access our Bugzilla report tracker here.

Search: You can use our Google Custom Search to search across our main website, the support forum, and Bugzilla.

Questions and discussion are welcome, but if you have a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a technical support question, try the OJS Technical Support subforum.

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: 4186
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