Bug 15128 accidentally missed a comma on MaxOpenSuggestions. diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index 29ef9c8..c9a7c7e 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -236,6 +236,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('MaxItemsToDisplayForBatchDel','1000',NULL,'Display up to a given number of items in a single item deletionbatch.','Integer'), ('MaxItemsToProcessForBatchMod','1000',NULL,'Process up to a given number of items in a single item modification batch.','Integer'), ('maxItemsInSearchResults','20',NULL,'Specify the maximum number of items to display for each result on a page of results','free'), +('MaxOpenSuggestions','',NULL,'Limit the number of open suggestions a patron can have at once','Integer') ('maxoutstanding','5','','maximum amount withstanding to be able make holds','Integer'), ('maxRecordsForFacets','20',NULL,NULL,'Integer'), ('maxreserves','50','','Define maximum number of holds a patron can place','Integer'), This just adds it in.
Created attachment 53391 [details] [review] Bug 16920: sysprefs.sql - missing comma for MaxOpenSuggestions TEST PLAN --------- 1) back up DB 2) drop database koha_library; 3) create database koha_library; 4) run web browser install, choose ALL defaults -- notice the SQL syntax warning. 5) apply patch 6) repeat steps 2-4 -- notice SQL syntax warning is gone. 7) run koha qa test tools 8) restore db
Created attachment 53392 [details] [review] Bug 16920: sysprefs.sql - missing comma for MaxOpenSuggestions TEST PLAN --------- 1) back up DB 2) drop database koha_library; 3) create database koha_library; 4) run web browser install, choose ALL defaults -- notice the SQL syntax warning. 5) apply patch 6) repeat steps 2-4 -- notice SQL syntax warning is gone. 7) run koha qa test tools 8) restore db Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
Created attachment 53393 [details] [review] Bug 16920: sysprefs.sql - missing comma for MaxOpenSuggestions TEST PLAN --------- 1) back up DB 2) drop database koha_library; 3) create database koha_library; 4) run web browser install, choose ALL defaults -- notice the SQL syntax warning. 5) apply patch 6) repeat steps 2-4 -- notice SQL syntax warning is gone. 7) run koha qa test tools 8) restore db Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz> Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Pushed to master for 16.11, thanks Mark!