@@ -, +, @@ - Run the web installer on an empty database - Make sure no SQL errors are shown - Check the systempreferences table in your database, especially all UsageStats* - Make sure the explanations are in explanation etc. - Save your database - truncate systempreferences; - Load the sql file sysprefs.sql - Verfiy as above --- installer/data/mysql/sysprefs.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) --- a/installer/data/mysql/sysprefs.sql +++ a/installer/data/mysql/sysprefs.sql @@ -425,13 +425,13 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('UpdateTotalIssuesOnCirc','0',NULL,'Whether to update the totalissues field in the biblio on each circ.','YesNo'), ('uppercasesurnames','0',NULL,'If ON, surnames are converted to upper case in patron entry form','YesNo'), ('URLLinkText','',NULL,'Text to display as the link anchor in the OPAC','free'), -('UsageStats', 0, 'Share anonymous usage data on the Hea Koha community website.', NULL, 'YesNo'), -('UsageStatsCountry', '', 'The country where your library is located, to be shown on the Hea Koha community', NULL, 'YesNo'), -('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'), +('UsageStats', 0, NULL, 'Share anonymous usage data on the Hea Koha community website.', 'YesNo'), +('UsageStatsCountry', '', NULL, 'The country where your library is located, to be shown on the Hea Koha community website', 'YesNo'), +('UsageStatsID', '', NULL, 'This preference is part of Koha but it should not be deleted or updated manually.', 'Free'), +('UsageStatsLastUpdateTime', '', NULL, 'This preference is part of Koha but it should not be deleted or updated manually.', 'Free'), +('UsageStatsLibraryName', '', NULL, 'The library name to be shown on Hea Koha community website', 'Free'), ('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'), +('UsageStatsLibraryUrl', '', NULL, 'The library URL to be shown on Hea Koha community website', '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'), ('UseControlNumber','0','','If ON, record control number (w subfields) and control number (001) are used for linking of bibliographic records.','YesNo'), --