Issue Bug Closed

#73007Insufficient sysLanguageStatement does not respect enableFields for translations

Philipp Wrann 01/29/16, 13:45 updated 03/24/20, 12:30

Description

The statement added to sql queries to load translated entities only respects the deleted falg.

If you define the starttime, endtime, hidden and feaccess features for translations no filters are applied on queries.

This results in a QueryResult containing a number of X Rows.

After mapping those elements will be hidden because in languageOverlay the fields ARE respected.

In my case i display the number of results found by the orm, followed by a paginated widget showing those results.

So it says “11 Results found”

But only 6 Results are rendered.

The Problem can be found in:
https://github.com/TYPO3/TYPO3.CMS/blob/master/typo3/sysext/extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php#L733

If additional enablefields are configured and not set as l10n_mode=exclude they must be appended as well.

This can be solved without touching anything else in the translation setup, a patch would only affect the subquery statement

The bug exists in 6.2 and 7 LTS

Reviews 5