#105541TYPO3 13.4: calling getSysTemplateRowsByRootline with empty array as $rootline causes sql error
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.
Reviews 3
Files 1
History 37
-
Lina Wolf commented and changed attached empty_rootline.patch <span data-processor="relativetime" data-value="2024-11-05T08:30:03+00:00" > 11/05/24, 08:30 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 86887 status
NewUnder Review <span data-processor="relativetime" data-value="2024-11-05T16:53:05+00:00" > 11/05/24, 16:53 </span> -
Gerrit Code Review pushed patch set 2 for main to change 86887 <span data-processor="relativetime" data-value="2024-11-05T17:20:56+00:00" > 11/05/24, 17:20 </span>
-
Gerrit Code Review pushed patch set 1 for 12.4 to change 86902 <span data-processor="relativetime" data-value="2024-11-07T09:52:17+00:00" > 11/07/24, 09:52 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 86903 <span data-processor="relativetime" data-value="2024-11-07T09:52:30+00:00" > 11/07/24, 09:52 </span>
-
Georg Ringer commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2024-11-07T09:55:09+00:00" > 11/07/24, 09:55 </span>Applied in changeset commit:5c6656463a9b763ff886fd033c24a62e73d7b724.
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:32:13+00:00" > 12/02/25, 14:32 </span>
This patch solves it for me