TYPO3 Core

I can confirm this. I have this bug also with tt_content table.

Sorry, tt_content works.
My fault was, that I am using a plugin and this plugin refers to its current record.
In $GLOBALS['TSFE']->currentRecord there is always the uid and not the localized uid. This has to be localized manually.

Related to http://bugs.typo3.org/view.php?id=16742 ?

I have a similar problem with tt_content table. Only records with default language (id:0) or all-language (id:-1) are in result of query (regardless which sys_language_uid is set).

config {
linkVars = L
sys_language_mode = content_fallback
sys_language_overlay = hideNonTranslated
}

[globalVar = GP:L=1]
config {
sys_language_uid = 1
language = en
locale_all = {$locale_all_en}
htmlTag_langKey = en_EN
}
[global]

tmp = CONTENT
tmp {
table = tt_content
select {
languageField = sys_language_uid
orderBy = tstamp DESC
pidInList = 1
recursive = 10
max = 5
}

...
}

I can confirm Stephan Vidar's issue. It's exactly the same here.

Is it possible that it's still in 4.5.2...

In my case, select.languageField = 0 would have no effect with sys_language_overlay = 1. If available, a localisation is still output. Bug or feature?

I tried to reproduce the des in a 6.2.7 site (as encountered it - or something similar - in a 4.5.39 site).

Funny enough, in that config, even the workaround from Soeren, which worked for me in the 4.5 site

select {
      pidInList = {$pidHome}
      //languageField = 0
      andWhere = sys_language_uid = 0
      max = 1
      where = colPos = 4
      selectFields = header
    }

would always return the localised record (sys_language_overlay = 1 in both setups)

I tried the following test with 9.5.5

Setup¶

- TYPO3 with two languages defined in the Site Configuration module

- italian (default)
- english (uid=1); with fallbacktype: strict

Full config (only relevant parts):

languages:
  -
    title: Italian
    enabled: true
    languageId: '0'
    base: /
    typo3Language: it
    locale: it_IT.UTF-8
    iso-639-1: it
    navigationTitle: Italiano
    hreflang: it-IT
    direction: ltr
    flag: it
  -
    title: English
    enabled: true
    languageId: '1'
    base: /en/
    typo3Language: default
    locale: en_EN.UTF-8
    iso-639-1: en
    navigationTitle: English
    hreflang: en-EN
    direction: ''
    fallbackType: strict
    flag: gb

- create a home page and translate it
- Install EXT:news and create a "news" sysfolder, translated (uid=5 in my case)

- write the following TypoScript setup (only relevant parts:

page=PAGE
page.15 = CONTENT
page.15 {
  table = tx_news_domain_model_news
  select {
    languageField = sys_language_uid
    pidInList = 5
  }
  renderObj = TEXT
  renderObj.field = author
  renderObj.wrap = |<br>
}

Text execution¶

I created some news records:

1. "Test 1" with language:"default" and with: Author Name: "Riccardo"
1.1. I translated it ("Test 1 ENG"), and set Author Name: custom value: "Richard"

2. "Test 2" with language: "all" and Author Name: "Giuseppe"

3. "Test 3" with language: "default" and Author Name: "Francesco"
3.1. I translated it ("Test 3 ENG") with Author Name: Value of default language

4. "Test 4" with language: "default" and Author Name: "Mario"

5. "Test 5" with language: "english" and Author Name: "Mary"

Results¶

The only result that I found to be "odd" (but I could be wrong and this behavior is correct) is the behavior of the record with language=all (-1) that is only visible in english.

[UPDATE] the record with language=all (-1) that is only visible in english (secondary language) also with fallbackType: fallback

Hey Riccardo,

can you recheck this in v9.5.8? I think this one https://review.typo3.org/c/Packages/TYPO3.CMS/+/59993 should have fixed this issue...

I repeated the test performed on my comment 12 on TYPO3 9.5.8 - the results (with comment) are:

The results are the same for both fallbacktype: strict and fallbacktype: fallback

I will soon test it on version 10.0.0

I performed the same test on my comment 12 with 8.7.26, the results are:

1) Without setting sys_language_mode and sys_language_overlay:

2) With:

 sys_language_mode = content_fallback
 sys_language_overlay = hideNonTranslated 

3) With:

 sys_language_mode = content_fallback
 sys_language_overlay = 1 

I don't know if other combinations should be tested and would work; I cannot test it right now with ext:news and 10.0.0 (not compatible), but I think that the same results of 9.5 applies.