No analytics data at all

Hello i’ve found a lot of these errors in my error log

[16-Nov-2020 08:00:01 UTC] WordPress errore sul database Table 'tuttoit_blog.wp_rank_math_analytics_objects' doesn't exist per la query SHOW FULL COLUMNS FROMwp_rank_math_analytics_objects` fatta da do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array(‘rank_math/analytics/flat_posts’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Data_Fetcher->process_posts, RankMath\Analytics\Watcher->update_post_info, RankMath\Analytics\DB::update_object, RankMath\Analytics\DB::add_object, MyThemeShop\Database\Query_Builder->insert
[16-Nov-2020 08:00:01 UTC] WordPress errore sul database Table ‘tuttoit_blog.wp_rank_math_analytics_objects’ doesn’t exist per la query SHOW FULL COLUMNS FROM wp_rank_math_analytics_objects fatta da do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array(‘rank_math/analytics/flat_posts’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Data_Fetcher->process_posts, RankMath\Analytics\Watcher->update_post_info, RankMath\Analytics\DB::update_object, RankMath\Analytics\DB::add_object, MyThemeShop\Database\Query_Builder->insert
[16-Nov-2020 08:00:02 UTC] WordPress errore sul database Table ‘tuttoit_blog.wp_rank_math_analytics_gsc’ doesn’t exist per la query DELETE FROM wp_rank_math_analytics_gsc WHERE page NOT IN ( SELECT page from wp_rank_math_analytics_objects ) fatta da do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array(‘rank_math/analytics/clear_cache’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Data_Fetcher->clear_cache, RankMath\Analytics\Data_Fetcher->delete_all_useless
`

so there’s something wrong in my installation about analytics. Can you please tell me what’s happening?

thanks!

• This reply was modified 4 years, 1 month ago by Andrea Marucci.

Yes and no one here is answering unfortunately…

Ok problem solved. I’ve had to create manually these two tables, reconnect everything and now the analytics data are in finally!!!

It depends if the two tables rank_math_analytics_objects and rank_math_analytics_gsc are missed or not. in my case I’ve RM installed from the very start and probably due to a faulty upgrade the tables were not created so the analytics data are not stored.

I’ve created the two tables manually, reconnected RM to Google and the flow of data started.

Your’s could be another problem.

P.S. This is not the usual level of support I’m used to have from RM since I was left on my own with this problem and I’ve found a solution searching the KB and comparing the DB with another site that has analytics working.