Project

General

Profile

Actions

Bug #73007

closed

Epic #86307: Extbase allows to fetch deleted/hidden records (respects ignoreEnableFields)

Insufficient sysLanguageStatement does not respect enableFields for translations

Added by Philipp Wrann over 8 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Extbase + l10n
Start date:
2016-01-29
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
easy
Is Regression:
No
Sprint Focus:

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


Related issues 5 (2 open3 closed)

Related to TYPO3 Core - Bug #76974: Translation handling with starttime/stoptimeClosed2016-07-07

Actions
Related to TYPO3 Core - Bug #68672: setIgnoreEnableFields() should be inherited to language overlaysClosed2015-07-31

Actions
Related to TYPO3 Core - Bug #84955: Extbase persistence layer ignores query settingsNeeds Feedback2018-05-09

Actions
Related to TYPO3 Core - Bug #100638: setIgnoreEnableFields() does not work on language overlaysNew2023-04-17

Actions
Has duplicate TYPO3 Core - Bug #81040: Extbase QueryResult::count() incorrect for strict language modeClosed2017-04-27

Actions
Actions

Also available in: Atom PDF