Bug #9585

PDOException thrown if array contains NULL as value

Added by Robert Lemke almost 5 years ago. Updated almost 5 years ago.

Status:Resolved Start date:2010-09-03
Priority:Should have Due date:
Assigned To:Karsten Dambekalns % Done:

100%
Category:Persistence
Target version:TYPO3 Flow Base Distribution - 1.0 alpha 12
PHP Version: Complexity:
Has patch: Affected Flow version:

Description

SQLSTATE[HY000]: General error: 1 table properties_data has no column named null
10 PDO::prepare("INSERT INTO "properties_data" ("parent", "name", "index", "type", "null") VALUES (?, ?, ?, ?, ?)")
9 F3\FLOW3\Persistence\Backend\GenericPdo\Backend::storePropertyData("bc924de7-72e7-420e-9019-96fda74d1c4a", "contentObject", array)
8 F3\FLOW3\Persistence\Backend\GenericPdo\Backend::setProperties(array, 1)
7 F3\FLOW3\Persistence\Backend\GenericPdo\Backend::persistObject(F3\TYPO3CR\Domain\Model\Node_AOPProxy_Development)
6 F3\FLOW3\Persistence\Backend\AbstractBackend::persistObjects()

This happens if you try to persist an array as follows:

   protected $myVar = array(0 => NULL);

Associated revisions

Revision db9e49c6
Added by Karsten Dambekalns almost 5 years ago

[+BUGFIX] FLOW3 (Persistence): Allow NULL values in arrays

NULL values inside an array caused an exception (unknown column null).

Change-Id: I7f0955373ec324990bea75f68afd09326a993401
Fixes: #9585

History

#1 Updated by Robert Lemke almost 5 years ago

  • Status changed from Accepted to Under Review

#2 Updated by Karsten Dambekalns almost 5 years ago

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

Also available in: Atom PDF