Error importing database.sql content into local db
Opened this issue · 0 comments
Pole-web-EHESS commented
From the readme file :
- Get the database.sql file from the root directory and import that to your database.
Percona Server 5.7 :
"ERROR 1292 (22007) at line 752: Incorrect datetime value: '0000-00-00 00:00:00' for column 'created' at row 1".
Seems my install of MySQL runs in strict mode, I'll try to turn it off and see how it goes (SQL_MODE to NO_ENGINE_SUBSTITUTION). However, how about putting a real date as a default value (something like "1970-01-01 08:00:00") to get rid of this error ?