Website broke down after Update

#92669
  • Resolved SPEZ
    Rank Math pro

    Hi there!

    My website completely broke down after the Rank math update.
    The Database was flooded by entries from the plugin which make my provider warning me block my site. There was a problem in the wpgc_actionscheduler_logs. Any hint? I don’t dare to active the plugin again!

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

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

    We might need to take a closer look at the settings. Please edit the first post on this ticket and include your WP 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.

    SPEZ
    Rank Math pro

    Hi! Thanks for the quick reply!

    It works fine now. I already fixed it!

    But I wonder if there will be an update soon so I can keep using Rank Math.

    The wpgc_actionscheduler_logs table was constantly being populated (it had over 29 000 000 rows and is over 3 GB in size) and the database grew bigger and bigger until it broke down my site. The provider customer service told me to contact you to solve the problem with the ActionScheduler settings to avoid this.

    Bye,

    Henning

    Hello,

    This issue is caused by a third-party library included in Rank Math. We have contacted its authors and we’re working together to find a solution for this.

    In the meantime, you have the following options:

    Before doing any action, we recommend taking a backup of your database.

    A. Turn off the Analytics module in Rank Math. That should stop the records from getting added to the table. You can also empty (truncate) those actionscheduler tables to free up space.

    B. You can try our Repair Action Scheduler plugin that can fix this issue automatically on most sites: https://github.com/rankmath/_repair-action-scheduler On the Github page we linked, click on the green “Code” button and then on “Download ZIP”. Then upload that zip file to your site on this admin page: Plugins > Add New > Upload Plugin. Once you activate the plugin, it should do its thing and then deactivate itself automatically. Then you should be able to use Rank Math without any issue.
    download zip file from github

    Hope that helps. Thank you.

    SPEZ
    Rank Math pro

    Hi! Thanks! But may I ask if there will be any update for Rank Math soon that will fix this problem?

    Hello,

    This is a one-time process and it should be all good.

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

    Please follow these steps to fix the issue:

    1. Take a complete backup of your website

    2. Install this plugin: https://wordpress.org/plugins/code-snippets/

    3. Head over to the Snippets menu in the left sidebar and click Add New
    add new snippet

    4. Give that post any name and copy the below code in the Code field

    add_action( 'init', function() {
    	delete_option( 'schema-ActionScheduler_StoreSchema' );
    } );

    5. Select ‘Only run in administration area’ option and click the Save and Activate button
    run only in admin area wordpress

    6. Open WordPress Dashboard in a new window

    7. Then deactivate recently created snippet from here
    disable snippet

    8. Then activate the Rank Math plugin again

    9. Please disable the Code Snippets plugin if you are not going to use it

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

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

    That should resolve the issue. Thank you.

    SPEZ
    Rank Math pro

    Hi!

    Both options DIDN’t WORK and BROKE DOWN MY SITE AGAIN!!!!!

    Please don’t offer your plugin until you solved the problems that causes it.

    I lost my complete page now and I am trying to restore it now with the help of my hosting customer service. What a huge mess!

    PLEASE update your plugin ASAP or take it of the market!

    Hello,

    We are really sorry for the trouble you are facing.

    We might need to take a closer look at the settings. 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. Thank you.

    SPEZ
    Rank Math pro

    Thanks!

    My website hosting service could help me fortunately. I CANNOT use Rank math anymore as both options you told me didn’t work and just BROKE DOWN my whole sit TWICE! Please UPDATE your plugin ASAP!

    Hello,

    To assist you better, please add your WordPress & FTP login details in the sensitive data section.

    Looking forward to helping you. Thank you.

    SPEZ
    Rank Math pro

    Will there be an update soon? I would like to know what the problem is BEFORE I give my sensitive data to you. Especially the FTP login details. Can you EXPLAIN what the problem is and whether there will be a professional solution from RANK MATH themselves?

    Hello,

    Out of over 500,000 active installations of WordPress, only a handful of sites are facing this issue.

    This issue is caused by a third-party library included in Rank Math. We have contacted its authors and we’re working together to find a solution for this.

    Here are the tickets that we have opened with them:
    https://github.com/woocommerce/action-scheduler/issues/625#issuecomment-707326921
    and
    https://github.com/woocommerce/woocommerce/issues/27932

    If we apply the fix to everyone, that could have severe implications as not everyone is facing this issue.

    This is most likely caused by some of your older plugin that did not remove the Action Scheduler’s tables when removing/upgrading itself and now when the Rank Math plugin is trying to create new custom tables, the process is failing. It could also be because of a conflict with one of the plugins or the theme you are using.

    We do not want to bring your website down for even a minute and thus the FTP access is needed.

    Hope this helps. Please let us know how you would like to proceed.

    Looking forward to helping you. Thank you.

    SPEZ
    Rank Math pro

    Hello,

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

    Thank you.

    Hello,

    Please add the FTP details as well in case anything goes haywire, we could bring your website back again with no downtime.

    Looking forward to helping you. Thank you.

    SPEZ
    Rank Math pro

    Hello,

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

    Thank you.

    Hello,

    We have added the fix on your website.

    1. Please do not disable the Rank Math plugin.
    2. Remove Rank Math’s app from here:
    https://myaccount.google.com/permissions
    3. Reconnect Google’s app from inside Rank Math’s options panel.

    Please let us know if the DB size increases.

    Looking forward to helping you. 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 15 replies - 1 through 15 (of 23 total)

The ticket ‘Website broke down after Update’ is closed to new replies.