Bug 11945: SQL syntax error in delete_expired_opac_registrations.pl
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Thu, 9 Oct 2014 08:23:31 +0000 (10:23 +0200)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Fri, 24 Oct 2014 13:02:01 +0000 (10:02 -0300)
commit5e7e48b9c593ff3c7c1d6e4b74e318592b422bd7
treee80843370a7fd14f5910fceffe4bea9ae1826015
parent5caedfb633f5046b03007c5c882c70d2ca0737da
Bug 11945: SQL syntax error in delete_expired_opac_registrations.pl

This patch corrects a syntax error, adds some comments to the usage
instructions and adds a count of the removed borrowers (with verbose
flag on).

Note that this is a dangerous script. It will delete your patrons
in patron category PatronSelfRegistrationDefaultCategory.
If you do not use this as a temporary category, you should NOT run this
script.

Test plan:
Check PatronSelfRegistrationDefaultCategory.
Check PatronSelfRegistrationExpireTemporaryAccountsDelay.
Based on these two settings, check the number of patrons to be deleted (date
enrolled should be before NOW minus the delay).
Backup your data and run the script.
Check the number of deleted borrowers.

Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>

Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
misc/cronjobs/delete_expired_opac_registrations.pl