From 2386ef81e88563f2b20a2b16f6247611235b4635 Mon Sep 17 00:00:00 2001 From: Mason James Date: Wed, 3 Oct 2012 11:09:41 +1300 Subject: [PATCH] [SIGNED-OFF] Bug 8253 - Fine doubling Provides a fix that during database upgrade, fines are correclty formatted. Once the misc/cronjobs/fines.pl is run in the upgraded database, it will not result in duplicate fines being generated. Signed-off-by: wajasu --- installer/data/mysql/updatedatabase.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index d21cfad..f3fc70f 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -5026,7 +5026,8 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { $dbh->do("ALTER TABLE old_issues CHANGE returndate returndate datetime"); $dbh->do("ALTER TABLE old_issues CHANGE lastreneweddate lastreneweddate datetime"); $dbh->do("ALTER TABLE old_issues CHANGE issuedate issuedate datetime"); - print "Upgrade to $DBversion done (Setting up issues tables for hourly loans)\n"; + $dbh->do("UPDATE accountlines SET description = CONCAT(description,' 23:59') WHERE accounttype='F' OR accounttype='FU'"); #BUG-8253 + print "Upgrade to $DBversion done (Setting up issues and accountlines tables for hourly loans)\n"; SetVersion($DBversion); } -- 1.7.12.1