Trying to install a Duplicator package locally, I was hitting an issue where the package wasn’t creating a number of tables (including wp_posts) in my database.

Debugged it by running database.sql script manually in mysql.

This produced a few errors of Invalid default value for datetime fields, mostly.

Page here has some insights into this:

The fix is to add



to my.cnf.