Error with RankMath Table

#607809
  • Resolved Anonymous
    Rank Math free

    Hi,

    Pertaining to the website Studio188, we’re encountering this issue when we go into this particular page and select “Enable Visual Builder”

    WordPress database error Table ‘wp_studio188.Za4hlY_rank_math_redirections’ doesn’t exist for query SELECT * FROM Za4hlY_rank_math_redirections WHERE status = ‘active’ ORDER BY updated DESC /* From [www.studio188.com.au/ipswich-unearthed/?et_fb=1] in [/nas/content/live/studio188/wp-content/plugins/seo-by-rank-math/vendor/mythemeshop/wordpress-helpers/src/database/class-query-builder.php:87]

    Steps taken to troubleshoot:

    1. We’ve disabled all plugins
    2. We’ve increased the memory limit per instructions here

    It’s only affecting this template on the website – the other pages are fine

    https://www.studio188.com.au/ipswich-unearthed/

Viewing 14 replies - 1 through 14 (of 14 total)
  • Anonymous
    Rank Math free

    Additional two errors listed below when I attempt to ‘Enable Visual Editor’

    */ 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

    */ 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->get

    Hello,

    Thank you for contacting Rank Math support and we apologize for any trouble you are facing with our plugin. It seems like there is an issue with your database tables that is causing the error.

    Don’t worry, we have a simple solution for you. Just follow these steps:

    • Go to your WordPress Dashboard and click on Rank Math.
    • Then, click on Status & Tools and select the Database Tools tab.
    • You will see a button that says Recreate Missing Database Tables. Click on it and wait for the process to complete.
    • You may also need to enable the Advanced Mode in Rank Math to access some options. You can do this by clicking on the toggle switch at the top right corner of the Rank Math dashboard. For more details, you can check out our knowledge base articles on Rank Math Status and Tools and Advanced Mode.

    That’s it! This should fix the error and let you use the Visual Builder without any problem. Please let us know if it works for you or if you need any further help. We are always happy to assist you.

    Thank you for choosing Rank Math. Have a great day!

    Anonymous
    Rank Math free

    Hi Great,

    Unfortunately, that didn’t work. The page is still throwing an error
    https://www.studio188.com.au/ipswich-unearthed/?et_fb=1

    What’s the next steps – do you require an account to troubleshoot?

    Hello,

    Can you please try clearing your site, plugin, any server-level cache, or browser cache to see if that works for you?

    If that does not help either then, it would seem like a conflict with one of the plugins or the theme you are using.

    Assuming you are using the latest version of all the plugins and the themes (please update if not yet).

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

    Here is a video you can follow as well:

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

    If the issue persists, please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section.

    Please do take a complete backup of your website before sharing the information with us.
    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.

    We really look forward to helping you.

    Thank you.

    Anonymous
    Rank Math free

    Hello,

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

    Thank you.

    Hi again,

    We’re sorry to hear that you’re still having issues with the Visual Builder on your website. We understand how frustrating this can be and we appreciate your patience and cooperation with us.

    We checked your website and we noticed that the error you’re seeing when you try to enable the Visual Builder is this:

    This error is actually not related to the redirection table error or to Rank Math in general. It seems to be caused by some conflict or compatibility issue with the Visual Builder plugin itself. We tried temporarily deactivating Rank Math to see if it changes anything, but the error was still showing. Therefore, we’d suggest you try reaching out to the plugin developer for help with this. They may be able to provide you with a solution or a workaround.

    Regarding the redirection table error, you’re getting this error because your redirection database table was not created properly by Rank Math. This may happen due to some database permissions or configuration issues on your server. We tried creating the tables from our database tools in Rank Math > Status & Tools > Database Tools > Re-create Missing Database Tables but that didn’t work for some reason.

    To investigate this further, we’ll need FTP access to your website, so that we can check the database settings and files and see if we can fix the issue manually. Could you please edit the sensitive data section again and paste in your FTP login details?

    Thank you for choosing Rank Math and for trusting us with your site’s SEO. We hope to hear from you soon and get this sorted out for you.

    Anonymous
    Rank Math free

    Thanks, let me try and retrieve this information for you and I’ll revert back.

    Hello,

    That sounds good.

    We look forward to hearing back from you.

    Anonymous
    Rank Math free

    Hello,

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

    Thank you.

    Hi again,

    Thank you for your patience and cooperation while we investigated and fixed this.

    We’re happy to let you know that we’ve resolved the problem with the missing database table. We found out that the problem was coming from your wp-config.php file, which didn’t have the correct database charset setting. This setting tells WordPress how to create and manage your database tables.

    To fix this, we added this line to your wp-config.php file:

    /** Database charset to use in creating database tables. */
    define( 'DB_CHARSET', 'utf8' );
    /** The database collate type. Don't change this if in doubt. */
    define( 'DB_COLLATE', '' );

    This tells WordPress to use the UTF-8 encoding for your database tables, which is the most common and compatible encoding for WordPress sites.

    As you can see from the screenshot below, your redirection database table is now back and working properly. You shouldn’t see any more errors related to this.

    We hope this helps you and makes your site run smoothly. If you have any other questions or concerns, please feel free to reach out to us anytime. We’re always here to assist you.

    Thank you for choosing Rank Math!

    Anonymous
    Rank Math free

    Hello,

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

    Thank you.

    Anonymous
    Rank Math free

    Hi Great, thank you but unfortunately this caused quite a few errors on our site. Our /Whats-On section actually broke entirely, and the header text font was changed to black, so users weren’t able to easily access other parts of the site.

    I’ve also got a report at the moment of our internal staff being unable to edit pages, which I’m currently investigating myself – this occurred during the patch deployed you deployed a few days ago.

    We’ve also got another open ticket with you at the moment and confirmed that the break wasn’t a result of their intervention https://support.rankmath.com/ticket/whats-on-page-change-redirect/?view=all&unm=1422972

    To fix all of the above, we’ve had to rollback all the works done in the past few days, but we look to be operational again with the one caveat of users not being able to access / edit parts of our site.

    I’ve updated the ticket to include our UAT site, would you mind testing your patches there instead moving forward please? We still are experiencing the issues with /ipswich-unearthed, and other similar pages

    Thank you!

    Anonymous
    Rank Math free

    Hi Great,

    Just to elaborate further on the problem we’re currently experiencing since the above bugfix was applied:

    Previously, we were able to just Enable Visual Builder then make changes across the site.

    After the fix, the positioning of the Divi Blocks have changed so it’s now more difficult to make live edits on the site. Difficult to explain until you actually Enable Visual Builder yourself and try it on the site (try on this URL highlighting the Tickets heading – it doesn’t easily allow you to do so)
    https://www.studio188.com.au/show/flip-the-switch-studio-188-2/?et_fb=1

    Hello,

    We have heard back from our developer and the affected page seems to throw script errors we are confident this is coming from the custom theme you are using. Please see the screenshot below:

    Rank Math support

    If you switch to the basic Divi theme, the issue is resolved. Please ensure that all the coding done to your theme is up to date that will not cause some issues with other plugins.

    Don’t hesitate to get in touch with us if you have any other questions.

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

The ticket ‘Error with RankMath Table’ is closed to new replies.