From 9aac2c9051922d16c7f726dc72ed6c95c3c932a5 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 Signed-off-by: Martin Renvoize Signed-off-by: Martin Renvoize (cherry picked from commit eba980b3519263856c725cd42d4ff151d7822205) Signed-off-by: Fridolin Somers --- .../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.39.2