rank_math_analytics_gsc doesn’t exist

#261777
  • Resolved Hua Gong

    4 years, 6 months ago

    Rank Math free

    Hi, there

    I encountered
    : [Table ‘mtcsys_co_nz.wp_pbc3gu_rank_math_analytics_gsc’ doesn’t exist]
    SELECT COUNT(DISTINCT(created)) AS days FROM wp_pbc3gu_rank_math_analytics_gsc LIMIT 0, 1

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

    after I installed RM and disabled yoast seo.

    I tried to follow https://support.rankmath.com/ticket/database-not-created/ but there is no database tools tab after I clicked advanced mode. There are more modules in advanced mode comparing with easy mode, but the db tools tab just didn’t show up.

    Thanks

Viewing 8 replies - 1 through 8 (of 8 total)
  • Anas

    4 years, 6 months ago

    Rank Math business

    Hello,

    Thank you for contacting Rank Math, and sorry for any 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.

    Hua Gong

    4 years, 6 months ago

    Rank Math free

    Thanks, Anas. To use the plugin it asks for email add. Which shall I key in?

    Jeremy

    4 years, 6 months ago

    Hello,

    You may use this email address s******@r*********** to create temporary access for us.

    Looking forward to helping you.

    Hua Gong

    4 years, 6 months ago

    Rank Math free

    Hello,

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

    Thank you.

    Hua Gong

    4 years, 6 months ago

    Rank Math free

    I have attached the link in sensitive data section.
    Thanks

    Jaideep Asrani

    4 years, 6 months ago

    Hello,

    I was able to access Database Tools inside WP Dashboard > Rank Math > Status & Tools. I recreated missing database tables from the database tools and the GSC table has been created:

    You shouldn’t get the error now. Please check and let us know if you need any other assistance.

    Thanks.

    Hua Gong

    4 years, 6 months ago

    Rank Math free

    Thanks. It is my fault that I haven’t look into the pic carefully. I thought it was in the dashboard

    Jaideep Asrani

    4 years, 6 months ago

    Hello,

    We are super happy that your issue is resolved. If you have any other questions in the future, know that we are here to help you.

    If you don’t mind me asking, could you please leave us a review (if you haven’t already) on https://wordpress.org/support/plugin/seo-by-rank-math/reviews/#new-post about your overall experience with Rank Math? We appreciate your time and patience.

    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.

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

The ticket ‘rank_math_analytics_gsc doesn’t exist’ is closed to new replies.