I have a live WordPress website. Most of the tables are using
MyISAM storage engine with
UTF-8 encoding. I need to switch their storage engine to
innodb. But when I try to change the engine, I get errors like
invalid default value for 'post_date' &
invalid default value for 'user_registered'.
I can see other related(but not similar) issues says that I should
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00";
While others say I should
How can I skip the issue that
datetime columns are showing
invalid default value for 'COL_NAME' issue?
Is it safe if I changed the
datetime format and allowed invalid dates? Will that make errors in WordPress?