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. #52204
Issue Bug Rejected

#52204SQL error: Incorrect integer value: '' for column 'backend_layout

Stefan Neufeind 09/24/13, 00:11 updated 07/20/15, 19:40

Open in Forge Comment in Forge

Description

SQL error: ‘Incorrect integer value: ‘’ for column ‘backend_layout’ at row 1’ (pages:NEW12345)

This happens for me on master when trying to create a new page either by drag-n-drop in the page-tree or the new-wizard.

Reviews 1

  • main 24007[BUGFIX] Backend-layout fields: default to 0 instead of empty string Resolves this issue Abandoned Stefan Neufeind CR 0 V 0 → 6.2, 6.1, 6.0, 4.7, 4.5 Easy +2 −2 01/12/14, 03:11

Related issues 3

  • Bug #18866Cannot create page with Mysl in strict mode (STRICT_TRANS_TABLES) Related to Rejected v4.2 Martin Kutschker 05/28/08, 17:15
  • Bug #52206Default-values for text-fields Related to Closed v6.2 Stefan Neufeind 09/24/13, 01:05
  • Task #54883Document that TYPO3 CMS is not compatible with MySQL strict modes Related to Closed Documentation v6.2 Ernesto Baschny 01/09/14, 18:00
Parent task
#68397 Make TYPO3 work with MySQL strict mode
Author
Stefan Neufeind
Priority
Must have
TYPO3 version
6.2
© 2026 TYPO3 GmbH.
  • API
  • Privacy Policy
  • Legal Notice
  • Feedback