From 4e1dc5e8b79bcca755610ca9628bd9dc5ae8defd Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Fri, 25 Oct 2024 16:25:10 +0200 Subject: [PATCH] Bug 38274: Fix typo in arabic language description In installer/data/mysql/mandatory/subtag_registry.sql we see a missing char in arabic language description. Wee see this was correct before Bug 12250 : العربية Test plan : 1) Install a fresh Koha with this patch 2) Look in database : SELECT * FROM language_descriptions WHERE subtag='ar' AND type='language' AND lang='ar' => Check description is correct 3) On a old existing Koha 4) Install patch and run update database => Look in database and check description is correct Signed-off-by: David Nind Signed-off-by: Martin Renvoize Signed-off-by: Katrin Fischer --- installer/data/mysql/atomicupdate/bug_38274.pl | 13 +++++++++++++ installer/data/mysql/mandatory/subtag_registry.sql | 2 +- 2 files changed, 14 insertions(+), 1 deletion(-) create mode 100755 installer/data/mysql/atomicupdate/bug_38274.pl diff --git a/installer/data/mysql/atomicupdate/bug_38274.pl b/installer/data/mysql/atomicupdate/bug_38274.pl new file mode 100755 index 0000000000..9936d3b335 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_38274.pl @@ -0,0 +1,13 @@ +use Modern::Perl; +use Koha::Installer::Output qw(say_warning say_failure say_success say_info); + +return { + bug_number => "38274", + description => "Fix typo in arabic language description", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + $dbh->do(q{ UPDATE language_descriptions SET description='العربية' WHERE subtag='ar' AND type='language' AND lang='ar' }); + }, +}; diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index aad932f199..9c3b460dae 100644 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -83,7 +83,7 @@ INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ar','ara'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'لعربية'); +VALUES ( 'ar', 'language', 'ar', 'العربية'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ar', 'language', 'en', 'Arabic'); -- 2.39.5