wp_rank_math_analytics_inspections doesn’t exist for query

  • Resolved jamieburchell

    (@jamieburchell)


    1 year ago

    Getting this error from the cron job after enabling the Google Analytics feature and connecting to an account:

    WordPress database error Table ‘redacted.wp_rank_math_analytics_inspections’ doesn’t exist for query DELETE FROM wp_rank_math_analytics_inspections WHERE page NOT IN ( SELECT page from wp_rank_math_analytics_objects ) made by include(‘/var/www/releases/119/vendor/johnpbloch/wp-cli-phar/wp’), include(‘phar:///var/www/releases/119/vendor/johnpbloch/wp-cli-phar/wp/php/boot-phar.php’), include(‘phar:///var/www/releases/119/vendor/johnpbloch/wp-cli-phar/wp/vendor/wp-cli/wp-cli/php/wp-cli.php’), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, Cron_Event_Command->run, Cron_Event_Command::run_event, do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_

    ?QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array(‘rank_math/analytics/clear_cache’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\Jobs->clear_cache

    RankMath Version 1.0.204
    WordPress Version 6.3.2

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

    (@rankmathteam)

    Hello @jamieburchell,

    Thank you for your query and we are so sorry about the trouble this must have caused.

    The best way to correct this is to set up the Analytics feature again.

    Firstly, please make sure that you are using the Prefix property and not the domain property.

    Ensure that you are using the latest version of Rank Math plugin. If not yet, please do update them. You may refer to our changelog page here: https://rankmath.com/changelog/

    Then, reconnect your Google account. Remove RankMath’s app from your Google apps permissions: https://myaccount.google.com/permissions

    Then, head over to your WordPress Dashboard > Rank Math > General Settings > Analytics and reconnect the Google service and this time, ensure that all permissions are checked:

    https://i.rankmath.com/i/jJKLYC
    https://i.rankmath.com/i/4EdFaV

    Let us know how that goes. Looking forward to helping you.

    Thread Starter jamieburchell

    (@jamieburchell)

    I only encountered this error from cron once. Am I to assume that everything is working properly if I do not continue to get the error? What can I check?

    Edit: The wp_rank_math_analytics_inspections table exists.

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @jamieburchell,

    In that case, there shouldn’t be any issues with your analytics anymore since the table is already created.

    Let us know if you still encounter that issue in the future and we will assist you further.

    Don’t hesitate to get in touch with us if you have any other questions.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wp_rank_math_analytics_inspections doesn’t exist for query’ is closed to new replies.