Issue Bug Closed

#88072Language overlay in DatabaseQueryProcessor

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

Description

I have a page with two languages (0 = english, 1 = german). All categories are set to “All languages”. The categories are used on Pages or/and Content Elements

10 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
10 {
table = sys_category
selectFields = uid
pidInList = 3
join = sys_category_record_mm ON sys_category.uid = sys_category_record_mm.uid_local
where = (tablenames = 'tt_content' AND sys_category_record_mm.uid_foreign = {field:uid})
where.insertData = 1
as = cats
}

On the default page I get an array of the selected categories. On the german page the query on the database gets the right selected categories but the result gets afterwards killed by the language overlay resulting in an empty array for the german page.

Using “languageField = 0” has only effect on default language.

Reviews 0

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

History 10

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

    Moved to right projects. Guessed TYPO3 Version 9.

  2. Rainer Roskothen changed subject Language overlay in DatabaseQueryProcessor II Language overlay in DatabaseQueryProcessor description <span data-processor="relativetime" data-value="2019-04-09T14:12:45+00:00" > 04/09/19, 14:12 </span>

  3. Lidia Demin commented <span data-processor="relativetime" data-value="2021-06-15T13:58:38+00:00" > 06/15/21, 13:58 </span>

    Can confirm this on TYPO3 9.5.26. Can somebody tell me, if this behavior was fixed in version 10?

  4. Benni Mack commented and changed status New Closed <span data-processor="relativetime" data-value="2026-10-23T08:42:01+00:00" > 10/23/26, 08:42 </span>

    Fixed with #97639/#97710 (released in 11.5.29, 12.4.3, 13.0.0): ContentObjectRenderer now always selects the language field, so records with sys_language_uid = -1 aren’t dropped by the overlay when selectFields leaves it out. Verified on main with the query from this report. Closing.