Skip to content

Fresh Dashboard install logs DB errors on activation: wp_mainwp_wp / wp_mainwp_api_keys tables not found #827

@bkatusic

Description

@bkatusic

Description of Issue:

On a fresh WordPress install, activating MainWP Dashboard v5.4.0.20 on PHP 8.4.x generates 1-time database errors in the WordPress debug log. The errors report missing MainWP tables during activation:

Table '...wp_mainwp_wp' doesn't exist (called from MainWP_DB->get_websites_count via MainWP_Logger->get_log_status)
Table '...wp_mainwp_api_keys' doesn't exist (called from MainWP_DB->is_existed_enabled_rest_key during REST API checks)

Steps to Reproduce:

  1. Create a fresh WordPress site.
  2. Install and activate MainWP Dashboard 5.4.0.20.
  3. Check the WordPress debug log (WP_DEBUG_LOG enabled) immediately after activation.
  4. Observe entries similar to:

Table 'local.wp_mainwp_api_keys' doesn't exist for query SELECT * FROM wp_mainwp_api_keys WHERE enabled = 1 LIMIT 1 made by activate_plugin, plugin_sandbox_scrape, include_once('/plugins/mainwp/mainwp.php'), MainWP\Dashboard\MainWP_System->__construct, MainWP\Dashboard\MainWP_Includes->includes, require_once('/plugins/mainwp/includes/class-mainwp-setup.php'), MainWP_Setup::instance, MainWP_Setup->__construct, MainWP_Setup->includes, include_once('/plugins/mainwp/includes/rest-api/controller/version1/class-mainwp-rest-api-v1.php'), MainWP\Dashboard\Rest_Api_V1->init, MainWP\Dashboard\Rest_Api_V1->is_rest_api_enabled, MainWP\Dashboard\Rest_Api_V1->enabled_rest_v2_api, MainWP\Dashboard\MainWP_DB->is_existed_enabled_rest_key

Table 'local.wp_mainwp_wp' doesn't exist for query SELECT COUNT(wp.id) FROM wp_mainwp_wp wp WHERE 1 AND wp.is_staging = 0 made by activate_plugin, plugin_sandbox_scrape, include_once('/plugins/mainwp/mainwp.php'), MainWP\Dashboard\MainWP_System->__construct, MainWP\Dashboard\MainWP_Execution_Helper->init_exec_time, MainWP\Dashboard\MainWP_Logger::instance, MainWP\Dashboard\MainWP_Logger->__construct, MainWP\Dashboard\MainWP_Logger->get_log_status, MainWP\Dashboard\MainWP_DB->get_websites_count

Note

If you have a similar issue but the steps to reproduce are different, please open a help ticket for us to review and verify if it's a new issue or part of this one. Thanks!

Reported on: 2025-08-22
Issue confirmed with dev team: 2025-08-22
Resolved: Pending

Metadata

Metadata

Assignees

No one assigned

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions