ERROR 1292 (22007): Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘customer_dob’ at row 19553

SET SQL_MODE='ALLOW_INVALID_DATES'

Done the above configuration change and that solved my problem temporarly.