Database Error on Plugin Activation
-
Hi, I had to deactivate Wordfence and some other plugins on a site briefly this morning. When I reactivated, Wordfence threw this message:
WordPress database error Unknown storage engine ‘MyISAM’ for query CREATE TABLE IF NOT EXISTS
wp_wfls_role_counts#011#011#011#011(#012#011#011#011#011serialized_roles VARBINARY(255) NOT NULL,#012#011#011#011#011two_factor_inactive TINYINT(1) NOT NULL,#012#011#011#011#011user_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,#012#011#011#011#011PRIMARY KEY (serialized_roles, two_factor_inactive)#012#011#011#011#011) ENGINE=MyISAM; /* From [siteredacted.wpenginepowered.com/wp-admin/plugins.php?action=activate&plugin=wordfence%2Fwordfence.php&plugin_status=all&paged=1&s&_wpnonce=6ca23ad78d] in [(redacted)/wp-content/plugins/wordfence/modules/login-security/classes/controller/wordfencels.php:254] */ made by activate_plugin, plugin_sandbox_scrape, include_once(‘/plugins/wordfence/wordfence.php’), require_once(‘/plugins/wordfence/lib/wordfenceClass.php’), require(‘/plugins/wordfence/modules/login-security/wordfence-login-security.php’), WordfenceLS\Controller_WordfenceLS->init, WordfenceLS\Controller_WordfenceLS->_init_actions, WordfenceLS\Controller_WordfenceLS->_install, WordfenceLS\Controller_DB->install, WordfenceLS\Controller_DB->_create_schema, WordfenceLS\Controller_DB->create_table, WordfenceLS\Controller_DB->create_tableI retested the site, deactivating all plugins, switching the theme, clearing the cache, and just reactivating Wordfence. It continues throwing this message (expected since it seems to be a database issue, not a PHP issue)
The table wp_wfls_role_counts already exists.
This happened on both dev and staging environments on WP Engine (I can’t deactivate everything on prod except in the case of a WSOD). We are on WP 6.9.4, PHP 8.4, and Wordfence 8.1.4.
I did notice in phpMyAdmin: This MySQL server has been running for 7 days, 9 hours, 57 minutes and 7 seconds. It started up on Mar 27, 2026 at 06:07 AM. The site in question was migrated to its current location last fall and has been hosted by WP Engine in one location or another for more than four years. I deactivate all plugins regularly on dev or staging to troubleshoot or test potential new features. Today is the first time I have encountered this message.
You must be logged in to reply to this topic.