Bug #73007
closed
Epic #86307: Extbase allows to fetch deleted/hidden records (respects ignoreEnableFields)
Insufficient sysLanguageStatement does not respect enableFields for translations
0%
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
Updated by Gerrit Code Review almost 9 years ago
- Status changed from New to Under Review
Patch set 1 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/46348
Updated by Gerrit Code Review almost 9 years ago
Patch set 2 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/46348
Updated by Mathias Schreiber over 8 years ago
- Status changed from Under Review to New
Updated by
Updated by Gerrit Code Review over 7 years ago
- Status changed from Accepted to Under Review
Patch set 1 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52072
Updated by Gerrit Code Review over 7 years ago
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52097
Updated by Cornel Widmer over 7 years ago
- Related to Bug #76974: Translation handling with starttime/stoptime added
Updated by Axel Helmert over 7 years ago
- Has duplicate Bug #81040: Extbase QueryResult::count() incorrect for strict language mode added
Updated by Peter Niederlag over 7 years ago
- Related to Bug #68672: setIgnoreEnableFields() should be inherited to language overlays added
Updated by Riccardo De Contardi about 7 years ago
- Category changed from Extbase to Extbase + l10n
Updated by Gerrit Code Review over 6 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52097
Updated by Tymoteusz Motylewski about 6 years ago
- Related to Bug #84955: Extbase persistence layer ignores query settings added
Updated by Susanne Moog over 5 years ago
- Status changed from Under Review to Needs Feedback
Review was abandoned and maybe fixed in the mean time. Please check if the issue still persists in current TYPO3 versions.
Updated by Susanne Moog over 4 years ago
- Status changed from Needs Feedback to Closed
Extbase language handling was reworked and no feedback here for quite some time, closing the issue now. If you still have problems with this, please open a new issue with steps to reproduce and example code. Thanks!
Updated by Christian Kuhn over 1 year ago
- Related to Bug #100638: setIgnoreEnableFields() does not work on language overlays added