Project

General

Profile

Actions
Copy link

Bug #80675

closed

Recycler Scheduler job fails - due to missing doctrine bind variables

Added by Christer V about 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Recycler
Target version:
next-patchlevel
Start date:
2017-04-04
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.1
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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.

Actions
Copy link

Also available in: Atom PDF