#88072Language overlay in DatabaseQueryProcessor
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.
Related issues 3
History 10
-
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>
-
Rainer Roskothen changed subject
Language overlay in DatabaseQueryProcessor IILanguage overlay in DatabaseQueryProcessor description <span data-processor="relativetime" data-value="2019-04-09T14:12:45+00:00" > 04/09/19, 14:12 </span> -
Rainer Roskothen changed category <span data-processor="relativetime" data-value="2019-04-22T14:59:06+00:00" > 04/22/19, 14:59 </span>
-
Susanne Moog changed Sprint Focus On Location Sprint <span data-processor="relativetime" data-value="2020-01-12T12:43:16+00:00" > 01/12/20, 12:43 </span>
-
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?
-
Oliver Hader changed Sprint Focus
On Location Sprint<span data-processor="relativetime" data-value="2022-11-03T09:04:20+00:00" > 11/03/22, 09:04 </span> -
Nikita Hovratov changed Related to #85284 <span data-processor="relativetime" data-value="2024-04-24T11:19:34+00:00" > 04/24/24, 11:19 </span>
-
Benni Mack changed Related to #97639 <span data-processor="relativetime" data-value="2026-10-23T08:41:37+00:00" > 10/23/26, 08:41 </span>
-
Benni Mack changed Related to #97710 <span data-processor="relativetime" data-value="2026-10-23T08:41:50+00:00" > 10/23/26, 08:41 </span>
-
Benni Mack commented and changed status
NewClosed <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.
Moved to right projects. Guessed TYPO3 Version 9.