Hello,
Thank you for contacting the support and we regret the inconvenience caused.
Please take a backup of your .htaccess file and replace it with the default WordPress .htaccess file. You can get the file contents here: https://wordpress.org/support/article/htaccess/
You can follow this guide to edit the .htaccess file:
https://rankmath.com/kb/edit-htaccess/
Once done, clear your website cache and run the SEO Analysis to see if the issue is fixed.
Please let us know how that goes.
Thank you.
Hi Prabhat,
Here is what colorways support has to say.
Yes, the configurations are correct but when I check the application error logs it shows errors are related to the missing database table.
Sun Jul 31 02:30:44.936375 2022] [proxy_fcgi:error] [pid 12002:tid 139961441449728] [client 76.66.148.41:23566] AH01071: Got error ‘PHP message: WordPress database error Table ‘ucaawtswhj.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(created)) AS days FROM wp_rank_math_analytics_gsc LIMIT 0, 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_2101->include_cmb, cmb2_bootstrap, do_action(‘cmb2_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\\Admin\\Options->register_option_page, include(‘/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php’), RankMath\\Analytics\\DB::info, MyThemeShop\\Database\\Query_Builder->getVar, MyThemeShop\\Database\\Query_Builder->onePHP message: WordPress database error Table ‘ucaawtswhj.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_gsc LIMIT 0, 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_2101->include_cmb, cmb2_bootstrap, do_action(‘cmb2_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\\Admin\\Options->register_option_page, include(‘/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php’), RankMath\\Analytics\\DB::info, MyThemeShop\\Database\\Query_Builder->getVar, MyThemeShop\\Database\\Query_Builder->one’, referer: https://thetechwriteup.com/wp-admin/admin.php?page=rank-math-status&view=tools
^C
Regards,
Anshul Nischal
Hello,
Can you please head over to your WordPress Dashboard > Rank Math > Status & Tools > Database Tools and click on the button “Re-Create Tables”? Rank Math should attempt to recreate the table. Observe if this resolves the issue.
If the issue persists, 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.
Okay, I have realised what is causing the issue. The issue is when cloudflare is enabled.
Worst part is that neither cloudflare nor rank math provide a way to fix this.
Can you help me fix this? May be tell me the WAF rules or if you want access to cloudflare and wp both, please let me know
Hello,
You can ask the support staff from Cloudflare to whitelist the below IP and user agent:
IP 134.90.148.114 and the user-agent RankMathChecker/2.0.0; https://rankmath.com.
This is the only route to allow Rank Math’s SEO Analysis to work.
If the issue persists, do let us know and we will further check this with our development team.
Looking forward to helping you.
Hi,
This is the rule that we created. And, still does not work.
https://ibb.co/DVcmGvf
Still no luck. Any suggestions after seeing the firewall rules?
Hello,
When our server tries to ping your website we get a server error response so this is something related to the current server configuration you have.
We recommend checking the server error log and check what sort of errors you see there after running the website through our external SEO Analyzer here: https://rankmath.com/tools/seo-analyzer/
Don’t hesitate to get in touch if you have any other questions.
Hi Miguel,
That is what I am saying exactly. Does Rank Math have any official Cloudflare Knowledge based article?
Did you even check the snip?
I do hesitate to talk to Rank Math at this point as I am 100% sure that it will be a common problem and Rank Math Engineers and technical support is overlooking it affecting so many users who might want to switch from SEO yoast to RANK MATH.
Cloudflare has communuity support. There is no way I would ever know the rules.
At least someone can check the snip and let me know if the rules I have added to security should work or no.
Also, does it take 6 hours to reply by Rank Math team?
Hello,
In the Free section, the replies can take up to 24 hours because our team has to provide priority support for users of the paid subscriptions.
Regarding the issue, the rules seem to be correct and you are whitelisting the correct values, but since the server is returning an invalid response some configuration on your own server is causing this issue.
We don’t have any information about the server error because that is saved in your server error log or access log.
Also, all the times we’ve seen this issue is because there is either a firewall issue or the server is actually blocking our request. The latter seem to be the current issue with your website.
Don’t hesitate to get in touch if you have any other questions.
Hi Miguel,
True it takes time because its a free account. Why? Because I just started to use SEO with Rank Math. I need some traffic to build up before I get a premium service. Make sense? So would anyone who has just started.
Second, true it must be the firewall. But as you see the firewall is bypassing your IP in this case. Does Rank Math realize if too many of the websites are passing through Cloudflare these days, they must have a KBA for Cloudflare users?
Or they must team up with Cloudflare to mitigate the issues to start with. I liked the Rank Math plugin, but what would I do of something that I can not utilize? I freelance on Fiverr and make websites. Would I recommend using clouudflare with Rank Math? I would never do that. Not because Rank Math is bad. It is absolutely wonderful. But, there are potential issues with your service being used on Cloudflare. The moment I turn off Cloudflare everything works well.
I have whitelisted the things and still does not work. It does not even show if the traffic on your IP is blocked.
What should I do in this case?
Hello,
Yes, in this case, please get in touch with Cloudflare since the SEO Analysis tool is not working when it is enabled on your site.
One of our users had this kind of problem where their DNSSEC records were not configured correctly, so please also check these ones on them too.
Let us know how this goes.
Thank you.
Hi Reinelle,
As you can see the rules are set properly.
Cloudflare has community support only.
Cloudflare adds DNSSec record automatically on its own.
https://developers.cloudflare.com/dns/additional-options/dnssec/
See, I understand what you mean to say. Your plugin is okay, but Cloudflare is blocking it.
I have set the rules but still blocking it.
You should have some guidelines.
I live in Canada. Customer service is everything in here. If you people cannot provide KBA’s for this won’t make a good service.
I need some help. You say this is blocked. I have bypassed the rules so you need to tell me if there is wrong.
You make a point about DNSSEC but it does not make sense at the same point as all we do is enable/disable DNSSEC. We do not add rule for it on Cloudflare
Hello,
Many users use our plugin with Cloudflare and some of them that faced this issue were able to resolve it after adding the rules to whitelist our IP and user agent. The rules that you have added in Cloudflare are correct. Since Cloudflare is still blocking the SEO Analysis, please get in touch with their support as they will be able to investigate this further and fix this.
Let us know how that goes. Looking forward to helping you.
Hi Jaideep,
Cloudflare had to say that they are not blocking it.
The rules are good too.
Do you have any suggestions?
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.
