[Koha-bugs] [Bug 24975] Refactor database translations

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24975

--- Comment #109 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
There is still something confusing in the table design:
select * from l10n_source;
+----------------+----------+-----+------------------------+
| l10n_source_id | group    | key | text                   |
+----------------+----------+-----+------------------------+
|              1 | itemtype | BK  | Books                  |
|              2 | itemtype | BKS | Books                  |
|              3 | itemtype | CF  | Computer Files         |
select * from l10n_target;
+----------------+----------------+----------+-----------------+-------+
| l10n_target_id | l10n_source_id | language | translation     | fuzzy |
+----------------+----------------+----------+-----------------+-------+
|              2 |              1 | nl-NL    | Boek            |     0 |
|              3 |              2 | en       | BKS_EN          |     0 |
|              4 |              2 | nl-NL    | Boek            |     0 |
The source seems to be the English text. But I can translate it into EN again
via target. Easiest seems to be: prevent having EN in the target table.
Shouldnt we check if we are calling db_t btw for an English translation? We
should not be looking for the English translation of itemtype if we have the
description already in our object.

-- 
You are receiving this mail because:
You are watching all bug changes.