WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Please help - MySQL error after login (3 posts)

  1. pbseo
    Member
    Posted 1 year ago #

    Recently our website went down following a server outage. Ever since it came back online, I notice the following error on the homepage when I am logged in.

    I ran a repair on the database, but no help. Can anyone please advise what's going wrong here and how to fix it.

    Query Number: 1
    WP Query Object:
    object(WP_Query)#1247 (43) {
      ["query_vars"]=>
      &array(55) {
        ["error"]=>
        string(0) ""
        ["m"]=>
        int(0)
        ["p"]=>
        string(3) "350"
        ["post_parent"]=>
        string(0) ""
        ["subpost"]=>
        string(0) ""
        ["subpost_id"]=>
        string(0) ""
        ["attachment"]=>
        string(0) ""
        ["attachment_id"]=>
        int(0)
        ["name"]=>
        string(0) ""
        ["static"]=>
        string(0) ""
        ["pagename"]=>
        string(0) ""
        ["page_id"]=>
        string(3) "350"
        ["second"]=>
        string(0) ""
        ["minute"]=>
        string(0) ""
        ["hour"]=>
        string(0) ""
        ["day"]=>
        int(0)
        ["monthnum"]=>
        int(0)
        ["year"]=>
        int(0)
        ["w"]=>
        int(0)
        ["category_name"]=>
        string(0) ""
        ["tag"]=>
        string(0) ""
        ["cat"]=>
        string(0) ""
        ["tag_id"]=>
        string(0) ""
        ["author_name"]=>
        string(0) ""
        ["feed"]=>
        string(0) ""
        ["tb"]=>
        string(0) ""
        ["paged"]=>
        int(0)
        ["comments_popup"]=>
        string(0) ""
        ["meta_key"]=>
        string(0) ""
        ["meta_value"]=>
        string(0) ""
        ["preview"]=>
        string(0) ""
        ["s"]=>
        string(0) ""
        ["sentence"]=>
        string(0) ""
        ["fields"]=>
        string(0) ""
        ["category__in"]=>
        array(0) {
        }
        ["category__not_in"]=>
        array(0) {
        }
        ["category__and"]=>
        array(0) {
        }
        ["post__in"]=>
        array(0) {
        }
        ["post__not_in"]=>
        array(0) {
        }
        ["tag__in"]=>
        array(0) {
        }
        ["tag__not_in"]=>
        array(0) {
        }
        ["tag__and"]=>
        array(0) {
        }
        ["tag_slug__in"]=>
        array(0) {
        }
        ["tag_slug__and"]=>
        array(0) {
        }
        ["ignore_sticky_posts"]=>
        bool(false)
        ["suppress_filters"]=>
        bool(false)
        ["cache_results"]=>
        bool(true)
        ["update_post_term_cache"]=>
        bool(true)
        ["update_post_meta_cache"]=>
        bool(true)
        ["post_type"]=>
        string(0) ""
        ["posts_per_page"]=>
        int(15)
        ["nopaging"]=>
        bool(false)
        ["comments_per_page"]=>
        string(2) "50"
        ["no_found_rows"]=>
        bool(false)
        ["order"]=>
        string(4) "DESC"
      }
      ["tax_query"]=>
      object(WP_Tax_Query)#1395 (2) {
        ["queries"]=>
        array(0) {
        }
        ["relation"]=>
        string(3) "AND"
      }
      ["meta_query"]=>
      object(WP_Meta_Query)#1396 (2) {
        ["queries"]=>
        array(0) {
        }
        ["relation"]=>
        NULL
      }
      ["post_count"]=>
      int(0)
      ["current_post"]=>
      int(-1)
      ["in_the_loop"]=>
      bool(false)
      ["comment_count"]=>
      int(0)
      ["current_comment"]=>
      int(-1)
      ["found_posts"]=>
      int(0)
      ["max_num_pages"]=>
      int(0)
      ["max_num_comment_pages"]=>
      int(0)
      ["is_single"]=>
      bool(false)
      ["is_preview"]=>
      bool(false)
      ["is_page"]=>
      bool(true)
      ["is_archive"]=>
      bool(false)
      ["is_date"]=>
      bool(false)
      ["is_year"]=>
      bool(false)
      ["is_month"]=>
      bool(false)
      ["is_day"]=>
      bool(false)
      ["is_time"]=>
      bool(false)
      ["is_author"]=>
      bool(false)
      ["is_category"]=>
      bool(false)
      ["is_tag"]=>
      bool(false)
      ["is_tax"]=>
      bool(false)
      ["is_search"]=>
      bool(false)
      ["is_feed"]=>
      bool(false)
      ["is_comment_feed"]=>
      bool(false)
      ["is_trackback"]=>
      bool(false)
      ["is_home"]=>
      bool(false)
      ["is_404"]=>
      bool(false)
      ["is_comments_popup"]=>
      bool(false)
      ["is_paged"]=>
      bool(false)
      ["is_admin"]=>
      bool(false)
      ["is_attachment"]=>
      bool(false)
      ["is_singular"]=>
      bool(true)
      ["is_robots"]=>
      bool(false)
      ["is_posts_page"]=>
      bool(false)
      ["is_post_type_archive"]=>
      bool(false)
      ["query_vars_hash"]=>
      string(32) "caf8b1da7a724855b57b7c63db513e5f"
      ["query_vars_changed"]=>
      bool(false)
      ["thumbnails_cached"]=>
      bool(false)
      ["query"]=>
      array(0) {
      }
      ["request"]=>
      string(134) "SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID = 350 AND wp_posts.post_type = 'page'  ORDER BY wp_posts.post_date DESC "
    }
    Original SQL Query:
    string(319) "SELECT   wp_posts.* , wp_croer_posts.post_rank IS NULL AS isnull FROM wp_posts  LEFT JOIN wp_croer_posts ON (wp_posts.ID = wp_croer_posts.post_id AND wp_croer_posts.cat_id = 0) WHERE 1=1  AND wp_posts.ID = 350 AND wp_posts.post_type = 'page'  ORDER BY  isnull ASC, wp_croer_posts.post_rank ASC, wp_posts.post_date DESC "
    Result SQL Query:
    string(319) "SELECT   wp_posts.* , wp_croer_posts.post_rank IS NULL AS isnull FROM wp_posts  LEFT JOIN wp_croer_posts ON (wp_posts.ID = wp_croer_posts.post_id AND wp_croer_posts.cat_id = 0) WHERE 1=1  AND wp_posts.ID = 350 AND wp_posts.post_type = 'page'  ORDER BY  isnull ASC, wp_croer_posts.post_rank ASC, wp_posts.post_date DESC "
  2. HallMarc
    Member
    Posted 1 year ago #

    Have you looked at the db to see if there is content to be queried?

  3. pbseo
    Member
    Posted 1 year ago #

    Found out the problem. It was a plugin that was causing this.

    Thanks for your help Hall, much appreciated :)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags