Bug 17135 - Some minor changes & fixes in the script
authorJacek Ablewicz <abl@biblos.pk.edu.pl>
Wed, 31 Aug 2016 14:18:50 +0000 (16:18 +0200)
committerKyle M Hall <kyle@bywatersolutions.com>
Fri, 16 Sep 2016 10:47:03 +0000 (10:47 +0000)
commit4ddc8635347f978a354e6e332aede0abeeea310b
tree8486568378c62e2c2e90105f07c732931017ec4b
parent812379bbc237e5c5fe6e954f666a7b1f0961a21c
Bug 17135 - Some minor changes & fixes in the script

- all non-fatal output redirected to STDOUT (as there is an intention
to run this script from updatedatabase.pl)

- added borrowernumber and itemnumber equality checks to the SELECT
statement in getFinesForChecking() - accountlines.issue_id alone is not
entirely trustworthy (because InnoDB forgets it's highest auto_increment
after server restart), in some rare cases it may point to some random
issue for different patron and different item

Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
misc/maintenance/fix_unclosed_nonaccruing_fines_bug17135.pl