Invalid default value for 'created_date' bei Import

@sash456

• SQL version and vendor?
• Database schema (table that holds the created_date field)?
• Data (insert) sample for your created_date field?
• Result of the following SQL statement: SELECT @@GLOBAL.sql_mode; ?

Quote from sash456

Ich habe die komplette Datenbank durchsucht aber finde kein created_date Feld.

Quote from sash456

Wenn ich den Befehl jetzt eingebe, erhalte ich nach kurzer Zeit folgende Fehlermeldung: ERROR 1067 (42000) at line 155636: Invalid default value for 'created_date'

That error which you mentioned in your previous post is not the result of a black magic You have a schema with a wrong DEFAULT value for a datetime field.

Quote from sash456

Die Datenbank ist immer die selbe die ich importiere und es hat immer funktioniert. Es sind keine unterschiedliche Dumps.

Of course That was because SQL modes were not so strict As you can see in the result of the SQL statement I've asked you to execute, there are two SQL modes related to dates:

• NO_ZERO_IN_DATE: https://dev.mysql.com/doc/refm…l#sqlmode_no_zero_in_date
• NO_ZERO_DATE: https://dev.mysql.com/doc/refm…html#sqlmode_no_zero_date

How to switch back to old behavior

Edit the /etc/mysql/conf.d/imscp.cnf file and leave the sql_mode parameter empty as follows: sql_mode =. Once done, restart your SQL server: service mysql restart

Note that in i-MSCP version 1.5.2, the problem will be solved, according https://github.com/i-MSCP/imscp/blob/1.5.x/CHANGELOG#L83

@sash456

Any news?