Project

General

Profile

Actions

Bug #81043

closed

TCA type select & MySQL-strict mode leads to exception

Added by Cihan Yesilöz over 7 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Extbase
Start date:
2017-04-27
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

TCA of type "select" leads to an exception when used with MySQL-strict-mode "STRICT_TRANS_TABLES".

TCA-configuration:

        'status' => [
            'exclude' => 1,
            'label' => 'Status',
            'config' => array(
                'type' => 'select',
                'renderType' => 'selectSingle',
                'items' => (
                    array('Level-1', 1),
                    array('Status-2', 2),
                    array('Status-3', 3)
                ),
                'default' => 1,
            ),
        ],

PHP-Code:

<?php
        $newUser = new User();
        $newUser->setStatus(1);
        $userRepository = $this->objectManager->get(UserRepository::class);
        $userRepository->add($newUser);
        $persistenceManager = $this->objectManager->get(PersistenceManager::class);
        $persistenceManager->persistAll();
?>

The exception thrown by TYPO3:

#1470230766: Incorrect integer value: '' for column 'status' at row 1 (More information)

When I revert the change in "typo3/sysext/extbase/Classes/Persistence/Generic/Mapper/DataMapFactory.php" in Line 335 in Commit https://github.com/TYPO3/TYPO3.CMS/commit/38a1bc5dd7990b63e45c0419065cd02fe91187e9#diff-a8aa95385a4a9a2e39c52f857dbc0e28 the error disappears. The error also disappears when I disable the sql strict mode "STRICT_TRANS_TABLES"

Actions #1

Updated by Cihan Yesilöz over 7 years ago

  • Is Regression set to Yes
Actions #2

Updated by Cihan Yesilöz over 7 years ago

  • Description updated (diff)
Actions #3

Updated by Wouter Wolters over 7 years ago

  • Assignee deleted (Christian Kuhn)
Actions #4

Updated by Cihan Yesilöz over 7 years ago

  • Description updated (diff)
Actions #5

Updated by Benni Mack over 7 years ago

  • Target version changed from 8 LTS to Candidate for patchlevel
Actions #6

Updated by Alex Kellner over 7 years ago

I can confirm the same issue for extension powermail with field tx_powermail_domain_model_answer.value_type

Actions #7

Updated by Oleg Karun over 7 years ago

Alex Kellner wrote:

I can confirm the same issue for extension powermail with field tx_powermail_domain_model_answer.value_type

The same problem. Fixed in TYPO3 8.7.x by adding in
AdditionalConfiguration.php

$GLOBALS['TYPO3_CONF_VARS']['DB'] = array(
        'Connections' => [
            'Default' => [
                'charset' => 'utf8',
                //... here your DB settings
                'initCommands' => 'SET sql_mode=\'\';',
            ],
        ],
);
Actions #8

Updated by Gerrit Code Review over 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/53565

Actions #9

Updated by Gerrit Code Review over 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/53565

Actions #10

Updated by Gerrit Code Review over 7 years ago

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

Actions #11

Updated by Gerrit Code Review over 7 years ago

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

Actions #12

Updated by Helmut Hummel over 7 years ago

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

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF