You run into 1292 – Incorrect date value: ‘0000-00-00’ for column ‘date’ error because since version 5.7, MySQL enables SQL Strict Mode by default and does not permit ‘0000-00-00’ as a valid date value.
For more information check MySQL Documentation 5.7
