Issue Bug Closed

#80675Recycler Scheduler job fails - due to missing doctrine bind variables

Christer V 04/04/17, 11:05 updated 10/02/18, 11:00

Description

Recycler Scheduler job fails due to missing doctrine bind variables.

To reproduce:
  • Setup Recycler Scheduler job
  • Select the “Backend Layout” table
  • Run

Error:

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.

Reviews 1