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@koha-fr.org ReportedBy: katrin.fischer@bsz-bw.de QAContact: koha-bugs@lists.koha-community.org CC: gmcharlt@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.