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.

 

 

Tables not being created when installing Duplicator package

Leave a Reply

Your email address will not be published. Required fields are marked *

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Find out more about Webmentions.)