Bug 12212

Summary: Wrong number of parameters for AggressiveMatchOnISBN in sysprefs.sql
Product: Koha Reporter: Kyle M Hall (khall) <kyle>
Component: Installation and upgrade (web-based installer)Assignee: Kyle M Hall (khall) <kyle>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: blocker    
Priority: P5 - low CC: gmcharlt
Version: Main   
Hardware: All   
OS: All   
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 12212 - Wrong number of parameters for AggressiveMatchOnISBN in sysprefs.sql
Bug 12212: fix error that prevented sysprefs.sql from loading
Bug 12212: fix error that prevented sysprefs.sql from loading

Description Kyle M Hall (khall) 2014-05-07 16:04:26 UTC
There is in incorrect number of parameters for the AggressiveMatchOnISBN stanza in sysprefs.sql

ERROR 1136 (21S01) at line 1: Column count doesn't match value count at row 12

Test Plan:
1) Attempt to run the web installer OR try to import the sysprefs.sql into your db
2) Apply this patch
3) Try again, no errors should be reported this time
Comment 1 Kyle M Hall (khall) 2014-05-07 16:05:22 UTC Comment hidden (obsolete)
Comment 2 Galen Charlton 2014-05-07 21:20:48 UTC Comment hidden (obsolete)
Comment 3 Chris Cormack 2014-05-07 21:25:29 UTC
Created attachment 28038 [details] [review]
Bug 12212: fix error that prevented sysprefs.sql from loading

The line for inserting AggressiveMatchOnISBN didn't have the right
number of columns.

Test Plan:
1) Attempt to run the web installer OR try to import the sysprefs.sql
into your db
2) Apply this patch
3) Try again, no errors should be reported this time

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
Comment 4 Galen Charlton 2014-05-07 21:58:12 UTC
Pushed to master.  Thanks, Kyle!