Unable to connect to SEARCH CONSOLE - Support

Resolved Anonymous
2 months, 1 week ago

Rank Math free

Hi there, i am getting the below error, are you guys able to help?

[16-Feb-2024 03:50:29 UTC] Cron reschedule event error for hook: litespeed_task_imgoptm_pull, Error code: invalid_schedule, Error message: Event schedule does not exist., Data: {“schedule”:”litespeed_filter”,”args”:[],”interval”:60}
[16-Feb-2024 03:50:29 UTC] Cron reschedule event error for hook: litespeed_task_lqip, Error code: invalid_schedule, Error message: Event schedule does not exist., Data: {“schedule”:”litespeed_filter”,”args”:[],”interval”:60}
[22-Feb-2024 13:21:21 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:22:34 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:23:39 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:24:06 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:24:56 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:25:17 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2024-01-17 00:00:00’ AND ‘2024-02-19 23:59:59’ LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:25:17 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN ‘2023-12-14 00:00:00’ AND ‘2024-01-16 23:59:59’ LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:25:17 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(query))
FROM wp_rank_math_analytics_gsc
WHERE created BETWEEN ‘2024-01-17 00:00:00’ AND ‘2024-02-19 23:59:59’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Analytics\Summary->get_keywords_summary
[22-Feb-2024 13:25:17 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(query))
FROM wp_rank_math_analytics_gsc
WHERE created BETWEEN ‘2023-12-14 00:00:00’ AND ‘2024-01-16 23:59:59’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Analytics\Summary->get_keywords_summary
[22-Feb-2024 13:27:48 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:28:05 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:37:38 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:41:20 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 13:44:45 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one
[22-Feb-2024 14:07:54 UTC] WordPress database error Table ‘u725750003_SupyH.wp_rank_math_analytics_objects’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_objects LIMIT 0, 1 made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Workflow\OAuth->reconnect_google, RankMath\Admin\Database\Query_Builder->getVar, RankMath\Admin\Database\Query_Builder->one

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

Adetayo
2 months, 1 week ago

Hello,

Thank you for your query and we are so sorry about the trouble this must have caused.

The error seems to point to missing database tables. For your initial troubleshooting, please head over to your WordPress Dashboard > Rank Math > Status & Tools > Database tools and click on the button “Re-create Tables”.

You may also refer to this guide as well: https://rankmath.com/kb/recreate-missing-database-tables/

Then check under Rank Math SEO > Status & Tools > System Status > Rank Math and confirm that you see the Rank Math Analytics tables have been created as shown in the image below:

If it has not been created you can use the following SQL queries to create the table manually:

Analytics Table: https://pastebin.com/Z3umKurm

Analytics Objects: https://pastebin.com/HaL1hgkh

If you can’t do this yourself share the following link with your host so they can create the SQL tables manually for you.

Once done, please disconnect and reconnect Rank Math Analytics to Google and grant all permissions.

Let us know how that goes.

Thank you.

Anonymous
2 months, 1 week ago

Rank Math free

Hi there, i am still unable to see my website on the search console in order to select it. Below is the SYSTEM INFO i copied from the STATUS AND TOOL

### rank-math ###

version: 1.0.213
database_version: 1
plugin_plan: Free
0: Free
1: 750
2: 2024-03-22 1:14 pm
active_modules: link-counter, analytics, seo-analysis, sitemap, rich-snippet, content-ai, instant-indexing, redirections
refresh_token: Token exists
permissions:
Search Console: Given
rank_math_404_logs: 32 KB
rank_math_redirections: 32 KB
rank_math_redirections_cache: 32 KB
rank_math_internal_links: 32 KB
rank_math_internal_meta: 16 KB
rank_math_analytics_gsc: 80 KB
rank_math_analytics_objects: 32 KB
rank_math_analytics_inspections: 128 KB

### wp-core ###

version: 6.4.3
site_language: en_GB
user_language: en_GB
timezone: Europe/London
permalink: /%postname%
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: undefined
environment_type: production
user_count: 1
dotorg_communication: true

### wp-dropins (1) ###

object-cache.php: true

### wp-active-theme ###

name: OceanWP (oceanwp)
version: 3.5.3
author: OceanWP
author_website: https://oceanwp.org/about-oceanwp/
parent_theme: none
theme_features: core-block-patterns, widgets-block-editor, align-wide, wp-block-styles, responsive-embeds, editor-styles, editor-style, menus, post-formats, title-tag, automatic-feed-links, post-thumbnails, custom-header, custom-logo, html5, woocommerce, wc-product-gallery-zoom, wc-product-gallery-lightbox, wc-product-gallery-slider, customize-selective-refresh-widgets, widgets
theme_path: /home/u725750003/domains/breezereviews.com/public_html/wp-content/themes/oceanwp
auto_update: Enabled

### wp-mu-plugins (1) ###

Affiliate Plugin: author: (undefined), version: 1.0.3

### wp-plugins-active (10) ###

Duplicate Page: version: 4.5.3, author: mndpsingh287, Auto-updates enabled
Elementor: version: 3.19.2, author: Elementor.com, Auto-updates enabled
LiteSpeed Cache: version: 6.1, author: LiteSpeed Technologies, Auto-updates enabled
Ocean Extra: version: 2.2.5, author: OceanWP, Auto-updates enabled
Qi Addons For Elementor: version: 1.6.7, author: Qode Interactive, Auto-updates enabled
Rank Math SEO: version: 1.0.213, author: Rank Math, Auto-updates enabled
The Post Grid: version: 7.4.2, author: RadiusTheme, Auto-updates enabled
Wordfence Security: version: 7.11.3, author: Wordfence, Auto-updates enabled
WordPress Importer: version: 0.8.2, author: wordpressdotorg, Auto-updates enabled
WPForms Lite: version: 1.8.6.4, author: WPForms, Auto-updates enabled

### wp-server ###

server_architecture: Linux 4.18.0-513.11.1.lve.el8.x86_64 x86_64
httpd_software: LiteSpeed
php_version: 8.1.27 64bit
php_sapi: litespeed
max_input_variables: 5000
time_limit: 360
memory_limit: 1536M
max_input_time: 360
upload_max_filesize: 1536M
php_post_max_size: 1536M
curl_version: 7.87.0 OpenSSL/1.1.1w
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: true
current: 2024-02-23T16:21:31+00:00
utc-time: Friday, 23-Feb-24 16:21:31 UTC
server-time: 2024-02-23T16:21:31+00:00

### wp-database ###

extension: mysqli
server_version: 10.11.6-MariaDB-cll-lve
client_version: mysqlnd 8.1.27
max_allowed_packet: 1073741824
max_connections: 2000

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /home/u725750003/domains/breezereviews.com/public_html/wp-content
WP_PLUGIN_DIR: /home/u725750003/domains/breezereviews.com/public_html/wp-content/plugins
WP_MEMORY_LIMIT: 40M
WP_MAX_MEMORY_LIMIT: 1536M
WP_DEBUG: false
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: true
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Undefined
WP_DEVELOPMENT_MODE: undefined
DB_CHARSET: utf8
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

`

Adetayo
2 months, 1 week ago

Hello,

From the SYSTEM INFO you shared, we can see that the following tables are still missing:
rank_math_analytics_ga, rank_math_analytics_adsense and rank_math_analytics_keyword_manager.

Please ensure you have followed the steps above here so that the tables can be created, then try connecting to Google Console and Analytics by following this guide: https://rankmath.com/kb/analytics-issues/#expired-google-oauth-token

We hope this resolves the issue for you.

If you still face any problems or have any questions, please let us know. We’re always here to help.

Thank you.

RankBot
1 month, 1 week ago

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

The ticket ‘Unable to connect to SEARCH CONSOLE’ is closed to new replies.