From 1e44246b256808f86e02d9d976ac0858214ede73 Mon Sep 17 00:00:00 2001 From: Olli-Antti Kivilahti Date: Mon, 27 Oct 2014 16:07:54 +0200 Subject: [PATCH] [PASSED QA] Bug 13149 - for B 11926 (HEA - Render community koha statistic usages) introduces an column count error in sysprefs.sql REPLICATE: 1. Create a new Koha database to your SQL Server. Set proper user permissions. 2. Change database data source definitions in koha-config.xml. 3. Run the web-installer to install a new Koha with defaults. 4. Run "SELECT * FROM systempreferences;" in your SQL Server and observe only 3 systempreferences set. +--------------------------+ (( 5. mainpage.pl crashes!! )) +--------------------------+ AFTER THIS COMMIT: 0. Redo REPLICATE steps. 1. test phase 4 returns over 400 results. 2. test phase 5 doesn't crash. Signed-off-by: Paola Rossi Signed-off-by: Bernardo Gonzalez Kriegel Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/sysprefs.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index a18f7b6..874aaf3 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -430,7 +430,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('UsageStatsID', '', 'This preference is part of Koha but it should not be deleted or updated manually.', '', 'Free'), ('UsageStatsLastUpdateTime', '', 'This preference is part of Koha but it should not be deleted or updated manually.', '', 'Free'), ('UsageStatsLibraryName', '', 'The library name to be shown on Hea Koha community website', NULL, 'Free'), -('UsageStatsLibraryType', 'public', 'public|university', 'The library type to be shown on the Hea Koha community website', NULL, 'Choice'), +('UsageStatsLibraryType', 'public', 'public|university', 'The library type to be shown on the Hea Koha community website', 'Choice'), ('UsageStatsLibraryUrl', '', 'The library URL to be shown on Hea Koha community website', NULL, 'Free'), ('UseAuthoritiesForTracings','1','0','Use authority record numbers for subject tracings instead of heading strings.','YesNo'), ('UseBranchTransferLimits','0','','If ON, Koha will will use the rules defined in branch_transfer_limits to decide if an item transfer should be allowed.','YesNo'), -- 1.9.1