Critical Error: Missing Table wpeq_rank_math_analytics_objects

[ad_1]

Hello Rank Math Support Team,

I am experiencing a critical issue with the Rank Math Analytics plugin on my WordPress site. The error message indicates that the table wpeq_rank_math_analytics_objects does not exist. Here are the details of the error and the steps I have taken so far:

Error Message:

[07-Jun-2024 07:17:15 UTC] WordPress database error Table 'wajrquruej.wpeq_rank_math_analytics_objects' doesn't exist for query SELECT * FROM wpeq_rank_math_analytics_objects WHERE object_id = '20582' 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\Analytics\Rest->get_post, RankMath\Analytics\Posts->get_post, RankMath\Admin\Database\Query_Builder->one

Steps Taken:

  1. Checked for the Existence of the Table:
    * I logged into my database via phpMyAdmin and confirmed that the table wpeq_rank_math_analytics_objects does not exist.
  2. Reinstalled Rank Math Plugin:
    * Deactivated and deleted the Rank Math plugin.
    * Reinstalled and activated the plugin.
    * The error persisted.
  3. Attempted Manual Table Creation:
    * Based on typical table structures for analytics plugins, I attempted to create the table manually using the following SQL query:
CREATE TABLE wpeq_rank_math_analytics_objects (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
object_id bigint(20) UNSIGNED NOT NULL,
type varchar(20) NOT NULL,
created datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY object_id (object_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  • However, I am unsure if this schema is correct for Rank Math.
  • Ran Database Repair:
    * Added define(‘WP_ALLOW_REPAIR’, true); to wp-config.php.
    * Ran the repair and optimization from http://my-site.com/wp-admin/maint/repair.php.
    * Removed the repair line from wp-config.php.
  • Debugging Enabled:
    * Enabled debugging in wp-config.php to gather more information
define('WP_DEBUG', true);
define('WP_DEBUG_LOG', true);
define('WP_DEBUG_DISPLAY', false);
  • Additional Information:
    WordPress Version: 6.5.5
    Rank Math Version: 1.0.222
    PHP Version: 8.2
    Database Management Tool: phpMyAdmin
    Hosting Provider: Cloudways
  • Despite these steps, the error persists. I suspect the issue lies with the missing table schema or a conflict during plugin installation.

Could you please provide guidance on how to correctly create the missing wpeq_rank_math_analytics_objects table or any other steps to resolve this issue?

Thank you for your assistance.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer