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)
committerFrédéric Demians <f.demians@tamil.fr>
Thu, 22 Sep 2016 06:16:16 +0000 (08:16 +0200)
commitca1d76820f3ec2beee7b6cd926e46cedc1017ae5
tree465d68240ac98c31a078a5f08f0e0cffd11cca4d
parent8d042d83d2b996f20c466d7a596346542e00db82
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>
(cherry picked from commit 4ddc8635347f978a354e6e332aede0abeeea310b)
Signed-off-by: Frédéric Demians <f.demians@tamil.fr>
misc/maintenance/fix_unclosed_nonaccruing_fines_bug17135.pl