Bug #78921

Copying records fails with SQL error without any message

Added by Andreas Kiessling almost 5 years ago. Updated over 1 year ago.

Status:
New
Priority:
Must have
Assignee:
-
Category:
DataHandler aka TCEmain
Target version:
-
Start date:
2016-12-08
Due date:
% Done:

0%

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

Description

I ran into this issue with MySQL running in strict mode and TCA generated from extension_builder.
When an integer column, e.g. l10n_parent lacks the default setting, e.g.

'default' => 0

the copy process silently fails, only in the main log the error shows up, even with DEV settings.

SQL error: 'Incorrect integer value: '' for column 'sys_language_uid' at row 1' (tx_your_table:NEW584946631ecf8679449302) (msg#1.1.12)

AFAIR, TCEmain errors showed up in older TYPO3 versions as a flash message, which would really help in this case to give the user some feedback. Since strict mode is default for MySQL 5.7, these errors will show up frequently with a lot of extensions.

To simulate the error in older MySQL versions, you can set:

'setDBinit' => 'SET sql_mode = \'STRICT_TRANS_TABLES\';',


Related issues

Related to TYPO3 Core - Bug #82756: Can't remove access starttime / endtimeClosed2017-10-13

Actions
Related to TYPO3 Core - Bug #82202: Database Analyzer does not work on MSSQLClosed2017-08-25

Actions
Related to TYPO3 Core - Bug #81334: SQL-Error inserting renderType=selectSingle via Extbase on PostgreSQLNewStephan GroƟberndt2017-05-24

Actions
Related to TYPO3 Core - Bug #83005: Problems with Workspace and NewsClosed2017-11-15

Actions
Related to TYPO3 Core - Bug #95513: SQL error: 'Incorrect integer value: '' for column 'grade' at row 1'New2021-10-07

Actions
#1

Updated by Tymoteusz Motylewski almost 4 years ago

  • Related to Bug #82756: Can't remove access starttime / endtime added
#2

Updated by Susanne Moog almost 4 years ago

  • Related to Bug #82202: Database Analyzer does not work on MSSQL added
#3

Updated by Susanne Moog almost 4 years ago

  • Related to Bug #81334: SQL-Error inserting renderType=selectSingle via Extbase on PostgreSQL added
#4

Updated by Riccardo De Contardi over 3 years ago

  • Related to Bug #83005: Problems with Workspace and News added
#5

Updated by Susanne Moog over 1 year ago

  • Category changed from Backend User Interface to DataHandler aka TCEmain
#6

Updated by Xavier Perseguers 11 days ago

  • Related to Bug #95513: SQL error: 'Incorrect integer value: '' for column 'grade' at row 1' added

Also available in: Atom PDF