☰

安装和添加用户时 Wordpress 504 网关超时

tag-icon • tag-icon nginx php wordpress
安装和添加用户时 Wordpress 504 网关超时

我的 WordPress 安装出现了一些问题。我在 VPS 服务器上运行它。我安装了自己的 LEMP 堆栈。在运行 WordPress 安装时，在最后一步之后，需要一些时间才能加载，最后出现错误504 Gateway Time-out。但网站已安装，我可以登录管理面板。

在管理面板中，当我尝试创建用户时，发生了同样的事情。但用户已创建。奇怪的是，即使我勾选了发送框，用户也不会收到包含详细信息的电子邮件。

我的 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"

请注意，我尝试安装并重新安装多次。这是日志的最后几行。知道发生了什么吗？

答案1

我将首先检查这些条目

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

[错误] 32707#32707：*1 FastCGI 在 stderr 中发送：“PHP 消息：WordPress 数据库错误查询 SELECT f45o3Kp_ 的‘字段列表’中的未知列‘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 [错误]

您可能需要在虚拟主机和数据库中验证某些内容。如果这是新安装，并且您做了一些实验，您可以简单地删除数据库并重新安装。最后，我会检查 php 的超时配置。

相关内容