Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
mysql no zero date issue
# /etc/mysql/mysql.conf.d/mysql.cnf
[mysqld]
sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
@ryanburnette

This comment has been minimized.

Copy link
Owner Author

@ryanburnette ryanburnette commented Jul 13, 2020

Had to add this to the mysql configuration under [mysqld]. Required reading all the comments to work it out.

https://stackoverflow.com/a/41136490/2535178

@ryanburnette

This comment has been minimized.

Copy link
Owner Author

@ryanburnette ryanburnette commented Jul 13, 2020

This has only ever occurred for me when restoring a MySQL database manually from VaultPress on WordPress.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.