errors

#889260
  • Resolved sillymunk
    Rank Math free

    My website over the weekend wasnt getting any tracking and I wasnt getting orders like usual so i knew something was wrong. when i went into rank math it told me to reconnect something so i did…. and this error shows up and i dont know what to do. I clicked the recreate tables like the help thing told me but it still shows up and something about floating tables. can you please help to fix it. i need to get my site running properly like last week… help!

    [02-Oct-2024 23:17:51 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query DELETE FROM wp_rank_math_analytics_objects WHERE object_type = ‘post’ AND object_id = 6514 made by do_action(‘wp_ajax_customize_save’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Customize_Manager->save, WP_Customize_Manager->save_changeset_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Watcher->update_post_info, RankMath\Admin\Database\Query_Builder->delete, RankMath\Admin\Database\Query_Builder->query
    [03-Oct-2024 19:24:10 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(created)) AS days FROM wp_rank_math_analytics_gsc LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_2110->include_cmb, cmb2_bootstrap, do_action(‘cmb2_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Options->register_option_page, include(‘/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php’), RankMath\Analytics\DB::info, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
    [03-Oct-2024 19:24:10 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_gsc LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_2110->include_cmb, cmb2_bootstrap, do_action(‘cmb2_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Options->register_option_page, include(‘/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php’), RankMath\Analytics\DB::info, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
    [03-Oct-2024 23:14:53 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query DELETE FROM wp_rank_math_analytics_objects WHERE object_type = ‘post’ AND object_id = 6519 made by apply_filters(‘handle_bulk_actions-edit-shop_order’), WP_Hook->apply_filters, WC_Admin_List_Table_Orders->handle_bulk_actions, WC_Order->update_status, WC_Order->save, WC_Abstract_Order->save, WC_Data_Store->update, WC_Order_Data_Store_CPT->update, Abstract_WC_Order_Data_Store_CPT->update, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Watcher->update_post_info, RankMath\Admin\Database\Query_Builder->delete, RankMath\Admin\Database\Query_Builder->query
    [04-Oct-2024 20:44:45 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(created)) AS days FROM wp_rank_math_analytics_gsc LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_2110->include_cmb, cmb2_bootstrap, do_action(‘cmb2_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Options->register_option_page, include(‘/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php’), RankMath\Analytics\DB::info, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
    [04-Oct-2024 20:44:45 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_gsc LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_2110->include_cmb, cmb2_bootstrap, do_action(‘cmb2_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Options->register_option_page, include(‘/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php’), RankMath\Analytics\DB::info, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
    [04-Oct-2024 23:33:18 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘618’ LIMIT 0, 1 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, RankMath\Admin\Database\Query_Builder->one
    [04-Oct-2024 23:59:01 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘618’ LIMIT 0, 1 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, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 00:08:33 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘618’ LIMIT 0, 1 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, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 00:22:44 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘6486’ LIMIT 0, 1 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, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 00:23:50 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘3488’ LIMIT 0, 1 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, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 00:28:09 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘6463’ LIMIT 0, 1 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, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 00:32:21 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘6497’ LIMIT 0, 1 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, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 00:42:13 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘618’ LIMIT 0, 1 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, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 00:48:21 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_rank_math_analytics_objects made by do_action(‘wp_ajax_inline-save’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_inline_save, edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Watcher->update_post_info, RankMath\Analytics\DB::update_object, RankMath\Analytics\DB::add_object, RankMath\Admin\Database\Query_Builder->insert
    [05-Oct-2024 19:57:11 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘618’ LIMIT 0, 1 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, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 19:58:50 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(page)) AS posts, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’ LIMIT 0, 1 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_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 19:58:50 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(t1.query) AS total,
    CASE
    WHEN t1.position BETWEEN 1 AND 3 THEN ‘top3’
    WHEN t1.position BETWEEN 4 AND 10 THEN ‘top10’
    WHEN t1.position BETWEEN 11 AND 50 THEN ‘top50’
    WHEN t1.position BETWEEN 51 AND 100 THEN ‘top100’
    ELSE ‘none’
    END AS position_type
    FROM (SELECT query, ROUND( AVG(position), 0 ) AS position
    FROM wp_rank_math_analytics_gsc
    WHERE created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’ AND DATE(created) = (SELECT MAX(DATE(created)) FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’)
    GROUP BY query
    ORDER BY position) as t1
    GROUP BY position_type 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_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords
    [05-Oct-2024 19:58:50 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(t1.query) AS total,
    CASE
    WHEN t1.position BETWEEN 1 AND 3 THEN ‘top3’
    WHEN t1.position BETWEEN 4 AND 10 THEN ‘top10’
    WHEN t1.position BETWEEN 11 AND 50 THEN ‘top50’
    WHEN t1.position BETWEEN 51 AND 100 THEN ‘top100’
    ELSE ‘none’
    END AS position_type
    FROM (SELECT query, ROUND( AVG(position), 0 ) AS position
    FROM wp_rank_math_analytics_gsc
    WHERE created BETWEEN ‘2024-07-27 00:00:00’ AND ‘2024-08-29 23:59:59’ AND DATE(created) = (SELECT MAX(DATE(created)) FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2024-07-27 00:00:00’ AND ‘2024-08-29 23:59:59’)
    GROUP BY query
    ORDER BY position) as t1
    GROUP BY position_type 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_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords
    [05-Oct-2024 19:58:50 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT AVG(ctr) AS ctr FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’ LIMIT 0, 1 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_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 19:58:50 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT AVG(ctr) AS ctr FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2024-07-27 00:00:00’ AND ‘2024-08-29 23:59:59’ LIMIT 0, 1 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_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 19:58:50 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT MAX(DATE(created)) as date, CASE WHEN created BETWEEN ‘2024-09-02 00:00:00’ AND ‘2024-09-07 23:59:59’ THEN ‘range1’ WHEN created BETWEEN ‘2024-09-08 00:00:00’ AND ‘2024-09-13 23:59:59’ THEN ‘range2’ WHEN created BETWEEN ‘2024-09-14 00:00:00’ AND ‘2024-09-19 23:59:59’ THEN ‘range3’ WHEN created BETWEEN ‘2024-09-20 00:00:00’ AND ‘2024-09-25 23:59:59’ THEN ‘range4’ WHEN created BETWEEN ‘2024-09-26 00:00:00’ AND ‘2024-10-02 23:59:59’ THEN ‘range5’ ELSE ‘none’ END AS ‘range_group’
    FROM wp_rank_math_analytics_gsc
    WHERE created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’
    GROUP BY range_group 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_keywords_overview, RankMath\Analytics\Keywords->get_top_position_graph
    [05-Oct-2024 19:59:06 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(wp_rank_math_analytics_gsc.page)) AS posts, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr FROM wp_rank_math_analytics_gsc WHERE wp_rank_math_analytics_gsc.created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’ LIMIT 0, 1 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_analytics_summary, RankMath\Analytics\Summary->get_posts_summary, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 19:59:06 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(object_id) AS count,
    CASE
    WHEN seo_score BETWEEN 81 AND 100 THEN ‘good’
    WHEN seo_score BETWEEN 51 AND 80 THEN ‘ok’
    WHEN seo_score BETWEEN 1 AND 50 THEN ‘bad’
    WHEN seo_score = 0 THEN ‘noData’
    ELSE ‘none’
    END AS type
    FROM wp_rank_math_analytics_objects
    WHERE is_indexable = 1

    GROUP BY type 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_analytics_summary, RankMath\Analytics\Summary->get_optimization_summary
    [05-Oct-2024 19:59:06 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(object_id) AS total, SUM(seo_score) AS score FROM wp_rank_math_analytics_objects WHERE is_indexable = 1 LIMIT 0, 1 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_analytics_summary, RankMath\Analytics\Summary->get_optimization_summary, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 19:59:16 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(wp_rank_math_analytics_gsc.page)) AS posts, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr FROM wp_rank_math_analytics_gsc WHERE wp_rank_math_analytics_gsc.created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’ LIMIT 0, 1 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\Summary->get_posts_summary, RankMath\Admin\Database\Query_Builder->one
    [05-Oct-2024 19:59:16 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects
    WHERE is_indexable = 1

    ORDER BY created DESC
    LIMIT 0 , 25 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\Posts->get_posts_rows_by_objects, RankMath\Analytics\Objects->get_objects_by_score
    [05-Oct-2024 19:59:16 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT count(*) FROM wp_rank_math_analytics_objects
    WHERE is_indexable = 1

    ORDER BY created 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\Posts->get_posts_rows_by_objects, RankMath\Analytics\Objects->get_objects_by_score
    [05-Oct-2024 19:59:16 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT page, MAX(CONCAT(page, ‘:’, DATE(created), ‘:’, LPAD((100 – position), 3, ‘0’))) as uid
    FROM wp_rank_math_analytics_gsc
    WHERE created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’ AND page IN (”)
    GROUP BY page 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\Posts->get_posts_rows_by_objects, RankMath\Analytics\Stats->get_analytics_data, RankMath\Analytics\Stats->get_position_data_by_dimension
    [05-Oct-2024 19:59:16 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT page, MAX(CONCAT(page, ‘:’, DATE(created), ‘:’, LPAD((100 – position), 3, ‘0’))) as uid
    FROM wp_rank_math_analytics_gsc
    WHERE created BETWEEN ‘2024-07-27 00:00:00’ AND ‘2024-08-29 23:59:59’
    GROUP BY page 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\Posts->get_posts_rows_by_objects, RankMath\Analytics\Stats->get_analytics_data, RankMath\Analytics\Stats->get_position_data_by_dimension
    [05-Oct-2024 19:59:16 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT
    t1.page as page, t1.clicks, t1.impressions, t1.ctr,
    COALESCE( t1.clicks – t2.clicks, 0 ) as diffClicks,
    COALESCE( t1.impressions – t2.impressions, 0 ) as diffImpressions,
    COALESCE( t1.ctr – t2.ctr, 0 ) as diffCtr
    FROM
    ( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(ctr) as ctr
    FROM wp_rank_math_analytics_gsc
    WHERE 1 = 1 AND created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’ AND page IN (”)
    GROUP BY page) as t1
    LEFT JOIN
    ( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(ctr) as ctr
    FROM wp_rank_math_analytics_gsc
    WHERE 1 = 1 AND created BETWEEN ‘2024-07-27 00:00:00’ AND ‘2024-08-29 23:59:59’ AND page IN (”)
    GROUP BY page) as t2
    ON t1.page = t2.page 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\Posts->get_posts_rows_by_objects, RankMath\Analytics\Stats->get_analytics_data, RankMath\Analytics\Stats->get_metrics_data_by_dimension
    [05-Oct-2024 19:59:26 UTC] WordPress database error Table ‘u451064995_sillymunk_wp.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(page)) AS posts, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2024-08-30 00:00:00’ AND ‘2024-10-02 23:59:59’ LIMIT 0, 1 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_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Admin\Database\Query_Builder->one

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hello,

    Thank you for contacting us and sorry for any inconvenience that this issue might have caused.

    To resolve this issue, please follow the steps outlined in our knowledgebase article on how to recreate missing database tables

    Then check under Rank Math SEO > Status & Tools > System Status > Rank Math and confirm that you see the Rank Math Analytics tables have been created.

    If it has not been created you can use the following SQL queries to create the table manually:

    Analytics Table: https://pastebin.com/Z3umKurm

    Analytics Objects: https://pastebin.com/HaL1hgkh

    Once done, please disconnect and reconnect Rank Math Analytics with all permissions.

    If you can’t do this yourself share the following link with your host so they can create the SQL tables manually for you.

    Let us know how that goes.

    Thank you.

    ok its still not working and not connecting.

    [moved to sensitive data section]

    can someone please help me! i havnt had any traffic to my website since last week!

    Rank Math has detected new post types: e-landing-page, e-floating-buttons. You may want to check the settings of the Titles & Meta page and the Sitemap.

    and this keeps popping up as well and i dont know what it means.

    Hello,

    This notice is shown when a plugin you recently installed and activated creates a custom post type on your website. You can learn about custom post types here: https://rankmath.com/blog/custom-post-type/

    Please note that this notice is simply a reminder for you to configure the SEO settings for these post types. If you forget to configure them, you might end up indexing a page on the search engine that shouldn’t be or end up with an irrelevant SEO title and meta description — which can most probably affect your search rankings.

    Here’s our guide you can follow for that: https://rankmath.com/kb/new-post-type-detected/

    If it’s still appearing, please follow the last section in the guide and clear your website’s cache.

    Hope that helps.

    Thank you.

    Hello,

    Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

    If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)

The ticket ‘errors’ is closed to new replies.