Attachment 26517 Details for Bug 11973 – [PASSED QA] Bug 11973 - Fix Armenian language description

[patch] [PASSED QA] Bug 11973 - Fix Armenian language description

PASSED-QA-Bug-11973---Fix-Armenian-language-descri.patch (text/plain), 2.58 KB, created by Katrin Fischer on 2014-03-22 08:58:32 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2014-03-22 08:58:32 UTC

Size: 2.58 KB

patch

obsolete

>From 94c54033631b0593b089c0f459ba7482e49a14a3 Mon Sep 17 00:00:00 2001
>From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
>Date: Thu, 20 Mar 2014 08:45:14 -0300
>Subject: [PATCH] [PASSED QA] Bug 11973 - Fix Armenian language description
>MIME-Version: 1.0
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 8bit
>
>This patch fix Armenian language description
>
>To test:
>1) Do a fake translation to Armenian,
>   mkdir koha-tmpl/intranet-tmpl/prog/hy-Armn
>2) Go to Administration > System preferences > I18N/L10N
>3) Armenian description looks like the second string in Bug description
>4) Apply the patch
>5) Run updatedatabase.pl
>6) Reload page, now description look as first string in
>Bug description (it's the sixth letter, similar to 't')
>
>Ammended patch, wrong column.
>
>Signed-off-by: Holger MeiÃner <h.meissner.82@web.de>
>Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
>Patch fixes the English sample file for translations and includes
>a database update to correct the string in existing installations.
>Passes all tests and QA script.
>---
> installer/data/mysql/en/mandatory/subtag_registry.sql | 2 +-
> installer/data/mysql/updatedatabase.pl                | 9 +++++++++
> 2 files changed, 10 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/en/mandatory/subtag_registry.sql b/installer/data/mysql/en/mandatory/subtag_registry.sql
>index b91aba9..64bcc1b 100755
>--- a/installer/data/mysql/en/mandatory/subtag_registry.sql
>+++ b/installer/data/mysql/en/mandatory/subtag_registry.sql
>@@ -83,7 +83,7 @@ INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
> VALUES( 'hy','arm');
> 
> INSERT INTO language_descriptions(subtag, type, lang, description)
>-VALUES ( 'hy', 'language', 'hy', '&#1344;&#1377;&#1397;&#1381;&#1408;&#1383;&#1398;');
>+VALUES ( 'hy', 'language', 'hy', 'ÕÕ¡ÕµÕ¥ÖÕ¥Õ¶');
> 
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES( 'hy', 'language', 'en', 'Armenian');
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 9039766..63af5cd 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -8074,6 +8074,15 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = "3.15.00.XXX";
>+if ( CheckVersion($DBversion) ) {
>+    $dbh->do(q{
>+        UPDATE language_descriptions SET description = 'ÕÕ¡ÕµÕ¥ÖÕ¥Õ¶' WHERE subtag = 'hy' AND lang = 'hy';
>+    });
>+    print "Upgrade to $DBversion done (Bug 11973 - Fix Armenian language description)\n";
>+    SetVersion($DBversion);
>+}
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>1.8.3.2

Actions: View | Diff | Splinter Review

Attachments on bug 11973: 26482 | 26493 | 26508 | 26517