Recycler Scheduler job fails - due to missing doctrine bind variables
Recycler Scheduler job fails due to missing doctrine bind variables.To reproduce:
- Setup Recycler Scheduler job
- Select the "Backend Layout" table
Execution of task "Remove deleted records (recycler)" failed with the following message: An exception occurred while executing 'SELECT `icon` FROM `backend_layout` WHERE (`deleted` = :dcValue1) AND (`tstamp` < :dcValue2)': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':dcValue1) AND (`tstamp` < :dcValue2)' at line 1
This seems to be caused by
CleanerTask->deleteFilesForTable which reuses the $constraints from
CleanerTask->cleanTable, but without the doctrine createNamedParameter bind variables.
[BUGFIX] Do not use doctrine constraints without bind values
Changed so doctrine constraints without the corresponding
bind values aren't passed around.
The $constraints variable defined in CleanerTask->cleanTable
is reused in CleanerTask->deleteFilesForTable, but without
the doctrine createNamedParameter bind variables, since the
querybuilder is recreated. This caused the task to fail.
Tested-by: TYPO3com <firstname.lastname@example.org>
Reviewed-by: Thomas Hohn <email@example.com>
Reviewed-by: Wouter Wolters <firstname.lastname@example.org>
Tested-by: Wouter Wolters <email@example.com>
Reviewed-by: Markus Klein <firstname.lastname@example.org>
Tested-by: Markus Klein <email@example.com>