Project

General

Profile

Actions

Bug #18866

closed

Epic #68397: Make TYPO3 work with MySQL strict mode

Cannot create page with Mysl in strict mode (STRICT_TRANS_TABLES)

Added by Martin Kutschker almost 16 years ago. Updated almost 9 years ago.

Status:
Rejected
Priority:
Should have
Category:
-
Target version:
-
Start date:
2008-05-28
Due date:
% Done:

0%

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

Description

When I want to create a page I get an Mysql error saying that it has an inavlid value for an integer field. The problem is that "storage_pid" is when not set initially an empty string. It seems that I get only default values in strict mode for NULL, but no type conversion from empty string to 0 occurs.

A possible solution would be to use 0 as TCA default, but I think it is more proper to make the conversion in TCEmain if necessary.

(issue imported from #M8542)


Files

bug_8542.diff (1.24 KB) bug_8542.diff Administrator Admin, 2008-05-28 17:16

Related issues 5 (0 open5 closed)

Related to TYPO3 Core - Bug #52204: SQL error: Incorrect integer value: '' for column 'backend_layoutRejected2013-09-24

Actions
Related to TYPO3 Core - Bug #52206: Default-values for text-fieldsClosed2013-09-24

Actions
Related to TYPO3 Core - Bug #52596: Creating pages tries to assign empty string to integer fieldClosed2013-10-07

Actions
Related to TYPO3 Core - Task #54883: Document that TYPO3 CMS is not compatible with MySQL strict modesClosedErnesto Baschny2014-01-09

Actions
Is duplicate of TYPO3 Core - Bug #20052: SQL error: 'Incorrect integer value: '' for column 'storage_pid' at row 1' (pages:NEW499d21cdec168)Rejected2009-02-19

Actions
Actions

Also available in: Atom PDF