Errors on 7.10.5

  • Resolved kkow

    (@kkow)


    1 year, 1 month ago

    Updating to 7.10.5 gives errors and won’t let users log-in that had 2FA set up. It seemed to think they did not have it set up and trying to reset the 2FA status also provided an error. Downgrading the plugin immediately resolved the issues. Here are the errors I was getting:

    */ made by require_once('wp-admin/admin.php'), do_action('wordfence_page_WFLS'), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_menu, WordfenceLS\Model_View->render, include('/plugins/wordfence/modules/login-security/views/page/page.php'), WordfenceLS\Model_View->__toString, WordfenceLS\Model_View->render, include('/plugins/wordfence/modules/login-security/views/page/settings.php'), WordfenceLS\Controller_Users->get_detailed_user_counts_if_enabled, WordfenceLS\Controller_Users->detailed_user_counts, WordfenceLS\Controller_DB->create_temporary_role_counts_table, WordfenceLS\Controller_DB->create_temporary_table, WordfenceLS\Controller_DB->create_table, WordfenceLS\Controller_DB->create_table
    */ made by do_action('wp_ajax_wordfence_ls_reset_2fa_grace_period'), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_AJAX->_ajax_handler, call_user_func, WordfenceLS\Controller_AJAX->_ajax_reset_2fa_grace_period_callback, WordfenceLS\Controller_Users->reset_2fa_grace_period, WordfenceLS\Controller_Users->can_activate_2fa, WordfenceLS\Controller_Permissions->does_user_have_multisite_capability, WordfenceLS\Controller_Permissions->get_multisite_roles, WordfenceLS\Controller_Permissions->_load_multisite_roles

    Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter kkow

    (@kkow)

    I just tried testing this update in a staging environment and am getting the same issues. I was able to get more information on errors as seen below. Is there any update on this?

    [26-Oct-2023 13:41:37 UTC] WordPress database error Unknown storage engine ‘MEMORY’ for query CREATE TABLE IF NOT EXISTS wp_wfls_role_counts (
    serialized_roles VARBINARY(255) NOT NULL,
    two_factor_inactive TINYINT(1) NOT NULL,
    user_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (serialized_roles, two_factor_inactive)
    ) ENGINE=MEMORY; /* From [/wp-admin/network/admin.php?page=WFLS&user=33] in [/wp-content/plugins/wordfence/modules/login-security/classes/controller/wordfencels.php:254] / made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), 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_table

    [26-Oct-2023 13:41:37 UTC] WordPress database error Unknown storage engine ‘MyISAM’ for query CREATE TABLE IF NOT EXISTS wp_wfls_role_counts ( serialized_roles VARBINARY(255) NOT NULL, two_factor_inactive TINYINT(1) NOT NULL, user_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (serialized_roles, two_factor_inactive) ) ENGINE=MyISAM; / From [/wp-admin/network/admin.php?page=WFLS&user=33] in [/wp-content/plugins/wordfence/modules/login-security/classes/controller/wordfencels.php:254] / made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), 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_table

    [26-Oct-2023 13:41:38 UTC] WordPress database error Illegal mix of collations for operation ‘UNION’ for query SELECT option_name, option_value FROM wp_options WHERE option_name LIKE ‘%user_roles’ UNION SELECT option_name, option_value FROM wp_2_options WHERE option_name LIKE ‘%user_roles’ / From [/wp-admin/network/admin.php?page=WFLS&user=33] in [/wp-content/plugins/wordfence/modules/login-security/classes/controller/permissions.php:352] / made by require_once(‘wp-admin/admin.php’), do_action(‘wordfence_page_WFLS’), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_menu, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/page.php’), WordfenceLS\Model_View->__toString, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/manage.php’), WordfenceLS\Controller_Users->has_2fa_active, WordfenceLS\Controller_Users->can_activate_2fa, WordfenceLS\Controller_Permissions->does_user_have_multisite_capability, WordfenceLS\Controller_Permissions->get_multisite_roles, WordfenceLS\Controller_Permissions->_load_multisite_roles

    [26-Oct-2023 13:41:38 UTC] WordPress database error Unknown storage engine ‘MEMORY’ for query CREATE TEMPORARY TABLE IF NOT EXISTS wp_wfls_role_counts_temporary ( serialized_roles VARBINARY(255) NOT NULL, two_factor_inactive TINYINT(1) NOT NULL, user_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (serialized_roles, two_factor_inactive) ) ENGINE=MEMORY; / From [/wp-admin/network/admin.php?page=WFLS&user=33] in [/wp-content/plugins/wordfence/modules/login-security/classes/controller/users.php:368] / made by require_once(‘wp-admin/admin.php’), do_action(‘wordfence_page_WFLS’), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_menu, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/page.php’), WordfenceLS\Model_View->__toString, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/settings.php’), WordfenceLS\Controller_Users->get_detailed_user_counts_if_enabled, WordfenceLS\Controller_Users->detailed_user_counts, WordfenceLS\Controller_DB->create_temporary_role_counts_table, WordfenceLS\Controller_DB->create_temporary_table, WordfenceLS\Controller_DB->create_table, WordfenceLS\Controller_DB->create_table

    [26-Oct-2023 13:41:38 UTC] WordPress database error Unknown storage engine ‘MyISAM’ for query CREATE TEMPORARY TABLE IF NOT EXISTS wp_wfls_role_counts_temporary ( serialized_roles VARBINARY(255) NOT NULL, two_factor_inactive TINYINT(1) NOT NULL, user_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (serialized_roles, two_factor_inactive) ) ENGINE=MyISAM; / From [/wp-admin/network/admin.php?page=WFLS&user=33] in [/wp-content/plugins/wordfence/modules/login-security/classes/controller/users.php:368] / made by require_once(‘wp-admin/admin.php’), do_action(‘wordfence_page_WFLS’), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_menu, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/page.php’), WordfenceLS\Model_View->__toString, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/settings.php’), WordfenceLS\Controller_Users->get_detailed_user_counts_if_enabled, WordfenceLS\Controller_Users->detailed_user_counts, WordfenceLS\Controller_DB->create_temporary_role_counts_table, WordfenceLS\Controller_DB->create_temporary_table, WordfenceLS\Controller_DB->create_table, WordfenceLS\Controller_DB->create_table [26-Oct-2023 13:42:20 UTC] PHP Notice: Undefined index: log in /wp-content/mu-plugins/wpengine-common/wpe-sec.php on line 35

    [26-Oct-2023 13:42:37 UTC] WordPress database error Illegal mix of collations for operation ‘UNION’ for query SELECT option_name, option_value FROM wp_options WHERE option_name LIKE ‘%user_roles’ UNION SELECT option_name, option_value FROM wp_2_options WHERE option_name LIKE ‘%user_roles’ / From [/wp-admin/admin-ajax.php] in [/wp-content/plugins/wordfence/modules/login-security/classes/controller/permissions.php:352] / made by do_action(‘wp_ajax_nopriv_wordfence_ls_authenticate’), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_AJAX->_ajax_handler, call_user_func, WordfenceLS\Controller_AJAX->_ajax_authenticate_callback, WordfenceLS\Controller_Users->has_2fa_active, WordfenceLS\Controller_Users->can_activate_2fa, WordfenceLS\Controller_Permissions->does_user_have_multisite_capability, WordfenceLS\Controller_Permissions->get_multisite_roles, WordfenceLS\Controller_Permissions->_load_multisite_roles

    [26-Oct-2023 13:42:37 UTC] WordPress database error Illegal mix of collations for operation ‘UNION’ for query SELECT option_name, option_value FROM wp_options WHERE option_name LIKE ‘%user_roles’ UNION SELECT option_name, option_value FROM wp_2_options WHERE option_name LIKE ‘%user_roles’ / From [/wp-login.php?wpe-login=true] in [/nas/content/live/ccklawstaging/wp-content/plugins/wordfence/modules/login-security/classes/controller/permissions.php:352] / made by wp_signon, wp_authenticate, apply_filters(‘authenticate’), WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_authenticate, WordfenceLS\Controller_Users->has_2fa_active, WordfenceLS\Controller_Users->can_activate_2fa, WordfenceLS\Controller_Permissions->does_user_have_multisite_capability, WordfenceLS\Controller_Permissions->get_multisite_roles, WordfenceLS\Controller_Permissions->_load_multisite_roles

    [26-Oct-2023 13:42:37 UTC] WordPress database error Illegal mix of collations for operation ‘UNION’ for query SELECT option_name, option_value FROM wp_options WHERE option_name LIKE ‘%user_roles’ UNION SELECT option_name, option_value FROM wp_2_options WHERE option_name LIKE ‘%user_roles’ / From [/wp-login.php?wpe-login=true] in [/nas/content/live/ccklawstaging/wp-content/plugins/wordfence/modules/login-security/classes/controller/permissions.php:352] / made by wp_signon, wp_authenticate, apply_filters(‘authenticate’), WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_authenticate, WordfenceLS\Controller_Users->record_captcha_score, WordfenceLS\Controller_Users->has_2fa_active, WordfenceLS\Controller_Users->can_activate_2fa, WordfenceLS\Controller_Permissions->does_user_have_multisite_capability, WordfenceLS\Controller_Permissions->get_multisite_roles, WordfenceLS\Controller_Permissions->_load_multisite_roles

    [26-Oct-2023 13:42:37 UTC] WordPress database error Illegal mix of collations for operation ‘UNION’ for query SELECT option_name, option_value FROM wp_options WHERE option_name LIKE ‘%user_roles’ UNION SELECT option_name, option_value FROM wp_2_options WHERE option_name LIKE ‘%user_roles’ / From [/wp-login.php?wpe-login=true] in [/nas/content/live/ccklawstaging/wp-content/plugins/wordfence/modules/login-security/classes/controller/permissions.php:352] */ made by wp_signon, wp_authenticate, apply_filters(‘authenticate’), WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_authenticate, WordfenceLS\Controller_Users->can_activate_2fa, WordfenceLS\Controller_Permissions->does_user_have_multisite_capability, WordfenceLS\Controller_Permissions->get_multisite_roles, WordfenceLS\Controller_Permissions->_load_multisite_roles

    Plugin Support wfscott

    (@wfscott)

    Hello, @kkow

    Thanks for your patience and for sending over the information. We have a fix for this issue expected at the beginning of the week. In the meantime, it is fine to stay on the prior version of Wordfence that you switched to.

    Sorry for the inconvenience.

    Thanks,
    Scott

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Errors on 7.10.5’ is closed to new replies.