TYPO3 Core

Why is this a problem of the Core? Wouldn't that be a TV issue?

I need it for TV, but the lack of "en" occurs in the List module for Website Language. That seems to be part of Core!

Have you added a Website Language record for english (in list mode) at the root element of your Typo3 page tree ?

Also you MUST add the following typoscript in your template setup :

//defaut language
config {
language = de
locale_all = de_DE
htmlTag_langKey = de-DE
}

// English language
[globalVar = GP:L = 1]
config {
sys_language_uid = 2 // <- this value MUST be the uid of the record you have just created in list mode at the root of the page tree and it may be different of the value of the &L= url parameter
language = en
locale_all = en_US
htmlTag_langKey = en-US
}

I have added a Website Language for English at the root page.

My configuration contains your elements for German as default and English for L=1. But I use sys_language_uid=1 because this is the id of the Website Language English.

But this does not repair the lack of "en" in Website Language.

Hi Bernd,

I have just put online a multi-language website featuring 6 languages and using Typo3 4.1.5 and I have not met such problem. I have already created 2 other web sites featuring multiple language using prior versions of Typo3 and they all run fine. Although I must admit at first language configuration in Typo3 is hard. But your issue looks more like a misconfiguration than a bug in Typo3 to me.

Make sure you have typed "English" in the "language" field of your language record under the site root.

Also, if not done already, make sure you have filled all steps indicated in the frontend localization guide :
http://typo3.org/documentation/document-library/extension-manuals/doc_l10nguide/1.0.0/view/

The trouble occurs only when you have a language different from English as default language. In actual TYPO3 versions, the field "ISO Code" in "Website Language" is a dropdown box of two-letter-elements. This field lacks "en" for English; you cannot manually add elements to fix this. This lack is not produced by a misconfiguration, but is a bug of TYPO3 core.

I can use the system nevertheless by choosing the wrong "de" for German instead of the lacking English "en" in the ISO code field. But this is just a bad approach, not a fix.

"en" must be added to the dropdown box of the ISO code field. This should be fixed by the right persons; discussions on misconfiguration will not help.

Hi Bernd,

Ok I understand better your problem. The thing is I do use French as a default language myself and and English as secondary language. The English language + ISO code does show for me in the list module when I create a website language record, so this issue should be specific to your machine.

What you can do to attempt fixing the the problem is :
- Upgrade to thelatest version of extension "static info tables" in the Ext manager. This should fix your problem.

If it does not solve the issue, look at your typo3 database using PHPMyadmin. Display the content of the table static_languages and look for the english record. You can find it directly by typing this SQL query :
SELECT * FROM `static_languages` WHERE lg_iso_2='EN'

If the record is not listed, you can insert it using the following SQL query :
INSERT INTO `static_languages` (`uid`, `pid`, `lg_iso_2`, `lg_name_en`, `lg_typo3`, `lg_country_iso_2`, `lg_collate_locale`, `lg_name_local`, `lg_sacred`, `lg_constructed`, `lg_name_de`, `lg_name_es`, `lg_name_it`, `lg_name_fr`) VALUES
(30, 0, 'EN', 'English', '', '', 'en_GB', 'English', 0, 0, '', '', '', '');

Regards,

Alban

Your database information is very interesting.

I have the latest stable TYPO3 with 4.1.6, the version of all installed extensions is latest.

"SELECT * FROM `static_languages` WHERE lg_iso_2='EN'" reports an element, but the table has a structure that is a bit different from yours. So I'm not sure whether I can use your INSERT statement.

To fix the database is not the way to solve the problem because each update could replace the changes. It is a core bug and must be fixed for TYPO3 4.1.7.

Bernd Warken

Bernd, neither TV nor static info tables are part of the Core. SO there's still nothing I see, which has to be fixed in the Core.

And where is a drop down filed with ISO codes? The one in table "Website lanuage" is called "Select Official Language (ISO code)" and lists language names and not ISO codes. And it lists English - in all my installations.

I just installed an actual version of TYPO3. There "Select Official Language (ISO code)" has language names, e.g. English.

But the TYPO3 installation for which I reported the bug has there a drop down field with two letter elements only. I do not know where this comes from. It is not produced by the extensions TV and static info tables.

Is there anyone who knows which extension or feature provokes the two letter drop down field for the ISO Code?

Resolved, no change required:

This is not a core problem, but has todo with old / corrupt / overwritten static_info_tables in the specific installation of the reporter.