Forum Replies Created

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

    (@kkow)

    Hi @sasiddiqui,

    Polylang support has requested that you reach out to them at [email protected] and they will work with you to resolve this issue.

    Thank you!

    Thread Starter kkow

    (@kkow)

    It may be related to Pro and how you can have the same slug like ‘blog’ in multiple languages. However, as mentioned, this feature works fine until custom permalinks is activated. I was able to temporarily “fix” the issue with the ‘custom_permalinks_avoid_redirect’ hook for that permalink. I’ll ask Polylang if I can provide you with a copy of pro for testing purposes.

    Thread Starter kkow

    (@kkow)

    Thank you for the quick response!

    Thread Starter kkow

    (@kkow)

    I made a pull request for this FYI: https://github.com/samiahmedsiddiqui/custom-permalinks/pull/103

    Thank you

    Thread Starter kkow

    (@kkow)

    Found a separate custom taxonomy that had the same slug. I wish these could be separated somehow since they are not the same taxonomy but it makes sense now why it was being added.

    Thread Starter kkow

    (@kkow)

    Hello! Checking in on this question and keeping it active

    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

    Thread Starter kkow

    (@kkow)

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

    Thread Starter kkow

    (@kkow)

    Hi,

    Any updates on when this will be implemented?

    Thanks!

    Files are stored in the cf7db uploads folder

    Thread Starter kkow

    (@kkow)

    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

    Thread Starter kkow

    (@kkow)

    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

    Thread Starter kkow

    (@kkow)

    Awesome, thank you!

Viewing 15 replies - 1 through 15 (of 51 total)