Invalid default value for 'column_name'

Question

Why does my database fail to import with a similar error?

ERROR 1067 (42000) at line 1358: Invalid default value for 'update_date'

Answer

The field's default value is incompatible with the data type in the newer version of MySQL.

Within the database,VARCHARwill need to be changed toTIMESTAMP or DATETIME within the database.

Additional Resources.

Data Type Default Values