Attachment 120321 Details for Bug 28244 – Bug 28244: Fix typo in Ukrainian in language tables in English

[patch] Bug 28244: Fix typo in Ukrainian in language tables in English

Bug-28244-Fix-typo-in-Ukrainian-in-language-tables.patch (text/plain), 2.72 KB, created by Victor Grousset/tuxayo on 2021-04-30 01:40:27 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Victor Grousset/tuxayo

Created: 2021-04-30 01:40:27 UTC

Size: 2.72 KB

patch

obsolete

>From c443de4561ffe8ca81e945068a983d68c939f7db Mon Sep 17 00:00:00 2001
>From: David Cook <dcook@prosentient.com.au>
>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 <bolshawh@parliament.uk>
>Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
>---
> 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.31.1

Actions: View | Diff | Splinter Review

Attachments on bug 28244: 120251 | 120277 | 120321 | 120322