WordPress 504 Gateway在安装和添加用户时超时

我的WordPress安装有问题。 我正在VPS服务器上运行它。 我安装了我自己的LEMP堆栈。 当运行WordPress安装时,在最后一步之后,加载最后需要一些时间,最后出现504 Gateway Time-out错误。 但该网站已安装,我可以login到pipe理面板。

在pipe理面板里面,当我尝试创build一个用户时,同样的事情发生了。 但用户被创build。 奇怪的是,即使我勾选了发送邮件的方框,用户也不会收到包含详细信息的电子邮件。

我的nginx错误日志如下所示:

  PHP message: WordPress database error Table 'tkdpw39sna2.d3gsO9d_options' doesn't exist for query INSERT INTO `d3gsO9d_options` (`option_name`, `option_value`, `autoload`) VALUES ('rewrite_rules', '', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) made by wp_install, flush_rewrite_rules, WP_Rewrite->flush_rules, update_option, add_option" while reading upstream, client: 112.135.4.109, server: admin.whiteberryinteriors.com, request: "POST /wp-admin/install.php?step=2 HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock:", host: "admin.whiteberryinteriors.com", referrer: "http://admin.whiteberryinteriors.com/wp-admin/install.php?step=1" 2017/06/28 04:39:08 [error] 32272#32272: *72 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 112.135.4.109, server: admin.whiteberryinteriors.com, request: "POST /wp-admin/install.php?step=2 HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock", host: "admin.whiteberryinteriors.com", referrer: "http://admin.whiteberryinteriors.com/wp-admin/install.php?step=1" 2017/06/28 04:45:31 [error] 32272#32272: *143 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 112.135.4.109, server: admin.whiteberryinteriors.com, request: "POST /wp-admin/user-new.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock", host: "admin.whiteberryinteriors.com", referrer: "http://admin.whiteberryinteriors.com/wp-admin/user-new.php" 2017/06/28 04:51:27 [error] 32272#32272: *183 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 112.135.4.109, server: admin.whiteberryinteriors.com, request: "POST /wp-admin/user-new.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock", host: "admin.whiteberryinteriors.com", referrer: "http://admin.whiteberryinteriors.com/wp-admin/user-new.php" 2017/06/28 10:22:12 [notice] 32477#32477: signal process started 2017/06/28 10:24:38 [notice] 32490#32490: signal process started 2017/06/28 10:27:12 [error] 32491#32491: *199 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 112.135.4.109, server: admin.whiteberryinteriors.com, request: "POST /wp-admin/user-new.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock", host: "admin.whiteberryinteriors.com", referrer: "http://admin.whiteberryinteriors.com/wp-admin/user-new.php" 2017/06/28 10:44:16 [emerg] 32674#32674: "fastcgi_index" directive is duplicate in /etc/nginx/sites-enabled/white_admin:20 2017/06/28 10:45:56 [error] 32707#32707: *1 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'f45o3Kp_' in 'field list' for query SELECT f45o3Kp_" while reading response header from upstream, client: 112.135.4.109, server: admin.whiteberryinteriors.com, request: "POST /wp-admin/setup-config.php?step=2 HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock:", host: "admin.whiteberryinteriors.com", referrer: "http://admin.whiteberryinteriors.com/wp-admin/setup-config.php?step=1" 2017/06/28 10:50:25 [error] 32707#32707: *24 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 112.135.4.109, server: admin.whiteberryinteriors.com, request: "POST /wp-admin/user-new.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock", host: "admin.whiteberryinteriors.com", referrer: "http://admin.whiteberryinteriors.com/wp-admin/user-new.php" 2017/06/28 10:57:41 [error] 3520#3520: *5 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 112.135.4.109, server: admin.whiteberryinteriors.com, request: "POST /wp-admin/user-new.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock", host: "admin.whiteberryinteriors.com", referrer: "http://admin.whiteberryinteriors.com/wp-admin/user-new.php" 

请注意,我已经尝试安装和重新安装几次。 这是日志的最后几行。 有什么想法发生了什么?

我会开始检查这些条目

[emerg] 32674#32674:“/ etc / nginx / sites-enabled / white_admin:20 2017/06/28 10:45:56”fastcgi_index“指令重复

[错误] 32707#32707:* 1 FastCGI在stderr中发送:“PHP消息:WordPress数据库错误”字段列表中的未知列'f45o3Kp_'用于查询SELECT f45o3Kp_“,同时读取来自上游的响应头,客户端:112.135.4.109,服务器:admin.whiteberryinteriors.com,请求:“POST /wp-admin/setup-config.php?step=2 HTTP / 1.1”,上游:“fastcgi:// unix:/run/php/php7.0-fpm。 sock:“,主持人:”admin.whiteberryinteriors.com“,推荐人:” http://admin.whiteberryinteriors.com/wp-admin/setup-config.php?step=1 “2017/06/28 10:50: 25 [错误]

您可能需要在虚拟主机和数据库中进行validation。 如果这是一个新的安装,你做了一些实验,你可以简单地删除数据库,然后重新安装。 最后我会检查php的超时configuration。