kkow

Hello! Checking in on this question and keeping it active

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

wow, that’s awesome. thank you so much!

Hi,

Any updates on when this will be implemented?

Thanks!

Files are stored in the cf7db uploads folder

Hello, apologies for another message. I found the GitHub link from another post and made a pull request. Hope this helps, thanks!

https://github.com/arshidkv12/contact-form-cfdb7/pull/34

I updated the cfdb7_before_send_mail function with a fix for this issue. Changes are bolded. Can this be added? I’d be happy to make a pull request if needed, didn’t see a github anywhere. Thanks again!

function cfdb7_before_send_mail( $form_tag ) {

    global $wpdb;
    $cfdb          = apply_filters( 'cfdb7_database', $wpdb );
    $table_name    = $cfdb->prefix.'db7_forms';
    $upload_dir    = wp_upload_dir();
    $cfdb7_dirname = $upload_dir['basedir'].'/cfdb7_uploads';
    $time_now      = time();

    $submission   = WPCF7_Submission::get_instance();
    $contact_form = $submission->get_contact_form();
    $tags_names   = array();
    $strict_keys  = apply_filters('cfdb7_strict_keys', false);  

    if ( $submission ) {

        $allowed_tags = array();

        if( $strict_keys ){
            $tags  = $contact_form->scan_form_tags();
            foreach( $tags as $tag ){
                if( ! empty($tag->name) ) $tags_names[] = $tag->name;
            }
            $allowed_tags = $tags_names;
        }

        $not_allowed_tags = apply_filters( 'cfdb7_not_allowed_tags', array( 'g-recaptcha-response' ) );
        $allowed_tags     = apply_filters( 'cfdb7_allowed_tags', $allowed_tags );
        $data             = $submission->get_posted_data();
        $files            = $submission->uploaded_files();
        $uploaded_files   = array();


        foreach ($_FILES as $file_key => $file) {
            array_push($uploaded_files, $file_key);
        }
        foreach ($files as $file_key => $file) {
            $file = is_array( $file ) ? reset( $file ) : $file;
            if( empty($file) || in_array($file_key, $not_allowed_tags) ) continue;
            copy($file, $cfdb7_dirname.'/'.$time_now.'-'.$file_key.'-'.basename($file));
        }

        $form_data   = array();

        $form_data['cfdb7_status'] = 'unread';
        foreach ($data as $key => $d) {
            
            if( $strict_keys && !in_array($key, $allowed_tags) ) continue;

            if ( !in_array($key, $not_allowed_tags ) && !in_array($key, $uploaded_files )  ) {

                $tmpD = $d;

                if ( ! is_array($d) ){
                    $bl   = array('\"',"\'",'/','\\','"',"'");
                    $wl   = array('"',''','/', '\','"',''');
                    $tmpD = str_replace($bl, $wl, $tmpD );
                }

                $form_data[$key] = $tmpD;
            }
            if ( in_array($key, $uploaded_files ) && !in_array($key, $not_allowed_tags) ) {
                $file = is_array( $files[ $key ] ) ? reset( $files[ $key ] ) : $files[ $key ];
                $file_name = empty( $file ) ? '' : $time_now.'-'.$key.'-'.basename( $file ); 
                $form_data[$key.'cfdb7_file'] = $file_name;
            }
        }


        /* cfdb7 before save data. */
        $form_data = apply_filters('cfdb7_before_save_data', $form_data);

        do_action( 'cfdb7_before_save', $form_data );

        $form_post_id = $form_tag->id();
        $form_value   = serialize( $form_data );
        $form_date    = current_time('Y-m-d H:i:s');

        $cfdb->insert( $table_name, array(
            'form_post_id' => $form_post_id,
            'form_value'   => $form_value,
            'form_date'    => $form_date
        ) );

        /* cfdb7 after save data */
        $insert_id = $cfdb->insert_id;
        do_action( 'cfdb7_after_save_data', $insert_id );
    }

}

select the forms submit button and simulate a click with “.click()” instead of “.submit()”

you will likely need to have a check to make sure you don’t get stuck in a loop of intersecting the form on click and then having the program click again.

I’m still getting this error as well

Awesome, thank you!

Hi @stevejburge

Hmm, I tried the troubleshooting steps but am still having an issue. We do use WPEngine so I contacted support to ensure that revisions are enabled, I disabled all plugins except Revisions, checked permissions, and deleted and reinstalled the plugin.

We are a multisite, but it looks like the plugin is supposed to support that, correct? I do have a ‘New Revision’ link when looking at a list of all the posts in the wordpress admin area, but when you go into any single post the button is not there. However, like mentioned before, it is there for custom post types. This really has me stumped. Any other help would be appreciated!

Thank you

+1 – I would love to see this as well

Update: I did use the Health Check Tool to test the production site with only what was needed: The theme, Yoast SEO, and ACF. Everything else was disabled and the issues persists. I also noticed there is no canonical URL being output either

Hi,

Yes we are currently running the current versions of both Yoast and WordPress. I am unable to test a different theme as the custom taxonomy that this effects is defined in that theme. Strangely enough though, our development and staging sites use the same setup, versions, plugins, etc. and do not have this issue.

Hmm, the issue does seem to be persisting after performing those steps. Any other suggestions? Thanks again!