[Koha] Adding languages to Advanced Search

[Rubén Fernández Asensio]

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