Bug 8182 - Problem with overdue fine calculations after upgrade
authorKyle M Hall <kyle@bywatersolutions.com>
Fri, 1 Jun 2012 18:30:05 +0000 (14:30 -0400)
committerChris Cormack <chrisc@catalyst.net.nz>
Tue, 5 Jun 2012 20:01:12 +0000 (08:01 +1200)
commit220b3d6c9c3349033668746ceacf03fcbb38725a
tree1d90ed87ca2c9d2d0f5287a9699d2726eb8b9f92
parent79a4a67a0fbec40c11de72f7356512ce961c9cf3
Bug 8182 - Problem with overdue fine calculations after upgrade

Items that were overdue and still out as of 5/26 (date of Upgrade) were charged
overdue fines as of 5/26.  When the items DO come back, the overdue fines are
calculated again from the due date to the date of checkin.  Therefore the
patron is being charged double overdue fines from the original date up to 5/26.

This is caused by issues.date_due being changed to a datetime, with the
hour/minute/secons time portion defaulting to 00:00:00. It should be 23::50::00 instead.

This is an unusual patch as it modifies a previous database update. This
make sense because if a install has already been updated past the db rev
update, this fix will be too late. It will only help those that have not
updated past that db revision.

Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>
Signed-off-by: Paul Poulain <paul.poulain@biblibre.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
installer/data/mysql/updatedatabase.pl