From 1361359f1df766d2dbd90cd26ba3d8101603c057 Mon Sep 17 00:00:00 2001 From: Andreas Roussos Date: Fri, 9 Sep 2016 19:46:33 +0300 Subject: [PATCH] Bug 16311 - Advanced search language limit typo MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit In the OPAC -> Advanced Search, the Language drop down menu incorrectly lists Romanian as "Român (Romanian)" while the correct value (as reported by Barry Cannon) is "Română (Romanian)". This patch fixes that: a) for _new_ installations by modifying installer/data/mysql/mandatory/subtag_registry.sql (loaded by the web installer when koha is installed), and also b) for _existing_ installations by adding an atomicupdate file in installer/data/mysql/atomicupdate/ Test plan: 1) In the OPAC, go to Advanced search (cgi-bin/koha/opac-search.pl). 2) In the 'Language' drop down menu, observe that the value for Romanian is "Român (Romanian)". 3) Apply the patch, and run installer/data/mysql/updatedatabase.pl. 4) Refresh the Advanced search page in the OPAC. Confirm that the patch worked, i.e. the Language drop down menu lists Romanian as "Română (Romanian)" (notice the added 'ă'). --- .../bug_16311-fix_typo_in_OPAC_adv_search_language_drop_down.sql | 1 + installer/data/mysql/mandatory/subtag_registry.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_16311-fix_typo_in_OPAC_adv_search_language_drop_down.sql diff --git a/installer/data/mysql/atomicupdate/bug_16311-fix_typo_in_OPAC_adv_search_language_drop_down.sql b/installer/data/mysql/atomicupdate/bug_16311-fix_typo_in_OPAC_adv_search_language_drop_down.sql new file mode 100644 index 0000000..fd3ae01 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_16311-fix_typo_in_OPAC_adv_search_language_drop_down.sql @@ -0,0 +1 @@ +UPDATE language_descriptions SET description = 'Română' WHERE subtag = 'ro' AND type = 'language' AND lang = 'ro'; diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index 5dc2af2..d3bbea8 100755 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -861,7 +861,7 @@ INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ro','rum'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ro', 'language', 'ro', 'Român'); +VALUES ( 'ro', 'language', 'ro', 'Română'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ro', 'language', 'en', 'Romanian'); -- 2.1.4