Project

General

Profile

Actions

Bug #53662

closed

DatabaseConnection INSERTquery does not allow NULL values

Added by Alexander Stehlik about 11 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
DataHandler aka TCEmain
Target version:
-
Start date:
2013-11-15
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.4
Tags:
Complexity:
no-brainer
Is Regression:
No
Sprint Focus:

Description

When you create a new record that has input fields with the new eval NULL setting the value is set correctly to NULL in the DataHandler but it is inserted as an empty string in the database.

The reason for this is, that the INSERTQuery() method in the DatabaseConnection class does not supply the $allowNull parameter to the fullQuoteArray() method. The UPDATEquery() method already does this so this can also be enabled for INSERTQuery().


Related issues 7 (0 open7 closed)

Related to TYPO3 Core - Feature #41773: Add possibility to store NULL valuesClosed2012-10-09

Actions
Related to TYPO3 Core - Bug #54917: Debug "Column 'first' cannot be null"Closed2014-01-12

Actions
Related to TYPO3 Core - Bug #54849: Functional tests cannot write to backend logClosedOliver Hader2014-01-08

Actions
Related to TYPO3 Core - Bug #55989: Debug "Column 'cookie' cannot be null"Closed2014-02-14

Actions
Related to TYPO3 Core - Bug #54412: Improve default value handling for NULL value fieldsClosed2013-12-14

Actions
Related to TYPO3 Core - Bug #63991: FAL override checkboxes are always active, when DBAL is installedClosed2014-12-19

Actions
Related to TYPO3 Core - Bug #81784: DatabaseConnection function INSERTmultipleRows does not allow NULL valuesClosed2017-07-04

Actions
Actions #1

Updated by Gerrit Code Review about 11 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/25422

Actions #2

Updated by Markus Klein about 11 years ago

Indeed a forgotten thing.

Actions #3

Updated by Gerrit Code Review almost 11 years ago

Patch set 1 for branch TYPO3_6-1 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/26638

Actions #4

Updated by Steffen Ritter almost 11 years ago

POST merge review done; OK

Actions #5

Updated by Alexander Stehlik almost 11 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #6

Updated by Gerrit Code Review almost 11 years ago

  • Status changed from Resolved to Under Review

Patch set 1 for branch TYPO3_6-0 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/26644

Actions #7

Updated by Alexander Stehlik almost 11 years ago

  • Status changed from Under Review to Resolved
Actions #8

Updated by Christian Reiter over 7 years ago

  • Related to Bug #81784: DatabaseConnection function INSERTmultipleRows does not allow NULL values added
Actions #9

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF