WP Database Error

#812756
  • Resolved Herbert Kikoy
    Rank Math free

    I keep getting these errors

    [01-Jun-2024 01:25:55 UTC] WordPress database error Table ‘driftsto_wp3.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘17817’ 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
    [01-Jun-2024 01:26:29 UTC] WordPress database error Table ‘driftsto_wp3.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT * FROM wp_rank_math_analytics_objects WHERE object_id = ‘17817’ 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
    [01-Jun-2024 01:31:04 UTC] WordPress database error Table ‘driftsto_wp3.wp_rank_math_analytics_objects’ doesn’t exist for query SHOW CREATE TABLE wp_rank_math_analytics_objects 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\Rest\Admin->tools_actions, apply_filters(‘rank_math/tools/analytics_fix_collations’), WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->analytics_fix_collations, RankMath\Helpers\DB::get_table_collation

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

    I apologize for the errors you are experiencing related to the WordPress database and the Rank Math plugin. The error messages indicate that the table ‘wp_rank_math_analytics_objects’ doesn’t exist in your database, causing queries to fail.

    To address this issue, you can follow these steps:

    1. Check Error Log: Verify if the error notice ‘Table wp_rank_math_analytics_objects doesn’t exist’ is present in the Error log of your website.

    2. Re-create Missing Database Tables: Go to Rank Math SEO → Status and Tools → Database Tools in your WordPress dashboard. Scroll down to find the option Re-create Missing Database Tables and click on it. This action will recreate the missing database table.

    Re-create Missing Database Tools

    1. Re-add Tracked Keywords: After recreating the table, please note that the keywords originally tracked will not be available anymore. You will need to add the keywords to the Keyword Manager again to track their performance.

    By following these steps, Rank Math should resolve the issue by creating a new database table for the missing one. If you encounter any further difficulties or need additional assistance, please feel free to reach out to our support team for further help.

    Thank you for bringing this matter to our attention. If you have any more questions or need further assistance, please let us know.

    Sources:
    Resolving Rank Math Analytics Related Issues » Rank Math
    Fatal Error Happening on Some Installations After 1.0.49 Update » Rank Math
    WordPress Database Error Commands Out of Sync; You Can’t Run This Command Now » Rank Math

    Hello,

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

    Please try recreating the missing database tables; navigate to Rank Math SEO → Status and Tools → Database Tools in your WordPress dashboard. Scroll down to find the option Re-create Missing Database Tables and click on it. This action will recreate the missing database table.
    https://rankmath.com/wp-content/uploads/2021/08/Re-create-missing-database-tables-1.jpg

    If the issue persists, we might need to take a closer look at the settings. Please edit the first post on this ticket and include your WordPress logins in the designated Sensitive Data section.

    Please do take a complete backup of your website before sharing the information with us.

    It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

    https://wordpress.org/plugins/temporary-login-without-password/

    You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

    https://wordpress.org/plugins/wp-security-audit-log/

    We really look forward to helping 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 2 replies - 1 through 2 (of 2 total)

The ticket ‘WP Database Error’ is closed to new replies.