Bugzilla – Attachment 32825 Details for
Bug 13149
B 11926 (HEA - Render community koha statistic usages) introduces an column count error in sysprefs.ql
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[PASSED QA] Bug 13149: Fix sequence of fields in sysprefs.sql
PASSED-QA-Bug-13149-Fix-sequence-of-fields-in-sysp.patch (text/plain), 3.54 KB, created by
Tomás Cohen Arazi (tcohen)
on 2014-10-28 13:18:14 UTC
(
hide
)
Description:
[PASSED QA] Bug 13149: Fix sequence of fields in sysprefs.sql
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2014-10-28 13:18:14 UTC
Size:
3.54 KB
patch
obsolete
>From 5bb05b10f27a67d099f0a539bebf0dfab95f5db2 Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <Katrin.Fischer.83@web.de> >Date: Mon, 27 Oct 2014 19:22:26 +0100 >Subject: [PATCH] [PASSED QA] Bug 13149: Fix sequence of fields in sysprefs.sql > >The sequence of fields in the SQL statement didn't >match correctly. > >Test plan: >- 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. > >Alternatively: >- Save your database >- truncate systempreferences; >- Load the sql file sysprefs.sql >- Verfiy as above > >Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> > >Tested creating new database, then loading kohastructure and sysprefs.sql >Without patch sysprefs fails to load, with patch loads Ok! >No koha-qa errors > >Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com> >--- > installer/data/mysql/sysprefs.sql | 12 ++++++------ > 1 file changed, 6 insertions(+), 6 deletions(-) > >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index 874aaf3..e881086 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/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'), >-- >1.9.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 13149
:
32789
|
32792
|
32800
|
32803
|
32804
|
32824
| 32825