If you try to create a new page, using either the drag’n’drop feature or the page action from context menu and getting an error such as:

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

You should check your MySQL configuration. More specific the sql-mode you have configured.
Typo3 is not compatible with the MySQL strict model. Check the example below to see how the configuration must be adapted (based on the default my.ini settings)

# Set the SQL mode to strict
# disable strict mode for typo3
Typo3: SQL Error during Page Create

Post navigation