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@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to