davidsimon14

Well, the problem is back. I checked the wp-config and my edit is still there, so it didn’t fix the problem entirely.

Do you mean that the plugin is supposed to be translated automaticaly on the front end, or we are supposed to have options available to translate the strings?

It seems to have fixed the problem, thank you.

Can you explain the problem? Our webserver is a VPS which is running smoothly right now, with enough memory to sustain wp websites and nearly a hundred other sites. We have other WordPress sites with cleantalk running on this one, I’m going to check other sites if they have the same problem, and other sites on other servers, but if you could specify why this problem occurs so I can anticipate the problem, because I don’t like when clients call and see problems before we do.

Thanks!

Yeah, like I told you it’s only when I am logged in. It doesn’t do that when not logged in or in private session.

Oh I think it’s my adblock (ublock origin) that is blocking you. is that normal? I think my coworker has the same issue but with another adblock.

Do you have the error on your side?

But isn’t the pixel useful for better protection?

Hi Dimitri,

You fixed the problem by answering to the other thread I created here:

https://www.ads-software.com/support/topic/neterr_blocked_by_client-2/#post-17462758

Hi Dimitri,

It fixed the issue! Thank you very much!

I managed to fix it.

The problem was that I was declaring my scripts and ajax handlers inside my short code. I needed to declare them either inside the plugin or functions.php.

Thanks all!

Hey guys,

I changed my code with all your answers, but the error persists. I also added a nonce… Here is what I have now:

add_shortcode('choix_produits', 'wpcode_elementor_shortcode');

function wpcode_elementor_shortcode($atts) {
	global $wpdb;
	$admin_url = admin_url( 'admin-ajax.php' );
	echo "<form action=\"$admin_url\" method=\"post\" class=\"\">";
	
	echo '<select name="marques" id="marques">';

    $results = $wpdb->get_results("SELECT distinct(marque) FROM wpfir_module_bougies;");

    if ($results) {
        foreach ($results as $row) {
            echo '<option value="' . esc_attr($row->marque) . '">' . esc_html($row->marque) . '</option>';
        }
    } else {
        echo '<option value="">Aucune donnée trouvée</option>';
    }
    
	echo '</select>';
		
	echo '<select name="modeles" id="modeles"><option value="">Sélectionnez un modèle</option></select>';
	
	echo '</form>'; 
	
	$nonce = wp_create_nonce('my_nonce_action');

	// Ajout du script
    wp_register_script('script_bougies', content_url() . '/plugins/bougies/script_bougies.js', array('jquery'), '1.0', true);
	wp_localize_script('script_bougies', 'ajax_object', array('ajax_url' => admin_url('admin-ajax.php'),'nonce' => $nonce));
    wp_enqueue_script('script_bougies');


	function get_modeles_callback() {
		$marque_selected = esc_sql($_POST['marque']);
		//error_log("marque : ".print_r( $marque_selected, true ) );
		$modeles = $wpdb->get_results($wpdb->prepare("SELECT distinct(modele) FROM wpfir_module_bougies where marque = %s", $marque_selected));

		if ($modeles) {
			$options_html = '';
			foreach ($modeles as $modele) {
   				$options_html .= '<option value="' . esc_attr($modele->modele) . '">' . esc_html($modele->modele) . '</option>';
			}
		} else {
			echo "<option value=''>Aucune donnée trouvée</option>";
		}
		
		

		echo $options_html;
		wp_die();
	}
		
	add_action('wp_ajax_get_modeles', 'get_modeles_callback');
	add_action('wp_ajax_nopriv_get_modeles', 'get_modeles_callback');

}

jQuery(document).ready(function ($) { 
    $('#marques').on('change', function() {
        var marqueSelected = $(this).val();

        $.ajax({
            url: ajax_object.ajax_url,
            type: 'POST',
			dataType: 'json', 
            data: {
                action: 'get_modeles', 
                marque: marqueSelected,
				nonce: ajax_object.nonce
            },
            success: function(response) {
                $('#modeles').html(response);
            },
            error: function(xhr, status, error) {
                console.error(status + ': ' + error);
            }
        });
    });
});

Any way I can debug it step by step?

Hey @wpprovider

Thanks a lot for taking the time to detect and fix all these issues!

Unfortunately, after fixing everything, the 400 error is still there :'(

Cheers,

Hi Ckadenge,

Thank you. Yes I found this yesterday!

I found an easy solution to fix the problem if you have only a few items: just replace the sale value by something else, save, and then put the right sale value and save again.

If you have too many products to update, I found a piece of php code to execute that fixed the problem. I won’t post it here because I have lost the link and can’t credit the author, but you can still pm me.

Well that would be much more efficient to load everything in only one request if it’s on the same table.

I might check it out later. We are changing our servers for our sites that uses a lot of back office, we’ll see if it’s still slow or if we need to do something plugin-wise.

Thank you!

• This reply was modified 1 year, 5 months ago by davidsimon14.

Hey Rogier,

Well this website has been there for a while now, no reason the scan isn’t finished.

There are lots of (CMPLZ_COOKIE->get())

ex: select * from wpeec_cmplz_cookies where ID = '1'

and a few (get_option())

ex: SELECT?option_value
FROM?wpeec_options
WHERE?option_name = '_transient_cmplz_processed_pages_list'
LIMIT?1

We are using pretty much the same combos of plugins on all our websites. I tested out another one, and 85 queries for this one, same problem.

Hi, I have an identical problem, it’s spamming my logs if I stay on a page with a FAQ, I got 1 every second:

AH01071: Got error ‘

PHP message: upgrades init

PHP message: $helpie_version : 1.9.18

PHP message: HELPIE_FAQ_VERSION : 1.9.18′