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: https://wordpress.org/support/topic/invalid-default-value-database-install-fail-1/

The fix is to add

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION

to my.cnf.