Repeated errors with DELETE query

#93822
  • Resolved Jane Mason
    Rank Math free

    Love the plug-in. Best on the market, but ..

    EordPress database error Table ‘virtuous_root.wp_rank_math_analytics_objects’ doesn’t exist for query DELETE FROM wp_rank_math_analytics_objects WHERE object_type = ‘post’ AND object_id = 11365 made by wp_dashboard, do_meta_boxes, wp_dashboard_quick_press, get_default_post_to_edit, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, RankMathAnalyticsWatcher->update_post_info, MyThemeShopDatabaseQuery_Builder->delete, MyThemeShopDatabaseQuery_Builder->query

    Help please 🙂

Viewing 15 replies - 1 through 15 (of 15 total)
  • Hello

    Thank you for contacting the support and sorry for any inconvenience that might have been caused due to that.

    Please re-install the plugin and let us know if that helps.

    Looking forward to helping you.

    OK. Just done that and will let you know.

    THanks

    Ok. Deactivated, deleted and re installed. Just got back the same error.

    Please, can you advise?

    Hello,

    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:

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

    If that doesn’t help, 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.
    Sensitive Data Section

    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.

    Matt
    Rank Math free

    Hi,

    I’m getting the same error when saving changes made to a menu.

    error

    Current RankMath version is 1.0.50

    I’ve followed the instructions linked in your Knowledge Base and GitHub page, but the issue still exists.

    I’m not sure why the missing wp_rank_math_analytics_objects table would be created by the GitHub _repair-action-scheduler script, as there are no references to that table name in the script at all.

    Thanks, Matt

    • This reply was modified 3 years, 6 months ago by Matt.
    • This reply was modified 3 years, 6 months ago by Matt.
    • This reply was modified 3 years, 6 months ago by Matt.

    Hello Matt,

    Thank you for contacting Rank Math and sorry for any inconvenience that might have been caused due to that.

    Have you followed the steps mentioned above? Doing that process can fix the issue for you.

    If still facing issue, please start a new ticket of your own and share you site’s WP Login details in the Sensitive area field so that we can check that.

    Looking forward to helping you.

    Thank you.​​​​​​​

    Hello,

    I have updated the sensitive data as requested. Can you please check further?

    Thank you.

    Hi, there

    Followed your advice precisely and still has the same errors

    Indeed, when I installed the plug-in the Plugin reported no changes.

    Appreciate your help here

    Thanks

    Creds above in a secure box above. Careful you are a temp admin :/

    Hello,

    The error suggests that one of the database tables that is required for Rank Math to function, does not exist on your setup. This is a rather unusual issue, as these tables should be created automatically when Rank Math is installed.

    I have logged in to your site to check the issue. We will need to investigate the MySQL database, and for this I installed the “WP phpMyAdmin” plugin from the official repository, however, the plugin is not working on your site, possibly due to server limitation. I have deleted the plugin.

    You have the following options:

    A. Share the phpMyAdmin access details in the Sensitive Data field (login URL, username, password, or the cPanel login details where we can access the same).

    B. Investigate and fix the issue yourself. Here’s what you need to do: log in to phpMyAdmin and check if wp_rank_math_analytics_gsc and wp_rank_math_analytics_objects tables exist. If either of them does not exist, run the correct SQL code manually to create it:
    For wp_rank_math_analytics_gsc
    https://pastebin.com/0VB1Tqaa

    For wp_rank_math_analytics_objects
    https://pastebin.com/5XwUjz1T

    Before running any SQL code, we strongly suggest creating a complete backup of the database. Please create a backup even if you choose to share the access details instead, as we may run the same code, and there’s always some risk involved when executing direct queries like this.

    Hope that helps.

    Hello,

    I have updated the sensitive data as requested. Can you please check further?

    Thank you.

    Thanks for that. very helpful.

    I have entered the Admin access details above in sensitive details. Please, let me know how you get on.

    Hello,

    Thank you for sharing the access details. I have logged in to your PhpMyAdmin and created the necessary tables manually. This seems to have fixed the issue, I don’t see the error anymore on your site. Please check your site to confirm.

    If there’s any issue, please let us know. Thank you.

    Balazs

    That’s great and thank you. I will monitor over the net few days.

    So far so good.

    Sajid Khan
    Rank Math business

    Hello,

    Sure. Please feel free to reply to this ticket when you have an update or open a new one.

    Looking forward to helping you. Thank you.

    ​​​​​​

    Hello I’ve exactly the same problem. These two tables doesnt exist and probably it was an error caused by upgrading RM.
    Opened another ticket but no one has ever answered. I’ve tried to follow the instructions here

    For wp_rank_math_analytics_gsc
    https://pastebin.com/0VB1Tqaa

    For wp_rank_math_analytics_objects
    https://pastebin.com/5XwUjz1T

    but the first one gave me this error

    #1709 – Index column size too large. The maximum column size is 767 bytes.

    so I cannot go on with the other one.

    Can you help?

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

The ticket ‘Repeated errors with DELETE query’ is closed to new replies.