WP error database wp551.wpzk_rank_math_analytics_gsc’ doesn’t exist

#143429
  • Resolved Fabio
    Rank Math free

    Hello
    i find this error in debug.log:
    WordPress error database Table ‘xxxxxx_wp551.wpzk_rank_math_analytics_gsc’ doesn’t exist per la query SELECT AVG(ctr) AS ctr FROM wpzk_rank_math_analytics_gsc WHERE created BETWEEN ‘2019-01-16 00:00:01’ AND ‘2020-01-22 23:59:59’ LIMIT 0, 1 fatta da 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\Analytics\Workflow\Jobs->calculate_stats, RankMath\Analytics\Keywords->get_top_keywords, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one

    How can solve this?
    Best regards
    Fabio

Viewing 4 replies - 1 through 4 (of 4 total)
  • Anas
    Rank Math business

    Hello,

    Thank you for contacting Rank Math, and sorry for any inconvenience caused.

    It seems like new tables are not getting created in the Database or some old plugin has left an incorrect entry.

    1. Please follow these steps to fix the issue:
    https://rankmath.com/kb/fatal-error-after-1-0-49-update/

    2. Please follow only the first 2 steps and clear your caches. The following steps mentioned in the article are for advanced users.

    Here’s a video screencast:
    https://i.rankmath.com/KStFug

    Please clear all the cache, including the server after following the above process.

    That should resolve the issue. Thank you.

    Hello,

    It also looks like some Analytics related tables are missing. If the above doesn’t work, Please follow these steps:

    1. Update to the latest version of Rank Math Free & PRO

    2. Ensure that the Advanced Mode is selected:
    advanced mode

    3. Re-create tables by clicking WP Dashboard > Rank Math > Status & Tools > Database Tools and click the Re-create database Table button.
    re-create analytics tables

    Please let us know if that helps.

    Fabio
    Rank Math free

    Hello
    i try these solutions and i will answer in the next days.
    Thanks
    Fabio

    Hi,

    Thanks for letting us know.

    We look forward to hearing how this goes.

    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 ‘WP error database wp551.wpzk_rank_math_analytics_gsc’ doesn’t exist’ is closed to new replies.