@@ -, +, @@ The code for Italian in advanced search limitations should be "ita"and not "ind". --- .../mysql/fr-FR/1-Obligatoire/subtag_registry.sql | 2 +- .../data/mysql/it-IT/necessari/subtag_registry.sql | 2 +- .../data/mysql/pl-PL/mandatory/subtag_registry.sql | 2 +- .../data/mysql/ru-RU/mandatory/subtag_registry.sql | 2 +- .../data/mysql/uk-UA/mandatory/subtag_registry.sql | 2 +- installer/data/mysql/updatedatabase.pl | 7 +++++++ 6 files changed, 12 insertions(+), 5 deletions(-) --- a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql +++ a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql @@ -273,7 +273,7 @@ INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'it', 'language', 'Italian','2005-10-16' ); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'it','ind'); +VALUES( 'it','ita'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'it', 'language', 'it', 'Italiano'); --- a/installer/data/mysql/it-IT/necessari/subtag_registry.sql +++ a/installer/data/mysql/it-IT/necessari/subtag_registry.sql @@ -314,7 +314,7 @@ INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'it', 'language', 'Italian','2005-10-16' ); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'it','ind'); +VALUES( 'it','ita'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'it', 'language', 'it', 'Italiano'); --- a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql +++ a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql @@ -312,7 +312,7 @@ INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'it', 'language', 'Italian','2005-10-16' ); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'it','ind'); +VALUES( 'it','ita'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'it', 'language', 'it', 'Italiano'); --- a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql +++ a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql @@ -312,7 +312,7 @@ INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'it', 'language', 'Italian','2005-10-16' ); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'it','ind'); +VALUES( 'it','ita'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'it', 'language', 'it', 'Italiano'); --- a/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql +++ a/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql @@ -312,7 +312,7 @@ INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'it', 'language', 'Italian','2005-10-16' ); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'it','ind'); +VALUES( 'it','ita'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'it', 'language', 'it', 'Italiano'); --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -7017,6 +7017,13 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.13.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do("UPDATE language_rfc4646_to_iso639 SET iso639_2_code='ita' WHERE rfc4646_subtag='it'"); + print "Upgrade to $DBversion done (Bug 9519: Wrong language code for Italian in the advanced search language limitations)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) --