Advanced Issue: Plugin Failing to Create/Delete/Repair Database Tables

Hello,

We apologize for the issue you are facing with the Rank Math plugin on your new website. Thank you for providing such detailed information about the troubleshooting steps you’ve already taken.

Given that the "Re-create Database Tables" tool is failing silently and that you’ve ruled out common causes, it seems like there may be a deeper issue at play with how the plugin interacts with your server environment. Here are a few suggestions to consider:

1. Check PHP Version: Ensure that your server is running a compatible version of PHP. Rank Math recommends using PHP 7.2 or higher for optimal performance.

2. Error Logs: Check your server’s error logs for any PHP errors or warnings that might provide more insight into why the database operations are failing. This can sometimes reveal issues that aren’t immediately visible in the WordPress dashboard.

3. Database Collation: Ensure that your database tables are using the correct collation. Sometimes, mismatched collations can cause issues with database operations.

4. Custom Server Configurations: If you have any custom server configurations (like specific PHP settings), they might be interfering with the plugin’s ability to execute its database scripts. It might be worth discussing this with your hosting provider.

5. Manual Database Repair: As a last resort, you could try manually adding the missing rank_math_options_local_seo row to your wp_options table if you have access to do so. However, this is not a long-term solution and should be approached with caution.

If these suggestions do not resolve the issue, we recommend replying to this ticket so that a human agent from our support team can take over and provide more specialized assistance. Please include any relevant error log details or additional context that may help us diagnose the problem further.

Thank you for your patience, and we look forward to helping you resolve this issue!

Hello,

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

In this case, 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.

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,

WP login link does not working, so we can’t fully debug the issue.

Please check on your end and let us know how it goes.

We really look forward to hearing back from you. Thank you.

Hello,

We sincerely apologize for the delay in our response.

Please note that there is no row named rank_math_options_local_seo in the wp_options table. Could you kindly confirm where you found this entry?

The warnings appear to have originated from the data added in the Local SEO settings, which may not have been saved properly. We have saved the data again, and we are no longer seeing these warnings in your error log.

If the warnings reappear, please share your FTP login in the sensitive data section so that we can investigate the issue further.

Please let us know how it goes. We are here to assist you.

Thank you for your patience and cooperation.