[Koha-bugs] [Bug 5474] New: Missing sys prefs in translated sysprefs.sql

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Dec 6 15:09:39 CET 2010


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5474

           Summary: Missing sys prefs in translated sysprefs.sql
 Change sponsored?: ---
           Product: Koha
           Version: rel_3_2
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: Installation and upgrade (web-based installer)
        AssignedTo: henridamien at koha-fr.org
        ReportedBy: katrin.fischer at bsz-bw.de
         QAContact: koha-bugs at lists.koha-community.org
                CC: gmcharlt at gmail.com
   Estimated Hours: 0.0


The translated sysprefs.sql files are missing some newer changes, because
people only add changes and new parameters to en, but not to the other
languages.

Example: 
homeorholdingbranchreturn is missing from de-DE
Tagsmoderation is still NULL instead of 0

I looked at it-IT and other files too, the total of lines varies. I think all
files need to be checked and have probably differences to en.

There is a test in directory xt/syspref.t 

ok 1 - Open reference syspref file
installer/data/mysql/en/mandatory/sysprefs.sql
ok 2 - Found 250 sysprefs
ok 3 - Open translated sysprefs file
installer/data/mysql/de-DE/mandatory/sysprefs.sql
ok 4 - Found 248 sysprefs
not ok 5 - No syspref to add
ok 6 - No syspref to delete
ok 7 - Open translated sysprefs file
installer/data/mysql/it-IT/necessari/sysprefs.sql
ok 8 - Found 257 sysprefs
not ok 9 - No syspref to add
not ok 10 - No syspref to delete
ok 11 - Open translated sysprefs file
installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
ok 12 - Found 250 sysprefs
not ok 13 - No syspref to add
not ok 14 - No syspref to delete
ok 15 - Open translated sysprefs file
installer/data/mysql/uk-UA/mandatory/system_preferences_full_optimal_for_install_only.sql
ok 16 - Found 200 sysprefs
not ok 17 - No syspref to add
not ok 18 - No syspref to delete
ok 19 - Open translated sysprefs file
installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql
ok 20 - Found 200 sysprefs
not ok 21 - No syspref to add
[...]

It shows the missing system preferences, but does not catch the changed default
value for TagsModeration.

Fixing all syspref.files is one option - but with the new translatable syspref
editor another option would perhaps be to always use the en files.

A script to create the sql from the .pref files would probably be even better.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.


More information about the Koha-bugs mailing list