使用复制器插件安装 wordpress 站点时出错"database error write ‘Invalid default value for"

Question

我使用复制器插件导出我的wordpress网站之一。现在，当尝试在我的本地主机上设置它时，它无法在数据库中导入几个表。

当检查复制器插件日志时，我发现了很多错误，少数是:

**********************************************************************

:

版本1.1.0PHP: 7.0.2 | SAPI: apache2handlerSERVER: Apache/2.4.17 (Win64) PHP/7.0.2

---

---

DATABASE-ROUTINES

---

————————————–服务器环境————————————–Mysql版本:5.7.9超时:5000MAXPACK: 1048576————————————–数据库的结果————————————–

**ERROR** database error write ‘Invalid default value for ‘comment_date” – [sql=
CREATE TABLE wp_comments (
comment_ID bigint(20) unsigned NOT NULL A…]
**ERROR** database error write ‘Invalid default value for ‘created” – [sql=
CREATE TABLE wp_duplicator_packages (
id bigint(20) unsigned NOT NUL…]
**ERROR** database error write ‘Invalid default value for ‘link_updated” – [sql=
CREATE TABLE wp_links (
link_id bigint(20) unsigned NOT NULL AUTO_IN…]
**ERROR** database error write ‘Invalid default value for ‘post_date” – [sql=
CREATE TABLE wp_posts (
ID bigint(20) unsigned NOT NULL AUTO_INCREME…]
**ERROR** database error write ‘Invalid default value for ‘user_registered” – [sql=
CREATE TABLE wp_users (
ID bigint(20) unsigned NOT NULL AUTO_INCREME…]
**ERROR** database error write ‘Table ‘ne.wp_duplicator_packages’ doesn’t exist’ – [sql=
/* INSERT TABLE DATA: wp_duplicator_packages */
INSERT INTO `wp_duplicato…]
**ERROR** database error write ‘Table ‘ne.wp_duplicator_packages’ doesn’t exist’ – [sql=INSERT INTO wp_duplicator_packages VALUES(“2”, “20151126_naturalexpressio…]
**ERROR** database error write ‘Table ‘ne.wp_duplicator_packages’ doesn’t exist’ – [sql=INSERT INTO wp_duplicator_packages VALUES(“3”, “20151126_naturalexpressio…]
**ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=
/* INSERT TABLE DATA: wp_posts */
INSERT INTO wp_posts VALUES(“4”, “1”, …]
**ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“5”, “1”, “2015-09-07 14:22:39”, “2015-09-07 …]
**ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“7”, “1”, “2015-09-07 14:30:51”, “2015-09-07 …]
**ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“8”, “1”, “2015-09-07 14:32:08”, “2015-09-07 …]
**ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“9”, “1”, “2015-09-07 14:32:36”, “2015-09-07 …]
**ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“10”, “1”, “2015-09-07 14:33:05”, “2015-09-07…]
**ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“11”, “1”, “2015-09-07 14:34:39”, “2015-09-07…]
**ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“19”, “1”, “2015-09-09 08:33:24”, “2015-09-09…]

---

我用谷歌搜索了一下，发现用NO_ENGINE_SUBSTITUTION更新sql_mode可以解决这个问题。

由于我使用的是LAMP，我打开/etc/mysql/my.cnf并添加以下行:

sql_mode=NO_ENGINE_SUBSTITUTION

并使用下面的命令重新启动apache服务器:

sudo service apache2 restart

但这并不能解决问题。让我知道你的解决方案....谢谢。

Answer 1

刚刚在wordpress支持主题中找到了解决方案，解决了我的问题。解决方案是更新数据库。复制器包中的SQL文件。步骤如下:

1. 打开数据库复制器归档文件
中的sql

2. 在文件的顶部添加下面的行。

   SET SESSION sql_mode='NO_ENGINE_SUBSTITUTION';

3. 保存文件和存档。
4. 现在像往常一样继续你的站点设置，安装一个复制器包:)

Answer 2

我通过在binmysqlmysql5.7.14文件夹中的my.ini文件中添加:sql-mode="来修复此问题。(在WAMP上-所以我猜这与LAMP类似)