From 945548533bac519ff66f9af429954586e58ee883 Mon Sep 17 00:00:00 2001 From: David Cook Date: Wed, 28 Apr 2021 04:53:07 +0000 Subject: [PATCH] Bug 28244: Fix typo in Ukrainian in language tables in English This changes the English of Ukranian to Ukrainian. 1) Apply patch 2) Go to http://localhost:8080/cgi-bin/koha/opac-search.pl 3) Click on "Language" drop-down 4) Note near the bottom it says "Ukrainian" instead of "Ukranian" Signed-off-by: Henry Bolshaw Signed-off-by: Victor Grousset/tuxayo Signed-off-by: Jonathan Druart --- installer/data/mysql/atomicupdate/bug_28244.perl | 8 ++++++++ installer/data/mysql/mandatory/subtag_registry.sql | 6 +++--- 2 files changed, 11 insertions(+), 3 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_28244.perl diff --git a/installer/data/mysql/atomicupdate/bug_28244.perl b/installer/data/mysql/atomicupdate/bug_28244.perl new file mode 100644 index 0000000000..897a26f2d6 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_28244.perl @@ -0,0 +1,8 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( "UPDATE language_subtag_registry SET description = 'Ukrainian' WHERE subtag='uk' and type='language' and description='Ukranian'" ); + $dbh->do( "UPDATE language_descriptions SET description = 'Ukrainian' WHERE subtag='uk' and type='language' and lang='en' and description='Ukranian'" ); + + # Always end with this (adjust the bug info) + NewVersion( $DBversion, 28244, "Fix Ukrainian typo in English"); +} diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index 2799a44259..3b281d30d6 100644 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -1090,9 +1090,9 @@ VALUES ( 'tr', 'language', 'fr', 'Turc'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'tr', 'language', 'de', 'Türkisch'); --- Ukranian +-- Ukrainian INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'uk', 'language', 'Ukranian','2005-10-16'); +VALUES ( 'uk', 'language', 'Ukrainian','2005-10-16'); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'uk','ukr'); @@ -1101,7 +1101,7 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'uk', 'language', 'uk', 'Українська'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'uk', 'language', 'en', 'Ukranian'); +VALUES ( 'uk', 'language', 'en', 'Ukrainian'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'uk', 'language', 'fr', 'Ukrainien'); -- 2.39.5