From 6bbb5a0889648f07f87258a9fd8dac785831af66 Mon Sep 17 00:00:00 2001 From: Chris Nighswonger Date: Thu, 14 Jan 2010 23:03:02 -0500 Subject: [PATCH] Bugfix: 4046 Misc SQL Syntax Errors This patch fixes several SQL syntax errors with the ALTER TABLE pragma --- installer/data/mysql/updatedatabase.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index a60a6f24b4..9c4940a3f6 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -2758,8 +2758,8 @@ $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, + ADD COLUMN `renewalsallowed` smallint(6) default NULL, + ADD COLUMN `reservesallowed` smallint(6) default NULL; "); my $sth = $dbh->prepare("SELECT itemtype, renewalsallowed FROM itemtypes"); $sth->execute(); -- 2.20.1