From 9a70c823f6c9a01cea1720c485e85166e0599d4a 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 Content-Type: text/plain; charset="utf-8" http://koha-community.org --- installer/data/mysql/updatedatabase.pl | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index db35f3a..c9a890c 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.2.5