WordPress database error

#327321
  • We are seeing an issue in our error logs that we have not been able to understand and which is causing huge spike in server resource usage. Could you please assist us try to interpret what the issue is and possible how we can resolve it.

    2022-01-17 16:41:50 Error 162.158.88.226 AH01071: Got error ‘PHP message: WordPress database error Table ‘newszetu_new.wp_zfoy_rank_math_redirections_cache’ doesn’t exist for query SELECT * FROM wp_zfoy_rank_math_redirections_cache WHERE object_id = 160116 AND object_type = ‘post’ LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array(‘wp’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\\Redirections\\Redirections->do_redirection, RankMath\\Redirections\\Redirector->__construct, RankMath\\Redirections\\Redirector->flow, RankMath\\Redirections\\Redirector->from_cache, RankMath\\Redirections\\Cache::get_by_object_id, MyThemeShop\\Database\\Query_Builder->onePHP message: WordPress database error Table ‘newszetu_new.wp_zfoy_rank_math_redirections_cache’ doesn’t exist for query SELECT * FROM wp_zfoy_rank_math_redirections_cache WHERE BINARY from_url = ‘the-chips-are-down-why-theres-a-semiconductor-shortage’ LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array(‘wp’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\\Redirections\\Redirections->do_redirection, RankMath\\Redirections\\Redirector->__construct, RankMath\\Redirections\\Redirector->flow, RankMath\\Redirections\\Redirector->from_cache, RankMath\\Redirections\\Cache::get_by_url, MyThemeShop\\Database\\Query_Builder->onePHP message: WordPress database error Table ‘newszetu_new.wp_zfoy_rank_math_redirections’ doesn’t exist for query SELECT * FROM wp_zfoy_rank_math_redirections WHERE status = ‘active’ AND ( sources like ‘%a:2:{s:7:\\”pattern\\”;s:54:\\”the-chips-are-down-why-theres-a-semiconductor-shortage\\”;s:10:\\”comparison\\”;s:5:\\”exact\\”;}%’ or sources like ‘%the%’ or sources like ‘%chips%’ or sources like ‘%are%’ or sources like ‘%down%’ or sources like ‘%why%’ or sources like ‘%theres%’ or sources like ‘%a%’ or sources like ‘%semiconductor%’ or sources like ‘%shortage%’ ) ORDER BY updated DESC made by require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array(‘wp’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\\Redirections\\Redirections->do_redirection, RankMath\\Redirections\\Redirector->__construct, RankMath\\Redirections\\Redirector->flow, RankMath\\Redirections\\Redirector->everything, RankMath\\Redirections\\DB::match_redirections, MyThemeShop\\Database\\Query_Builder->getPHP message: WordPress database error Table ‘newszetu_new.wp_zfoy_rank_math_redirections’ doesn’t exist for query SELECT * FROM wp_zfoy_rank_math_redirections WHERE status = ‘active’ ORDER BY updated DESC made by require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array(‘wp’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\\Redirections\\Redirections->do_redirection, RankMath\\Redirections\\Redirector->__construct, RankMath\\Redirections\\Redirector->flow, RankMath\\Redirections\\Redirector->everything, RankMath\\Redirections\\DB::match_redirections, RankMath\\Redirections\\DB::match_redirections, MyThemeShop\\Database\\Query_Builder->get’, referer: https://newszetu.com/the-chips-are-down-why-theres-a-semiconductor-shortage/

    Apache error

Viewing 1 replies (of 1 total)
  • Hello,

    Thank you for contacting Rank Math and bringing your concern to our attention. I’m sorry for any inconvenience this issue may have caused you.

    From the error log you have sent, it seems that there are some missing database tables.

    To fix this, head over to Rank Math > Status & Tools > Database Tools and click the Recreate tables button

    Recreate

    Please note that some options are only available when you enable the Advanced Mode in Rank Math. If it’s not showing, you must have chosen to use the Easy Mode. Please follow the steps in this link to switch to Advanced Mode:
    https://rankmath.com/kb/advanced-mode/

    Once done, clear your website’s cache and check again.

    I 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 1 replies (of 1 total)

The ticket ‘WordPress database error’ is closed to new replies.