Actions
Bug #78921
open
Copying records fails with SQL error without any message
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\';',
Updated by Tymoteusz Motylewski about 7 years ago
- Related to Bug #82756: Can't remove access starttime / endtime added
Updated by Susanne Moog about 7 years ago
- Related to Bug #82202: Database Analyzer does not work on MSSQL added
Updated by Susanne Moog about 7 years ago
- Related to Bug #81334: SQL-Error inserting renderType=selectSingle via Extbase on PostgreSQL added
Updated by Riccardo De Contardi almost 7 years ago
- Related to Bug #83005: Problems with Workspace and News added
Updated by Susanne Moog over 4 years ago
- Category changed from Backend User Interface to DataHandler aka TCEmain
Updated by Xavier Perseguers about 3 years ago
- Related to Bug #95513: SQL error: 'Incorrect integer value: '' for column 'grade' at row 1' added
Actions