[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