Bug 12212 - Wrong number of parameters for AggressiveMatchOnISBN in sysprefs.sql
Summary: Wrong number of parameters for AggressiveMatchOnISBN in sysprefs.sql
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: Main
Hardware: All All
: P5 - low blocker
Assignee: Kyle M Hall (khall)
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-07 16:04 UTC by Kyle M Hall (khall)
Modified: 2019-06-27 09:24 UTC (History)
1 user (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 12212 - Wrong number of parameters for AggressiveMatchOnISBN in sysprefs.sql (2.07 KB, patch)
2014-05-07 16:05 UTC, Kyle M Hall (khall) 		Details | Diff | Splinter Review
Bug 12212: fix error that prevented sysprefs.sql from loading (2.11 KB, patch)
2014-05-07 21:20 UTC, Galen Charlton 		Details | Diff | Splinter Review
Bug 12212: fix error that prevented sysprefs.sql from loading (2.15 KB, patch)
2014-05-07 21:25 UTC, Chris Cormack 		Details | Diff | Splinter Review
Show Obsolete (2) 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 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!