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.