Issue Bug New Quiet

#88071Language overlay in DatabaseQueryProcessor

Rainer Roskothen 04/04/19, 10:26 updated 10/23/26, 08:42

Description

I have a page with two languages (0 = english, 1 = german). I use the following DatabaseQueryProcessor:

10 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
10 {
table = tt_content
selectFields = header, subheader
pidInList.field = uid
as = elements
}

If an english content element is hidden, than the german non-hidden element don’t show up.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.

Fix this issue

Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". How to create a patch

Commit message
[BUGFIX] Language overlay in DatabaseQueryProcessor Resolves: #88071 Releases: main

History 9

  1. Bastian Bringenberg commented and changed project id TYPO3 Version 9 <span data-processor="relativetime" data-value="2019-04-04T10:34:44+00:00" > 04/04/19, 10:34 </span>

    Moved to right projects. Guessed TYPO3 Version 9.

  2. Rainer Roskothen changed subject Language overlay in DatabaseQueryProcessor I Language overlay in DatabaseQueryProcessor (Close this issue please) is private <span data-processor="relativetime" data-value="2019-04-09T14:15:57+00:00" > 04/09/19, 14:15 </span>

  3. Rainer Roskothen changed subject Language overlay in DatabaseQueryProcessor (Close this issue please) Language overlay in DatabaseQueryProcessor description category is private <span data-processor="relativetime" data-value="2019-04-22T14:58:35+00:00" > 04/22/19, 14:58 </span>

  4. Christian Kuhn commented <span data-processor="relativetime" data-value="2020-07-30T20:22:17+00:00" > 07/30/20, 20:22 </span>

    See #85284 comment #5 for an explanation of the root cause of this issue. At the moment this is hard to solve in a good way in core and needs to be worked around somehow.

  5. Benni Mack commented <span data-processor="relativetime" data-value="2026-10-23T08:42:26+00:00" > 10/23/26, 08:42 </span>

    Still the case on main (v15), with fallbackType: strict and fallback. In connected mode, getRecords() only queries default-language records with visibility restrictions applied, and translations are overlaid afterwards. A hidden default record is never fetched, so its translation can’t appear. This applies to all content rendering (CONTENT, styles.content.get), not only DatabaseQueryProcessor (see #85284 note 5). With fallbackType: free, the translated record is shown. Changing this would change the connected-mode overlay model as a whole.