Lots of DB recurring errors

#137304
  • Resolved CH1800
    Rank Math free

    Hello,

    All sites running with RankMath get daily PHP errors like the one attached here.
    I run all options found under Status & Tools > Database tools for all websites but they still continue daily errors like those here.

    What else should I do?

    Thanks.

Viewing 15 replies - 1 through 15 (of 20 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.

    Assuming you are using the latest version of all the plugins and the themes (please update if not yet), it would seem like a conflict with one of the plugins or the theme you are using.

    To determine that, please follow this troubleshooting guide:
    https://rankmath.com/kb/check-plugin-conflicts/

    Only the site admin would know and your users won’t be affected by this troubleshooting.

    If the issue persists, please include your WordPress & FTP 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/

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

    Thank you, and we really look forward to helping you.

    CH1800
    Rank Math free

    Thanks for this but nothing really solves the problem.

    This happens on a daily basis, 1 error/day, at 8 different sites hosted at different servers. There is no plugin conflict and this error does not relate to a plugin conflict.

    I had already used the re-create DB tool and all others found at same page and I did it again but doesn’t solve the issue.

    I guess many users have the same errors but they simply do not monitor their servers.

    There is simply something wrong with the plugin that relates to the Analytics connection as this started with recent versions that added the Analytics features.

    Hello,

    From the error, it seems your site is missing some required tables. Could you please recreate tables by following 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.

    CH1800
    Rank Math free

    Thanks Michael, but as I said already in my previous reply above:

    “I had already used the re-create DB tool and all others found at same page and I did it again but doesn’t solve the issue.”

    Hello,

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

    Since the error messages you provided only involves missing tables, we might need to check this further over your admin settings. As instructed in the first reply, please edit the first post on this ticket and include your WordPress & FTP 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.

    CH1800
    Rank Math free

    Thanks Jeremy,

    As I get the same error at 8 websites, may I chose whichever one?

    Hello,

    Thank you for keeping in touch.

    Yes, any of your sites will do.

    Mind if I ask are all of your 8 websites in the same hosting service? Let me know so we can further investigate this issue.

    We are looking forward to helping you.

    CH1800
    Rank Math free

    No, they are roughly on 3-4 different servers.
    I’ll wait 1-2 days to get the error again and will get back to you with the credentials.

    Thanks!

    Hello,

    Thank you for following up.

    We really look forward to fixing this issue on your websites and will wait for your update.

    If you have any other concerns, please don’t hesitate to contact us by creating a new ticket to assist your further.

    Thank you.

    CH1800
    Rank Math free

    Hello,

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

    Thank you.

    CH1800
    Rank Math free

    Hi folks,

    I created a login for you at one of those 8 sites getting the same error.
    Please find mor info here under Sensitive Data.

    Kindly note that the re-create DB tool has already been used with no results so far.

    Many thanks for your help!

    Hello,

    Thank you for getting back to us.

    You seem to have connected analytics option in Rank math but not given the required permissions, check the screenshot I added in the sensitive section.

    Please make sure you have given the Rank Math App permission to read the Google Search Console data.

    From here: https://myaccount.google.com/permissions

    If not, please reconnect the Google Accounts, from your WordPress Dashboard > Rank Math > General Settings > Analytics
    reconnect analytics

    Once you have given reconnected your analytics, you can then head on and recreate tables as shown in my previous reply.

    Let us know if this helps. Looking forward to helping you.

    Thank you.

    CH1800
    Rank Math free

    Thanks Michael,

    That’s strange as I’ve already done this process for connecting with Google and don’t well understand why it was somehow reset.

    I’ve followed your instructions for all sites and I’ll keep an eye on this to see what happens.

    Will keep you posted, thanks again!

    Hello,

    Thank you for updating.

    If you have any questions aside from this topic, please don’t hesitate to contact us by creating a new ticket to assist you with anything else.

    Thank you, and looking forward to your update.

    CH1800
    Rank Math free

    Unfortunately, the issue still persists at all sites with same errors.

    I’ve done exactly what I was instructed and all sites are well connected with Google with no errors and DBs are all re-created but I still get the same DB errors…

    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 20 total)

The ticket ‘Lots of DB recurring errors’ is closed to new replies.