Error messages - Support

Resolved passwriteofficial
5 years ago

Rank Math free

WordPress database error: [Table ‘u478522117_uWckl.wp_rank_math_analytics_gsc’ doesn’t exist]
SELECT COUNT(DISTINCT(created)) AS days FROM wp_rank_math_analytics_gsc LIMIT 0, 1

WordPress database error: [Table ‘u478522117_uWckl.wp_rank_math_analytics_gsc’ doesn’t exist]
SELECT COUNT(id) FROM wp_rank_math_analytics_gsc LIMIT 0, 1

WordPress database error: [Table ‘u478522117_uWckl.wp_rank_math_analytics_ga’ doesn’t exist]
SELECT COUNT(id) FROM wp_rank_math_analytics_ga LIMIT 0, 1

I am getting the above error message even after deleting and reinstalling.

Viewing 5 replies - 1 through 5 (of 5 total)

Jeremy
5 years ago

Hello,

Thank you for contacting the support, and sorry for any inconvenience that might have been caused due to that.

From the error, it seems your site is missing some required tables. Could you please recreate tables by following 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 clicking WP Dashboard > Rank Math > Status & Tools > Database Tools and click the Re-create database Table button.

Please let us know if that helps.

passwriteofficial
5 years ago

Rank Math free

Hi,

I’m still getting this one

WordPress database error: [Table ‘u478522117_uWckl.wp_rank_math_analytics_ga’ doesn’t exist]
SELECT COUNT(id) FROM wp_rank_math_analytics_ga LIMIT 0, 1

Jeremy
5 years ago

Hello,

Please verify if you have given the Rank Math App permission to read the Google Search Console data.

From here: https://myaccount.google.com/permissions

If not, please reconnect the Google Accounts, from your WordPress Dashboard > Rank Math > General Settings > Analytics

After that, re-create the tables and see if the issue goes away.

If the issue persists, we might need to check this one over your admin 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/

We really look forward to helping you.

passwriteofficial
5 years ago

Rank Math free

Hi, thanks it still doesn’t work. I will use Yoast until the issue is resolved thanks.

Jeremy
5 years ago

Hello,

Thank you for keeping in touch.

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/

We really look forward to helping you.

RankBot
4 years, 11 months ago

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

The ticket ‘Error messages’ is closed to new replies.