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 <wizzyrea@gmail.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

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 (file)
index 0000000..5a0d8e6
--- /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 a815a61..2799a44 100755 (executable)
--- 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)