[Koha] Adding languages to Advanced Search

[Katrin Fischer]

Hi Rubén,

first and second look the same to me? It looks about right. I just ran 
the SQL in my test database and Esperanto showed up in the language pull 
down.

Katrin


On 20.08.2018 09:34, Rubén Fernández Asensio wrote:
>
> I'd rather file a bug, but adding Esperanto (and other languages) has 
> already been proposed:
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18493
>
> Why is the status of that bug "Failed QA"?
> I suspect the only way of having that bug fixed and Esperanto added to 
> Koha Advanced Search may be providing a solution myself...
>
> OK, let's say I type something like this:
>
> INSERT INTO language_subtag_registry( subtag, type, description, 
> added) VALUES ( 'eo', 'language', 'Esperanto','2018-08-20');
>
> INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) 
> VALUES ( 'eo', 'epo');
>
> INSERT INTO language_descriptions(subtag, type, lang, description) 
> VALUES ( 'eo', 'language', 'eo', 'Esperanto');
>
> INSERT INTO language_descriptions(subtag, type, lang, description) 
> VALUES ( 'eo', 'language', 'en', 'Esperanto');
>
> And this:
>
> INSERT IGNORE INTO language_subtag_registry( subtag, type, 
> description, added) VALUES ( 'eo', 'language', 'Esperanto','2018-08-20');
>
> INSERT IGNORE INTO 
> language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 
> 'eo', 'epo');
>
> INSERT IGNORE INTO language_descriptions(subtag, type, lang, 
> description) VALUES ( 'eo', 'language', 'eo', 'Esperanto');
>
> INSERT IGNORE INTO language_descriptions(subtag, type, lang, 
> description) VALUES ( 'eo', 'language', 'en', 'Esperanto');
>
> What should I do next?
>
>
> El 20/08/18 a les 08:09, Katrin Fischer ha escrit:
>> Example:
>>
>> INSERT IGNORE INTO language_descriptions(subtag, type, lang, 
>> description) VALUES ( 'ka', 'language', 'ka', 'ქართული');
>>
>> For translations:
>> INSERT IGNORE INTO language_descriptions(subtag, type, lang, 
>> description) VALUES ( 'ka', 'language', 'fr', 'Géorgien');
>> ...
>>
>> You could also file a bug on bugzilla about adding Esperanto to the 
>> list for new versions.
>>
>> Katrin
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha