Hrm... Issues with German launguage

[Hanne B. Stegemüller]

Hello again experts

18-06-2021 11:31 (UTC +2): Solved manually via  phpMyAdmin.

I have read this article about language files (text variables) again: https://tng.lythgoes.net/wiki/index.php?title=Text_variables_-_explained but maybe there is something I do not understand.

I have three languages on my site: Danish, English and German, but I realize that the German language is not shown correct though all the variables are present in German in the four files in the German-UTF8 folder.

When I look in the tng_eventtypes table it looks for example like this: (None of my 82 events have the German launguage):

(13, 'ADDR', '', 'Danish-UTF8|Addresse|English-UTF8|Address', 1, 0, 0, 0, 'I'),

But it should look like this:

(13, 'ADDR', '', 'Danish-UTF8|Addresse|English-UTF8|Address|German-UTF8|Adresse', 1, 0, 0, 0, 'I'),

1. Isn't the idea behind the languages that |German-UTF8|Adresse should be created automatically?
2. I have tested if I could use Custom Event Types i TNG itself. But maybe I do something wrong, because the the values in tng_eventtypes table do not change. I enter data  as shown on the screenshot. Is that wrong?
3. I have exported the tng_eventtypes.sql and have started to add German manually with Notepad++ for all the eventtypes. Is that stupid? Will that table be overwritten with the next new version and I have the wasted my time?

Edited June 18, 2021 by Hanne
Solved

[bhemph]

Hanne,
     That screenshot is where you can enter the custom event text for other languages, such as German.  The custtext files are for any language strings but the custom event display names.  I just tried entering a display language of French and added display text and chose both Save + Exit and Save + Stay and both ways saved the additional language string to the database in the format you indicate.  So I am not sure why you would need to update the database manually, but that table is only changed through the Custom Events Administration items and is never touched by a TNG upgrade.  So you wouldn't have to worry about an update changing your values in that table.

Brent

[Hanne B. Stegemüller]

Hi Brent

Thanks a lot for your reply. Sorry for my late reply, but it was night here 😎

It is strange, that you could enter the new language strings via TNG itself, and I couldn't. The strings really didn't go into the database. I think something is wrong here when I always run into strange issues, that other users don't have. Some day I will run a clean install with new database and new files to see if that changes  anything.

But anyway: I have updated the tng_eventtypes manually via phpMyAdmin, and all the eventtypes are now shown correct - also in German.

And all of you must remember that if some day you need something in Danish, could be tranlation of mods, I'll be happy to assist. I have the feeling we are not many Danes in this forum. 😎