求给分析下 这个错误日志~

    • 5323
      楼主

      这是网站出现502出现错误是看到的,不知是否关系。谢谢

      wp_postmeta.meta_key = 'views'
      ) AND wp_posts.post_type = 'sites' AND ((wp_posts.post_status = 'publish') OR (wp_posts.post_author = 0 AND (wp_posts.post_status = 'private'))) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 5时发生Not unique table/alias: 'wp_postmeta'错误,这是由require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/onenav/search.php'), get_sidebar, locate_template, load_template, require_once('/themes/onenav/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, CSF_Widget->widget, hot_sites, WP_Query->__construct, WP_Query->query, WP_Query->get_posts查询的" while reading response header from upstream, client: 101.69.175.50, server: www.xxxxxxxxxxxxxxxxx.cc, request: "GET /page/2?post_type=sites&s=%E5%8A%A8%E6%BC%AB HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.xxxxxxxxxxxxxxxxx.cc", referrer: "https://www.xxxxxxxxxxxxxxxxx.cc/?post_type=sites&s=%E5%8A%A8%E6%BC%AB"
      2021/08/12 01:49:25 [error] 1043824#0: *510333 FastCGI sent in stderr: "PHP message: WordPress数据库查询SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id  WHERE 1=1  AND ( 
        wp_posts.post_date > '2021-04-14 01:49:25'
      ) AND ( 
        wp_postmeta.meta_key = 'views'
      ) AND wp_posts.post_type = 'sites' AND ((wp_posts.post_status = 'publish') OR (wp_posts.post_author = 0 AND (wp_posts.post_status = 'private'))) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 5时发生Not unique table/alias: 'wp_postmeta'错误,这是由require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/onenav/search.php'), get_sidebar, locate_template, load_template, require_once('/themes/onenav/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, CSF_Widget->widget, hot_sites, WP_Query->__construct, WP_Query->query, WP_Query->get_posts查询的" while reading response header from upstream, client: 101.69.175.50, server: www.xxxxxxxxxxxxxxxxx.cc, request: "GET /?post_type=sites&s=%E6%A8%B1%E8%8A%B1%E5%8A%A8%E6%BC%AB HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.xxxxxxxxxxxxxxxxx.cc", referrer: "https://www.xxxxxxxxxxxxxxxxx.cc/page/2?post_type=sites&s=%E5%8A%A8%E6%BC%AB"
      2021/08/12 06:16:26 [error] 1098638#0: *568204 FastCGI sent in stderr: "PHP message: WordPress数据库查询SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id  WHERE 1=1  AND ( 
        wp_posts.post_date > '2021-04-14 06:16:26'
      ) AND ( 
        wp_postmeta.meta_key = 'views'
      ) AND wp_posts.post_type = 'sites' AND ((wp_posts.post_status = 'publish') OR (wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 5时发生Not unique table/alias: 'wp_postmeta'错误,这是由require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/onenav/search.php'), get_sidebar, locate_template, load_template, require_once('/themes/onenav/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, CSF_Widget->widget, hot_sites, WP_Query->__construct, WP_Query->query, WP_Query->get_posts查询的" while reading response header from upstream, client: 101.69.175.55, server: www.xxxxxxxxxxxxxxxxx.cc, request: "GET /?post_type=sites&s=https%3A%2F%2Fwww.genshuixue.com%2F HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.xxxxxxxxxxxxxxxxx.cc", referrer: "https://www.xxxxxxxxxxxxxxxxx.cc/sites/3191.html"
      
      
      wp_postmeta.meta_key = 'views'
      ) AND wp_posts.post_type = 'sites' AND ((wp_posts.post_status = 'publish') OR (wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 5时发生Not unique table/alias: 'wp_postmeta'错误,这是由require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/onenav/search.php'), get_sidebar, locate_template, load_template, require_once('/themes/onenav/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, CSF_Widget->widget, hot_sites, WP_Query->__construct, WP_Query->query, WP_Query->get_posts查询的" while reading response header from upstream, client: 101.69.175.55, server: www.wwwwwwwwwwwwww.cc, request: "GET /?post_type=sites&s=https%3A%2F%2Fwww.genshuixue.com%2F HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.wwwwwwwwwwwwww.cc", referrer: "https://www.wwwwwwwwwwwwww.cc/sites/3191.html"
      2021/08/12 06:29:55 [error] 1117644#0: *571013 FastCGI sent in stderr: "PHP message: PHP Warning:  Invalid argument supplied for foreach() in /www/wwwroot/www.wwwwwwwwwwwwww.cc/wp-content/plugins/wp-super-cache/wp-cache.php on line 2050" while reading upstream, client: 101.69.175.55, server: www.wwwwwwwwwwwwww.cc, request: "GET /wp-admin/options-general.php?page=wpsupercache&tab=settings HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.wwwwwwwwwwwwww.cc", referrer: "https://www.wwwwwwwwwwwwww.cc/wp-admin/options-general.php?page=wpsupercache"
      2021/08/12 06:32:12 [error] 1118545#0: *571558 FastCGI sent in stderr: "PHP message: PHP Warning:  Invalid argument supplied for foreach() in /www/wwwroot/www.wwwwwwwwwwwwww.cc/wp-content/plugins/wp-super-cache/wp-cache.php on line 2050" while reading upstream, client: 101.69.175.55, server: www.wwwwwwwwwwwwww.cc, request: "POST /wp-admin/options-general.php?page=wpsupercache&tab=settings HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.wwwwwwwwwwwwww.cc", referrer: "https://www.wwwwwwwwwwwwww.cc/wp-admin/options-general.php?page=wpsupercache&tab=settings"
      2021/08/12 06:43:36 [error] 1118545#0: *573657 FastCGI sent in stderr: "PHP message: PHP Warning:  Invalid argument supplied for foreach() in /www/wwwroot/www.wwwwwwwwwwwwww.cc/wp-content/themes/onenav/inc/inc.php on line 1849" while reading response header from upstream, client: 101.69.175.55, server: www.wwwwwwwwwwwwww.cc, request: "POST /wp-admin/post.php HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.wwwwwwwwwwwwww.cc", referrer: "https://www.wwwwwwwwwwwwww.cc/wp-admin/post-new.php?post_type=sites&wp-post-new-reload=true"
      2021/08/12 08:14:59 [error] 1118545#0: *598688 FastCGI sent in stderr: "PHP message: PHP Warning:  Invalid argument supplied for foreach() in /www/wwwroot/www.wwwwwwwwwwwwww.cc/wp-content/themes/onenav/inc/inc.php on line 1849" while reading response header from upstream, client: 101.69.175.25, server: www.wwwwwwwwwwwwww.cc, request: "POST /wp-admin/post.php HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.wwwwwwwwwwwwww.cc", referrer: "https://www.wwwwwwwwwwwwww.cc/wp-admin/post-new.php?post_type=sites&wp-post-new-reload=true"

       

  • 孙锡源
    管理员

    错误原因是程序对postmeta表做了重复join拼接。问题语句:

    INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
    LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id

    然后你发出来的这个我目测是Nginx的日志,你应该把PHP的错误日志贴上来,那上面应该会有出错的具体行号。

    或者你也可以在你的主题中手工搜那段SQL中的关键字,找到出问题的代码,然后贴上来。

  • 正在查看 1 条回复
    • 哎呀,回复话题必需登录。

    加入 LitePress 论坛 ,参与知识分享与交流
    登录 注册 进行评论
    立即加入