From 154f965f6eebcdec0657677039c0edfb8df46b31 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Wed, 7 May 2014 12:04:48 -0400 Subject: [PATCH] Bug 12212 - Wrong number of parameters for AggressiveMatchOnISBN 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 --- installer/data/mysql/sysprefs.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index b06dd72..be2f63f 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -10,7 +10,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('AdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields comprise the Type limit in the advanced search','Choice'), ('AgeRestrictionMarker','',NULL,'Markers for age restriction indication, e.g. FSK|PEGI|Age|','free'), ('AgeRestrictionOverride','0',NULL,'Allow staff to check out an item with age restriction.','YesNo'), -('AggressiveMatchOnISBN','0','If enabled, attempt to match aggressively by trying all variations of the ISBNs in the imported record as a phrase in the ISBN fields of already cataloged records when matching on ISBN with the record import tool','YesNo'), +('AggressiveMatchOnISBN','0', NULL,'If enabled, attempt to match aggressively by trying all variations of the ISBNs in the imported record as a phrase in the ISBN fields of already cataloged records when matching on ISBN with the record import tool','YesNo'), ('AllFinesNeedOverride','1','0','If on, staff will be asked to override every fine, even if it is below noissuescharge.','YesNo'), ('AllowAllMessageDeletion','0','','Allow any Library to delete any message','YesNo'), ('AllowFineOverride','0','0','If on, staff will be able to issue books to patrons with fines greater than noissuescharge.','YesNo'), -- 1.7.2.5