From b63c09e84ce5eb2cb78dbce68582a8597b2ea065 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sun, 2 Jun 2019 10:48:00 +0200 Subject: [PATCH] Bug 22770: Fix typo in German language description of el Fixes: Griechisch (Moern [1453- ] ==> Griechisch (Modern 1453-) To test: - Install de-DE language and activate it - Check the language pull down on advanced search has the typo - Apply patch and run database update - Check advanced search again - Verify the description now shows correctly Signed-off-by: Liz Rea --- .../mysql/atomicupdate/bug_22770_fix_language_description.perl | 7 +++++++ installer/data/mysql/mandatory/subtag_registry.sql | 2 +- 2 files changed, 8 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_22770_fix_language_description.perl diff --git a/installer/data/mysql/atomicupdate/bug_22770_fix_language_description.perl b/installer/data/mysql/atomicupdate/bug_22770_fix_language_description.perl new file mode 100644 index 0000000000..5a0d8e687c --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_22770_fix_language_description.perl @@ -0,0 +1,7 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( 'UPDATE language_descriptions SET description = "Griechisch (Modern 1453-)" + WHERE subtag = "el" and type = "language" and lang ="de"' ); + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 22770 - Fix typo in language description for el in German)\n"; +} diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index a815a616c4..2799a44259 100755 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -239,7 +239,7 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]'); +VALUES ( 'el', 'language', 'de', 'Griechisch (Modern 1453-)'); -- English INSERT INTO language_subtag_registry( subtag, type, description, added) -- 2.11.0