DB table wp_rank_math_analytics_gsc doesn’t exist

#292835
  • Resolved Branislav Vuinović

    3 years, 2 months ago

    Rank Math business

    Hi there,

    I am getting an error on my website.

    'directagrar_wp05e2e8bb67d1da62556c08d31af503a5.wp_rank_math_analytics_gsc' doesn't exist]
    SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2021-10-11 00:00:00' AND '2021-11-13 23:59:59' LIMIT 0, 1

    Greška Vordpresove baze podataka: [Table 'directagrar_wp05e2e8bb67d1da62556c08d31af503a5.wp_rank_math_analytics_gsc' doesn't exist]
    SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2021-09-07 00:00:00' AND '2021-10-10 23:59:59' LIMIT 0, 1

    Notice: Undefined property: stdClass::$position in /home/directagrar/www/www/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 74

    Notice: Undefined property: stdClass::$position in /home/directagrar/www/www/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 75

    Notice: Undefined property: stdClass::$position in /home/directagrar/www/www/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 76

    Notice: Undefined property: stdClass::$position in /home/directagrar/www/www/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 76
    Greška Vordpresove baze podataka: [Table 'directagrar_wp05e2e8bb67d1da62556c08d31af503a5.wp_rank_math_analytics_gsc' doesn't exist]
    SELECT COUNT(DISTINCT(query)) FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2021-10-11 00:00:00' AND '2021-11-13 23:59:59' GROUP BY Date(created) ORDER BY Date(created) DESC LIMIT 1

    Greška Vordpresove baze podataka: [Table 'directagrar_wp05e2e8bb67d1da62556c08d31af503a5.wp_rank_math_analytics_gsc' doesn't exist]
    SELECT COUNT(DISTINCT(query)) FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2021-09-07 00:00:00' AND '2021-10-10 23:59:59' GROUP BY Date(created) ORDER BY Date(created) DESC LIMIT 1

    It is happening only when I try to login to the wp-admin, and iside it. The website is not online yet, but I am afraid that the visitors/customers will have the same issue…

    I have tryed to solve the issue like described here:
    https://support.rankmath.com/ticket/errors-in-the-logs-of-my-site/
    but without success.

    Also, I have deleted plugin unlink with the Google, and reinstal it but nothing again…

    Can you please help me with this?

    Regards,
    Branislav

Viewing 7 replies - 1 through 7 (of 7 total)
  • Prabhat

    3 years, 2 months ago

    Rank Math agency

    Hello,

    Thank you for contacting us and we regret the inconvenience caused.

    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.
    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.

    Branislav Vuinović

    3 years, 2 months ago

    Rank Math business

    Hello,

    I have updated the sensitive data as requested. Can you please check further?

    Thank you.

    Reinelle

    3 years, 2 months ago

    Hello,

    The username and password for the site are working. However, the /wp-admin keeps on loading upon checking (not accessible for about 10 minutes).

    Could you please check?

    Looking forward to helping you.

    Thank you.

    Branislav Vuinović

    3 years, 2 months ago

    Rank Math business

    Hi there,

    I have just tryed to access wp-admin with the credentials I gave you and everything is working fine.

    Did you enetered .htpassword usr/pwd as I write you earlier?
    .htpasswd: branja/prle09

    Delete all cookies and webdata for directagrar.com website in your browser and try to login again.

    Regards,
    Brane

    Prabhat

    3 years, 2 months ago

    Rank Math agency

    Hello,

    I was able to login into your website’s admin area and replicate the errors.

    Upon investigating, I found that the wp_rank_math_analytics_gsc table was still missing and the website was blocking the “Re-create Missing Database Tables” to create the tables.

    So, I’ve manually recreated the table on your website and the issue is now fixed. The errors are no longer shown. Please check the website and confirm it on your end.

    I’ve also initiated a fresh data fetch.

    Looking forward to hearing back from you.

    Thank you.

    Branislav Vuinović

    3 years, 2 months ago

    Rank Math business

    Thank you very much for your help.
    I don’t see an error any more.

    Regards,
    Brane

    Prabhat

    3 years, 2 months ago

    Rank Math agency

    Hello,

    We’re glad that we could address the concern.

    Please feel free to get in touch if you require any further assistance.

    Thank you.

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

The ticket ‘DB table wp_rank_math_analytics_gsc doesn’t exist’ is closed to new replies.