Project

General

Profile

Actions
Copy link

Bug #69004

closed

Epic #68397: Make TYPO3 work with MySQL strict mode

RelationHandler->readList() removes items with value of 0

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

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
7.5
Start date:
2015-08-12
Due date:
% Done:

100%

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

Description

When debugging MySQL strict mode problems in regard to handling sys_language_uid (Incorrect integer value: '' for column 'sys_language_uid') I traced the source to the function RelationHandler->readList(). The function is removing items from the list which have a value of 0. The condition is in line 398 of RelationHandler.php:

if (((string)$theID != '' && $theID) && $theTable && isset($this->tableArray[$theTable])) {
Actions
Copy link

Also available in: Atom PDF