From c959e464ffb8728144335ce71a130c8a2904b642 Mon Sep 17 00:00:00 2001 From: Mason James Date: Wed, 3 Oct 2012 11:09:41 +1300 Subject: [PATCH] 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 Signed-off-by: Chris Cormack --- 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 660503e173..9a3f69e0d1 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); } -- 2.39.5