Bug #105541
openTYPO3 13.4: calling getSysTemplateRowsByRootline with empty array as $rootline causes sql error
0%
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 1 day ago
- File empty_rootline.patch empty_rootline.patch added
This patch solves it for me
Updated by Gerrit Code Review 1 day 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 1 day 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