From 3a784cf9da8fbd5e0684dd52e633c9d856e67d44 Mon Sep 17 00:00:00 2001 From: Olli-Antti Kivilahti Date: Mon, 27 Oct 2014 16:07:54 +0200 Subject: [PATCH] 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. --- 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 600279d..ff7b6ed 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -429,7 +429,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.7.9.5