Invalid default value for 0000-00-00 00:00:00 FIX

SELECT @@GLOBAL.sql_mode;
SET GLOBAL sql_mode = 'NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION';


SELECT @@SESSION.sql_mode;
Then you will get something like that default value:

'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

and then set sql_mode without 'NO_ZERO_DATE':

SET SESSION sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
If you have grants, you can do it also for GLOBAL:

SELECT @@GLOBAL.sql_mode;
SET GLOBAL sql_mode = 'NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION';