Hi David, it seems likely that these are unused. It would be nice to update our structure there, especially for easier translations. Bernardo has been working on something for this in the past: *Bug 12017* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12017> - Move language description out of database Katrin On 23.04.21 04:38, dcook@prosentient.com.au wrote:
Hi all,
I was looking at how to add languages to the Languages drop down in the OPAC advanced search and went down an unpleasant C4::Languages rabbithole…
But looking at language_descriptions, I’m wondering if perhaps we could delete the following data, as I imagine it’s very outdated and unused:
MySQL [koha_kohadev]> select * from language_descriptions;
+----------+----------+------+---------------------------------------+-----+
| subtag | type | lang | description | id |
+----------+----------+------+---------------------------------------+-----+
| opac | i | en | OPAC | 1 |
| opac | i | fr | OPAC | 2 |
| opac | i | de | OPAC | 3 |
| intranet | i | en | Staff Client | 4 |
| intranet | i | fr | Client personnel | 5 |
| intranet | i | de | Dienstoberfläche | 6 |
| prog | t | en | Prog | 7 |
| prog | t | fr | Prog | 8 |
| prog | t | de | Prog | 9 |
At the moment, it looks like adding a language requires manual SQL queries to language_subtag_registry, language_descriptions, and language_rfc4646_to_iso639. It’s a shame there is no native interface for updating it. I imagine a plugin could work out well for it, although I think for the library in mind they’ll probably just do a manual insert, as it’s not worth the development cost…
David Cook
Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia
Office: 02 9212 0899
Online: 02 8005 0595
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/