TYPO3: SQL error: 'Incorrect integer value: '' for column 'sys_language_uid' at row 1'

sql typo3 typo3-7.6.x
Bharat Parmar picture Bharat Parmar · Nov 11, 2016 · Viewed 8.1k times · Source

I have newly setup TYPO3, but when I try to add/save content, it gives me this error:

SQL error: 'Incorrect integer value: '' for column 'sys_language_uid' at row 1

Answer

Oliver Hader picture Oliver Hader · May 2, 2018

The behavior is related to database management systems using strict mode, like MySQL since version 5.7. Disabling strict mode (like provided in the accepted answer) is just a work around.

The real solution would be to explicitly cast values to integer by modifying TCA (table configuration array) for the according field definitions.

Related questions

Extbase - get created sql from query

i want to get some database tables from my typo3 extensions. The Extension is based on extbase. The query always returns nothing but the data exists I've tried this: $query = $this->createQuery(); $query->statement('SELECT * FROM `my_table` …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More