Skip to content

Instantly share code, notes, and snippets.

@kaorukobo

kaorukobo/how-to-solve-wordpress-invalid-default-value.sql

Created March 12, 2020 03:13
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save kaorukobo/718f4eb684ac01e1b65fc4cb69587fae to your computer and use it in GitHub Desktop.
Save kaorukobo/718f4eb684ac01e1b65fc4cb69587fae to your computer and use it in GitHub Desktop.
Download ZIP
How to solve the `invalid default value for 'post_date'` error on WordPress DB with MySQL when modifying the schema of wp_posts table
Raw
how-to-solve-wordpress-invalid-default-value.sql
SET SQL_MODE = '';
ALTER TABLE `wp_posts` CHANGE `post_date` `post_date` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00';
ALTER TABLE `wp_posts` CHANGE `post_date_gmt` `post_date_gmt` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00';
ALTER TABLE `wp_posts` CHANGE `post_modified` `post_modified` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00';
ALTER TABLE `wp_posts` CHANGE `post_modified_gmt` `post_modified_gmt` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00';
@pwastack
Copy link

pwastack commented Apr 6, 2024

great thanks, this save me hours!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment