Hello,
Thank you for contacting the support, and sorry for any inconvenience that might have been caused due to that.
I noticed a database table is missing thus creating this error message. Please follow these steps:
1. Update to the latest version of Rank Math Free & PRO
2. Ensure that the Advanced Mode is selected:
3. Re-create tables by going to Rank Math > Status & Tools > Database Tools > Re-create Missing Database Tables >and click the Re-create database Table button.
https://i.rankmath.com/HnHLC2
Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.
Hi,
thank you for your reply. We did and repeated the suggested re-create database table steps. Yet, we are still getting PHP errors. The relevant, non-sensitive part of it:
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_270->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, RankMath\\Analytics\\DB::get_total_rows, MyThemeShop\\Database\\Query_Builder->getVar
Hello,
Thank you for following up.
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.
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/
Thank you, and we really look forward to helping you.
Hi, could you please provide your IP in the sensitive data section you will be accessing FTP, so we can whitelist it.
Hello,
Thank you for following up and sorry for the delay.
Unfortunately, we have dynamic IPs. Even if you whitelist our IP – our IP might have changed by the time we check your ticket.
If possible, please turn off security measures temporarily to further investigate this issue. Our Designated Sensitive Data section is completely secure and only our support staff has access to that section.
Thank you, and looking forward to helping you.
Thank you for getting back to us.
We would like to give in input on the use of dynamic IP’s for support accessing the client’s site through FTP. This eventually could stir us away from using RM due to security reasons.
For the time being, if we decide to open the sites for dynamic IP is it sufficient to provide access to the Rankmath folder only?
Hello,
As my colleague has noted most of us have dynamic IPs so once you have disabled your security measures temporarily we will be able to help you further
We’d recommend to provide us with admin-level access so we can fully investigate your issue.
Looking forward to helping you. Thank you.
Hi,
Would this option with admin-level access be sufficient? https://wordpress.org/plugins/wp-file-manager/
Hello,
Thank you for following up.
That plugin should work just fine. Could you please try updating Rank Math to the latest version to see if this issue would be fixed?
If that still didn’t help, please add access in the designated Sensitive Data section to further investigate.
I hope that helps. Thank you, and looking forward to your update.
Hello,
I have updated the sensitive data as requested. Can you please check further?
Thank you.
Hello,
I checked your site and the table shown in the error is actually missing yet you have connected your analytics.
Would you mind sharing access to your cPanel or phpMyadmin panel so we can try and add the tables for you?
Looking forward to helping you.
Hi Michael,
Thank you for your reply. Could you please specify the tables that need to be created?
On one of our sites, we had the PHP error we created the wp_rank_math_analytics_ga table and since then have not seen an error. That is good news.
On the other hand, we have noticed that these errors appearing when the Analytics is enabled, in the settings Googles Services are not connected, yet there is a green dot next to the Analytics side menu. In other cases when the dot is red, we do not see the error even without the table.
Could you please clarify the discrepancy in green/red dots appearing while the Connect Google Service still animated?
Hello,
Just to be clear, were you able to recreate the tables for the site having this issues?
If the dot is showing green, it means Rank math is reading the Google account as connected in which case the analytics tables, which if missing will show the errors you are facing, are used and should be created.
If the dot is showing red, it simply shows that you have not connected your Google account to Rank math. If you don’t wish to use this module, I recommend disabling it in Rank math dashboard.
Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.
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.
