Project

General

Profile

Actions
Copy link

Bug #67708

closed

Invalid SQL: ProcessedFileChecksumUpdate compares BLOB with INTEGER column

Added by Morton Jonuschat almost 9 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Morton Jonuschat
Category:
Install Tool
Target version:
7.4 (Backend)
Start date:
2015-06-23
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
easy
Is Regression:
No
Sprint Focus:

Description

The following statement is performed during the 7.4-dev Upgrade Wizard:

SELECT COUNT(*) FROM "sys_file_processedfile" LEFT JOIN "sys_registry" ON "entry_key"="sys_file_processedfile"."uid" AND "entry_namespace"='ProcessedFileChecksumUpdate' WHERE ("entry_key" IS NULL AND "sys_file_processedfile"."identifier" <> '') OR "sys_file_processedfile"."width" IS NULL

This query compares a BLOB field with an INTEGER field without doing an explicit cast. This is fine on MySQL but fails on DBAL Installations, i.e. running PostgreSQL.

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #75932: SQL-Error in ProcessedFileChecksumUpdateClosedStephan Großberndt2016-04-26

Actions
Actions
Copy link

Also available in: Atom PDF