Issue Bug Closed

#85329Functional tests are broken on sql_mode STRICT_TRANS_TABLES

Tymoteusz Motylewski 06/21/18, 13:02 updated 10/02/18, 10:44

Description

change in:
https://review.typo3.org/#/c/57141/

changed some columns from double to tinytext.
The problem is that mysql doesn’t accept default value for text columns.

This in combination with

sql_mode = STRICT_TRANS_TABLES

result in error when you try to run functinal tests.

1) TYPO3\CMS\Workspaces\Tests\Functional\DataHandling\IRRE\ForeignField\Modify\ActionTest::changeParentContentSorting
SQL Error for table "tx_irretutorial_1nff_price": 
An exception occurred while executing 'INSERT INTO `tx_irretutorial_1nff_price` (`uid`, `pid`, `sorting`, `deleted`, `sys_language_uid`, `l18n_parent`, `l18n_diffsource`, `t3ver_wsid`, `t3ver_state`, `t3ver_stage`, `t3ver_oid`, `t3ver_move_id`, `title`, `parentid`, `parenttable`, `parentidentifier`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["7", "89", "1", "0", "0", "0", "", "0", "0", "0", "0", "0", "Price #1.1.1", "5", "tx_irretutorial_1nff_offer", ""]:

Field 'price' doesn't have a default value

Reviews 1