Attachment 14054 Details for Bug 9246 – Bug 9246: [Passed QA]

[patch] Bug 9246: [Passed QA]

Bug-9246-Koha-installer-crash-with-mysql-Error-116.patch (text/plain), 1.22 KB, created by Elliott Davis on 2012-12-12 18:06:16 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Elliott Davis

Created: 2012-12-12 18:06:16 UTC

Size: 1.22 KB

patch

obsolete

>From 7b1c40f2e79d8448c9365ba07edf0f50558f5c8e Mon Sep 17 00:00:00 2001
>From: Marc Veron <veron@veron.ch>
>Date: Tue, 11 Dec 2012 10:43:18 +0100
>Subject: [PATCH] Bug 9246: Koha installer crash with mysql "Error 1166 at line 1871: Incorrect column name 'closed"
> [Passed QA]
> 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 <jonathan.druart@biblibre.com>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>Signed-off-by: Elliott Davis <elliott@test.bywatersolutions.com>
>---
> installer/data/mysql/kohastructure.sql |    2 +-
> 1 files changed, 1 insertions(+), 1 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index f68c9c7..ddf4b0f 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;
> 
>-- 
>1.7.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 9246: 13994 | 14029 | 14053 | 14054