Error while restoring the table dump
Please check your current sql_modes by command:

show variables like 'sql_mode' ; 


Or 

You can include SET statement, before you run any statements put this in the first line: 

SET sql_mode = '';

Problem might be because of sql_modes. 

So change it by remove the sql_mode "NO_ZERO_IN_DATE,NO_ZERO_DATE" to make it work.

This is the default sql_mode in mysql new versions.