Bug #105541
closedTYPO3 13.4: calling getSysTemplateRowsByRootline with empty array as $rootline causes sql error
100%
Description
If $rootline is empty, then a SQL like the following is produced by the query builder:
```
SELECT sys_template.* FROM sys_template INNER JOIN (SELECT ) pidlist ON (sys_template.pid = pidlist.uid)
```
The method is for exmample called by solr with an empty $rootline array if there are not typoscript records. This blows up the whole scheduler backend module even for unrelated scheduler tasks, see also https://github.com/TYPO3-Solr/ext-solr/issues/4208
If the $rootline array is empty it should be safe to return [] in this method.
If we do not want the method to be called at all with an empty array we should throw an exception.
Files
Updated by Lina Wolf 16 days ago
- File empty_rootline.patch empty_rootline.patch added
This patch solves it for me
Updated by Gerrit Code Review 16 days ago
- Status changed from New to Under Review
Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86887
Updated by Gerrit Code Review 16 days ago
Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86887
Updated by Gerrit Code Review 14 days ago
Patch set 1 for branch 12.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86902
Updated by Gerrit Code Review 14 days ago
Patch set 1 for branch 13.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86903
Updated by Georg Ringer 14 days ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 5c6656463a9b763ff886fd033c24a62e73d7b724.