Invalid default value for 'column_name' - Knowledgebase - Licenceman | Sharedlicensing.com

Attention" Please Read Terms of Service Before make any purchase | Click Here"

Invalid default value for 'column_name' Print

0

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

Was this answer helpful?

Related Articles

cPanel password resets made in WHM do not update cPanel users database grants file. Symptoms Upon resetting a cPanel users password, you find that the users database grants... Can't add db user to db due to ER_PASSWORD_NO_MATCH error Symptoms Adding a database user to a database results in the following error, or similar: The... 500 ISE error when uploading database in phpMyAdmin compressed in zip format Symptoms When importing a sql dump compressed in the zip format into phpMyAdmin, you find... Error when you attempt to map a cPanel username to itself. Symptoms dbmap tool UI and CLI - fail with error when you attempt to map a cPanel username... UPCP warning in Ubuntu servers because of a non-responsive MariaDB repository/mirror. Symptoms The cPanel "upcp" script is reporting issues with the updates, we can see the...

Back

💰 We Accept "All Credit Cards , All cryptocurrency"