just try to delete NO_ZERO_DATE and NO_ZERO_IN_DATE , from the sql_mode.
for example , add this line below in the mysqld.cnf and restart the service:
sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION