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 (vote)
Assignee: Kyle M Hall
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-07 16:04 UTC by Kyle M Hall
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:


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
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

Note You need to log in before you can comment on or make changes to this bug.
Description Kyle M Hall 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 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!