TYPO3 Forger
  • Dashboard
  • Get involved
  • Reviews
    Overview Ready for review Work in progress Needs action Needs review Needs verification Needs rebase Negative votes Reviewed and verified Ready to merge
  • Issues
    Stale issues Possible duplicates By category By month
  • Sprints
    Overview Initiatives TYPO3 Core Review board
  • Tools
    Backports ReST helper
  • Help
  • Search
  • Login
Esc

Words find the open ones, a number the issue and the change with it.

  1. Issues
  2. #68602
Issue Bug Closed

#68602NULL values in records get transformed to FALSE on T3D import

Morton Jonuschat 07/29/15, 07:00 updated 10/19/17, 21:59

Open in Forge Comment in Forge

Description

Given a database record with a NULL value in a column the export file generated will have a XML node like <field index="link" type="NULL"></field> – properly representing the NULL value.
On Import the value gets transformed into a boolean somewhere during the import.

Reviews 1

  • main 42260[BUGFIX] DataHandler: cast value to string in checkValueForInput() Resolves this issue Merged Morton Jonuschat CR +2 V +2 Easy +13 −1 08/05/15, 21:31

Related issues 3

  • Task #55082Impexp: for non active controls NULL has to be imported in xml mode Related to Closed Import/Export (T3D) v6.2 Marc Bastian Heinrichs 01/16/14, 17:39
  • Bug #68562Bool values need to be cast to integer for MySQL strict mode Related to Closed Database API (Doctrine DBAL) v7 Morton Jonuschat 07/27/15, 20:07
  • Bug #68810Remove NULL on sys_file_reference link in impexp functional test data Related to Closed Import/Export (T3D) v6.2 Marc Bastian Heinrichs 08/06/15, 23:06
Parent task
#68397 Make TYPO3 work with MySQL strict mode
Assigned to
Morton Jonuschat
Author
Morton Jonuschat
Priority
Should have
Category
Import/Export (T3D)
Target version
7.5
TYPO3 version
7
PHP version
5.6
© 2026 TYPO3 GmbH.
  • API
  • Privacy Policy
  • Legal Notice
  • Feedback