Project

General

Profile

Actions

Bug #80675

closed

Recycler Scheduler job fails - due to missing doctrine bind variables

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

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Recycler
Target version:
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 #1

Updated by Thomas Hohn almost 7 years ago

  • Subject changed from Recycler Scheduler job fails do to missing doctrine bind variables to Recycler Scheduler job fails - due to missing doctrine bind variables
  • Description updated (diff)
Actions #2

Updated by Gerrit Code Review almost 7 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52362

Actions #3

Updated by Christer V almost 7 years ago

To reproduce
  • Setup the "Remove deleted records" task
  • Select "Backend Layout" as table
  • Run
Actions #4

Updated by Gerrit Code Review almost 7 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52362

Actions #5

Updated by Christer V almost 7 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #6

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF