Orangescrum/orangescrum-community

Error importing database.sql content into local db

Opened this issue · 0 comments

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 ?