wp_rank_math_analytics_ga table doesn’t exist – again

  • Resolved breckf

    (@breckf)


    1 year, 2 months ago

    Hi,

    This issue referenced below appears to be back and has been for some time.

    https://www.ads-software.com/support/topic/table-db-wp_rank_math_analytics_ga-doesnt-exist/

    I have rebuilt the missing rank math tables numerous times, following the instructions provided in this old topic, and confirmed they get recreated. But the table keeps being dropped.

    I’ve updated the site to
    WP: 6.4.2
    WC: 8.4.0
    RM SEO: 1.0.209
    RM SEO PRO: 3.0.52

    Debug logs are being populated with the below when pages are visited.

    [29-Dec-2023 01:47:07 UTC] WordPress database error Table 'wpfq_rank_math_analytics_ga' doesn't exist for query SELECT page, SUM(pageviews) AS pageviews FROM wpfq_rank_math_analytics_ga WHERE created BETWEEN '2023-11-26 00:00:00' AND '2023-12-26 23:59:59' GROUP BY page ORDER BY pageviews DESC LIMIT 0, 5 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Analytics\Rest->get_post, RankMath\Analytics\Posts->get_post, apply_filters('rank_math/analytics/post_data'), WP_Hook->apply_filters, RankMathPro\Analytics\Posts->add_and_sort_data, RankMathPro\Analytics\Posts->add_badges, RankMathPro\Analytics\Posts->get_position_for_badges, RankMath\Admin\Database\Query_Builder->get
    [29-Dec-2023 01:47:07 UTC] WordPress database error Table 'wpfq_rank_math_analytics_ga' doesn't exist for query SELECT SQL_CALC_FOUND_ROWS t1.page as page, COALESCE( t1.pageviews, 0 ) as pageviews, COALESCE( t1.pageviews - t2.pageviews, 0 ) as difference
    FROM ( SELECT page, SUM(pageviews) as pageviews FROM wpfq_rank_math_analytics_ga WHERE 1=1 AND page IN ('/product/stuff/') AND created BETWEEN '2023-11-23 00:00:00' AND '2023-12-26 23:59:59' GROUP BY page ) as t1
    LEFT JOIN ( SELECT page, SUM(pageviews) as pageviews FROM wpfq_rank_math_analytics_ga WHERE 1=1 AND page IN ('/product/stuff/') AND created BETWEEN '2023-10-20 00:00:00' AND '2023-11-22 23:59:59' GROUP BY page ) as t2
    ON t1.page = t2.page     ORDER BY t1.pageviews DESC
    made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Analytics\Rest->get_post, RankMath\Analytics\Posts->get_post, apply_filters(‘rank_math/analytics/post_data’), WP_Hook->apply_filters, RankMathPro\Analytics\Posts->add_and_sort_data, RankMath\Analytics\Stats->get_analytics_data, RankMathPro\Analytics\Pageviews::get_pageviews

Viewing 1 replies (of 1 total)
  • Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @breckf,

    Thank you for contacting Rank Math support.

    The GA table is part of the PRO plugin, and providing assistance for the paid features here is against WP.org’s guidelines. Please open a new topic in our support forum so we can assist you further: https://rankmath.com/support/

    Looking forward to helping you.

Viewing 1 replies (of 1 total)
  • The topic ‘wp_rank_math_analytics_ga table doesn’t exist – again’ is closed to new replies.