1067 MySQL Origin: Data Last updated 13 Oct 2026

MySQL ERROR 1067 (42000): Invalid default value for 'created_at'

A column’s DEFAULT isn’t allowed in the current SQL mode — classically '0000-00-00 00:00:00' with NO_ZERO_DATE.

Exact message you may see Invalid default value for
Explore the map of this error Full error map →
Seen on: MySQL

Meaning

MySQL 5.7+ strict modes reject zero dates. Old dumps from MySQL 5.5/5.6 contain them.

Common causes

  • DEFAULT '0000-00-00 00:00:00' under NO_ZERO_DATE
  • Old schema dumps
  • TIMESTAMP defaults on MySQL 5.5 syntax

⚡ Quick fix

  1. Use DEFAULT CURRENT_TIMESTAMP or NULL
  2. Fix the dump before importing
  3. Temporarily adjust sql_mode for the import only

Detailed fix by platform

MySQL

  1. created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

How to diagnose

  1. Column — Which default?
  2. Mode — SELECT @@sql_mode

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1005 — MySQL ERROR 1005 (HY000): Can't create table (errno: 150 "Foreign key constraint is incorrectly formed") (MySQL)10051007 — MySQL ERROR 1007 (HY000): Can't create database 'x'; database exists (MySQL)10071008 — MySQL ERROR 1008 (HY000): Can't drop database 'x'; database doesn't exist (MySQL)10081051 — MySQL ERROR 1051 (42S02): Unknown table 'x' (MySQL)10511054 — MySQL ERROR 1054 (42S22): Unknown column in 'field list' (MySQL)10541060 — MySQL ERROR 1060 (42S21): Duplicate column name 'x' (MySQL)10601075 — MySQL ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key (MySQL)1075additionalProperties — API Error: Request failed schema validation (must NOT have additional properties / Additional properties are not allowed) (API)additionalProperties1067

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.