Hello,
We apologize for the inconvenience you’re facing with the missing wp_rank_math_analytics_ga table. It seems that the table keeps getting dropped despite your efforts to rebuild it.
To resolve this issue, please follow the steps outlined in our knowledgebase article on how to recreate missing database tables. You can find the article here: How to Recreate Database Tables in Rank Math.
If the issue persists after following these steps, please reply to this ticket, and a human agent from the Rank Math Support team will overtake the ticket and provide further assistance.
Thank you for bringing this to our attention, and we appreciate your patience as we work to resolve this issue.
Best regards.
Sources:
Resolving Rank Math Analytics Related Issues » Rank Math
How to Recreate Database Tables in Rank Math » Rank Math
What to Do When Rank Math Analytics Shows Zero Search Traffic » Rank Math
Rank Math Status and Tools » Rank Math
Fatal Error Happening on Some Installations After 1.0.49 Update » Rank Math
Clearly, my ticket hasn’t been read. I’ve already followed the instructions (per the old topic and the Knowledge base) repeatedly and the table keeps getting dropped.
Hello,
Thank you for your query, and we are so sorry about the trouble this must have caused.
Could you please check under Rank Math SEO > Status & Tools > System Status > Rank Math and confirm that you do not see Rank Math Analytics tables not created.
Please ask your host to go ahead and create the database datable manually.
Please share the following link with your host so they can create the SQL tables manually.
Analytics Table : https://pastebin.com/Z3umKurm
Analytics Objects : https://pastebin.com/HaL1hgkh
Once that is done please disconncet and reconnect Rank Math Analytics with all permissions.
Let us know how that goes.
Thank you.
Hi,
I was on leave and have just returned. What does “confirm that you do not see Rank Math Analytics tables not created.” mean? Are you asking me to confirm that there are no tables or that there are tables? Here is the output of the section you referred me to.
Free version 1.0.209
PRO version 3.0.52
Database version 1
Plugin subscription plan Pro
Content AI Plan
Content AI Credits 0
Content AI Refresh Date
Active modules link-counter, analytics, seo-analysis, sitemap, rich-snippet, woocommerce, content-ai, instant-indexing, role-manager, redirections, image-seo, local-seo
Google Refresh token Token exists
Google Permission
AdSense: Not Given
Analytics: Given
Search Console: Given
Database Table: 404 Log Not found
Database Table: Redirection 99 KB
Database Table: Redirection Cache 39 KB
Database Table: Internal Link 801 KB
Database Table: Internal Link Meta 97 KB
Database Table: Google Search Console 4 KB
Database Table: Flat Posts 248 KB
Database Table: Google Analytics Not found
Database Table: Google AdSense Not found
Database Table: Keyword Manager 2 KB
Database Table: Inspections 4 KB
I’ve looked over the SQL snippets you’ve created and I’ve used the relevant part to create the wp_rank_math_analytics_ga table AGAIN. I haven’t run the rest as the tables are present. However, I think your last snippet is incorrect, as you’ve called the table rm_rank_math_analytics_objects. Should it be wp? At any rate, the table already exists.
The only table that keeps getting dropped is the ga table.
I will let you know if it occurs again.
Hello,
The GA table is part of the PRO plugin, but you have created this ticket using a Free account. Please share the email address of your PRO account or the receipt you must have received from FastSpring, so we can verify your purchase and assist you further.
Looking 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.