Kern needs two new languages in Translate5.
Because they had bad experiences with creating or changing languages directly in their database of your on-premise installation, they wanted us to do this.

All needed information about the languages can be found in the attached PDF.

Form more Details see https://jira.translate5.net/browse/TS-4289
or ask me Stephan

Problem #1

as Aleks mention, its not possible to add "ti-ER" and "ti-ET" without having a language "ti"

Problem #2

lcid 1164 is NOT ti-ER, but Dari "prs-AF"
see:
https://learn.microsoft.com/en-us/openspecs/office_standards/ms-oe376/6c085406-a698-4e12-9d4d-c3b0ee3dbc4a

and numbers are wrongly assigned. Should be:
1139 Tigrigna - Ethiopia ti-ER
2163 Tigrigna - Eritrea ti-ET

Solution

Maren Zieger said she still needs this languages but we can add them with the values we think are correct. Therefore we add them with the following parameter:

INSERT INTO `LEK_languages` SET 
`langName` = 'Tigrinisch',
`rfc5646` = 'ti',
`iso3166Part1alpha2` = 'ti',
`sublanguage` = 'ti-TI',
`rtl` = 0,
`iso6393` = 'tir';

INSERT INTO `LEK_languages` SET 
`langName` = 'Tigrinisch (Äthiopien)',
`lcid` = 1139,
`rfc5646` = 'ti-ER',
`iso3166Part1alpha2` = 'ti',
`sublanguage` = 'ti-ER',
`rtl` = 0,
`iso6393` = 'tir';

INSERT INTO `LEK_languages` SET 
`langName` = 'Tigrinisch (Eritrea)',
`lcid` = 2163,
`rfc5646` = 'ti-ET',
`iso3166Part1alpha2` = 'ti',
`sublanguage` = 'ti-ET',
`rtl` = 0,
`iso6393` = 'tir';

lcid come from there:
https://learn.microsoft.com/en-us/openspecs/office_standards/ms-oe376/6c085406-a698-4e12-9d4d-c3b0ee3dbc4a

and these are the translations:

DE					EN
Tigrinisch 			Tigrinya
Tigrinisch (Äthiopien)	Tigrinya (Ethiopia)
Tigrinisch (Eritrea)		Tigrinya (Eritrea)