Bug 9246 - Upon running koha installer, mysql "Error 1166 at line 1871: Incorrect column name 'closed" appears and crashes install.
Summary: Upon running koha installer, mysql "Error 1166 at line 1871: Incorrect column...
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: bugs.koha-community.org (show other bugs)
Version: Main
Hardware: All All
: P5 - low blocker
Assignee: Marc Véron
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-12-07 21:21 UTC by scott kushner
Modified: 2019-06-27 09:24 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: Trivial patch
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Attachments
Bug 9246: Koha installer crash with mysql "Error 1166 at line 1871: Incorrect column name 'closed" (1.07 KB, patch)
2012-12-11 09:48 UTC, Marc Véron 		Details | Diff | Splinter Review
Bug 9246: Koha installer crash with mysql "Error 1166 at line 1871: Incorrect column name 'closed" (1.09 KB, patch)
2012-12-12 09:30 UTC, Jonathan Druart 		Details | Diff | Splinter Review
Bug 9246: Koha installer crash with mysql "Error 1166 at line 1871: Incorrect column name 'closed" (1.14 KB, patch)
2012-12-12 18:00 UTC, Kyle M Hall (khall) 		Details | Diff | Splinter Review
Bug 9246: [Passed QA] (1.22 KB, patch)
2012-12-12 18:06 UTC, Elliott Davis 		Details | Diff | Splinter Review
Show Obsolete (3) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description scott kushner 2012-12-07 21:21:21 UTC 
Fix: 

line 1923 in kohastructure.sql had whitespace between back tick on Column name "closed". 

Just remove space.
Comment 1 Marc Véron 2012-12-11 09:48:44 UTC Comment hidden (obsolete)
Comment 2 Marc Véron 2012-12-11 11:12:21 UTC 
Tested my patch with a fresh install, without and with patch. Got error in step 3, with patch insaller runs fine.

Needs Signoff...
Comment 3 Jonathan Druart 2012-12-12 09:30:07 UTC Comment hidden (obsolete)
Comment 4 Kyle M Hall (khall) 2012-12-12 18:00:59 UTC Comment hidden (obsolete)
Comment 5 Elliott Davis 2012-12-12 18:06:16 UTC 
Created attachment 14054 [details] [review]
Bug 9246: [Passed QA]

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>
Comment 6 Elliott Davis 2012-12-12 18:06:38 UTC 
Works as advertised
Comment 7 Jared Camins-Esakov 2012-12-12 23:15:44 UTC 
This patch has been pushed to master.