Bug #81043
closedTCA type select & MySQL-strict mode leads to exception
100%
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"
Updated by Benni Mack over 7 years ago
- Target version changed from 8 LTS to Candidate for patchlevel
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
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=\'\';',
],
],
);
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
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
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
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
Updated by Helmut Hummel over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 1f81eac355bf073f8deba6dab7bee5544abbda15.