Analytics error – database error 1146 table doesn’t exist

#104102
  • Resolved Nikvkon
    Rank Math free

    Good afternoon
    All the methods You provided to solve the problem in support did not help

Viewing 1 replies (of 1 total)
  • Hello,

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

    Please follow these steps:

    If you are not seeing any data inside your Analytics module, this guide might help you.

    <h2>A. Pre-check List</h2>
    1. You should not be using Google Analytics v4 or Matomo Analytics.

    2. Update to the latest version of Rank Math Free & PRO

    3. Ensure that you are logged in to your paid account:
    rank math member area

    4. Disconnect and reconnect your account from inside WordPress:
    reconnect rank math account

    <h2>B. Refresh Tokens</h2>
    1. Please delete RankMath’s app from here:
    https://myaccount.google.com/permissions
    remove rank math app

    2. Re-create tables by clicking WP Dashboard > Rank Math > Status & Tools > Database Tools and click the Re-create database Table button.
    re-create analytics tables

    3. Reconnect the account inside Rank Math by clicking here and ensure that you approve all the permission notices that shows up:
    WP Dashboard >> Rank Math >> General Settings >> Analytics tab, and click the Reconnect link
    reconnect analytics

    4. Let the process complete and it might take around 30 minutes.

    5. Now head over to WP Dashboard > Rank Math > Status & Tools > Database Tools and click the Rebuild Index for Analytics button.
    Rebuild Index for Analytics

    6. Please check if the data shows up here:
    /wp-admin/admin.php?page=rank-math-analytics#/
    analytics data

    If that does not help, please paste the data from here:
    WP Dashboard > Rank Math > Status & Tools > Database Tools and click the Rebuild Index for Analytics button
    system info

    We really look forward to helping you.

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

The ticket ‘Analytics error – database error 1146 table doesn’t exist’ is closed to new replies.