Hello,
Thank you for contacting Rank Math and sorry for any inconvenience that might have been caused due to that.
By the error details you provided, it looks like the plugin didn’t install properly on your site. Please try adding a Redirection rule and see if it works. If that is also not working then probably something is wrong with the table. In that case, please take a backup of your site and delete the rank_math_redirection & rank_math_redirection_cache tables. After deleting the tables, deactivate the Rank Math plugin and activate it again. That should fix the issue.
If this doesn’t help, then we might need to take a closer look at the settings. Please edit the first post on this ticket and include your WP logins & cPanel access in the designated 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.
Hi,
Thanks for your reply. I checked and I could not find rank_math_redirection & rank_math_redirection_cache tables. They are not there!
I deleted the plugin, deleted the wp_rankmath tables and tried to reinstall. But still the problem isn’t solved.
Hello,
Please edit the first post on this ticket and include your WP logins & cPanel access in the designated Sensitive Data section so we can investigate this further.
Looking forward to helping you. Thank you.
​​​​​​
Hello,
I have updated the sensitive data as requested. Can you please check further?
Thank you.
I added the below code in the function.php before deleting the plugin.
/**
* Filter to remove Rank Math data from the database
*/
add_filter( 'rank_math_clear_data_on_uninstall', '__return_true' );
Then, I cleared the cache, cleaned the DB, restarted the server as well.
The NGINX access error was not present.
Then I installed RankMath.
The error came back in the NGINX access log.
I checked the DB. I can see that the wp_rank_math_redirection and wp_rank_math_redirection_cache tables were not present.
Then, I tried to add a redirection rule. I was NOT successfull.
I can see that similar problem has been addressed in this link: https://support.rankmath.com/ticket/cant-add-redirections/
Can you help without the access?
Problem Solved – Redirection was not working in Rank Math and access log showed error in every page load.
I found that when I was installing Rank Math, the database CHARSET was latin1_swedish_ci.
I figured out CHARSET was a problem.
I took backup of RankMath settings and then added the following code in the functions.php (to delete every reference to Rank Math in the database) and then uninstalled Rank Math:
/**
* Filter to remove Rank Math data from the database
*/
add_filter( 'rank_math_clear_data_on_uninstall', '__return_true' );
Then I edited the functions.php file again and removed the above code.
After that, I took a back up of my Theme options. (THIS IS VERY IMPORTANT)
Then in the wp-config file, I added the below code:
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', 'utf8_general_ci');
After this, I installed Rank Math.
I removed the added code in wp-config file.
The plugin is now installed properly. I can see that the Collate is now utf8_general_ci and the tables wp_rank_math_redirection and wp_rank_math_redirection_cache are now present! Redirection settings also working fine. There was no error in the access log.
All good, but in the frontend, I can see that the theme options are all deleted. The logo, font settings all deleted.
Now, in the theme options, the backup was imported.
All done.
PS: It seems Rank Math has a problem with old installations of wordpress, where Charset was not UTF8. Developers can get this corrected.
Hello,
Thank you for the detailed report on the issue.
I’ll forward this to our dev team to look further into it.
If you have any further question(s), please let us know. Thank you.
Thank you!
Closing the ticket.
Hi,
If you do have another question in the future, please feel free to create a new forum topic, and it will be our pleasure to assist you again.
Thank you.
