[Koha-patches] [PATCH] Bug with update database, was causing finedays not to add, which broke adding issuingrules related to bug 3864

Chris Cormack chris at bigballofwax.co.nz
Fri Dec 11 22:50:37 CET 2009


---
 installer/data/mysql/updatedatabase.pl |    8 +++-----
 1 files changed, 3 insertions(+), 5 deletions(-)

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index 4e1d1cf..9eb7337 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -2756,11 +2756,9 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
 
 $DBversion = "3.01.00.068";
 if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
-	$dbh->do("ALTER TABLE issuingrules ADD 
-			COLUMN `finedays` int(11) default NULL AFTER `fine`,
-			COLUMN `renewalsallowed` smallint(6) default NULL, 
-			COLUMN `reservesallowed` smallint(6) default NULL,
-			");
+	$dbh->do("ALTER TABLE issuingrules ADD COLUMN `finedays` int(11) default NULL AFTER `fine`");
+        $dbh->do("ALTER TABLE issuingrules ADD COLUMN `renewalsallowed` smallint(6) default NULL");
+	$dbh->do("ALTER TABLE issuingrules ADD COLUMN `reservesallowed` smallint(6) default NULL");
 	my $sth = $dbh->prepare("SELECT itemtype, renewalsallowed FROM itemtypes");
     $sth->execute();
 	my $sthupd = $dbh->prepare("UPDATE issuingrules SET renewalsallowed = ? WHERE itemtype = ?");
-- 
1.6.3.3




More information about the Koha-patches mailing list