From ca47d7c31cc73023ca5915080792690a8dfc7eeb Mon Sep 17 00:00:00 2001 From: Marc Veron Date: Tue, 11 Dec 2012 10:43:18 +0100 Subject: [PATCH] Bug 9246: Koha installer crash with mysql error The Koha installer reports "Error 1166 at line 1871: Incorrect column name 'closed'." Reason: line 1923 in kohastructure.sql had whitespace between back tick on Column name "closed". Patch removes white space on given line. Signed-off-by: Jonathan Druart Signed-off-by: Kyle M Hall Signed-off-by: Elliott Davis Signed-off-by: Jared Camins-Esakov --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index f68c9c7814..ddf4b0fb7c 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1920,7 +1920,7 @@ CREATE TABLE `subscription` ( `opacdisplaycount` VARCHAR(10) NULL, `graceperiod` int(11) NOT NULL default '0', `enddate` date default NULL, - `closed ` INT(1) NOT NULL DEFAULT 0, + `closed` INT(1) NOT NULL DEFAULT 0, PRIMARY KEY (`subscriptionid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.5