jeff2mars

As you all seem on holiday, I will ask a full refund in a few days

Support? Are you on holiday?

I’ve enabled ESI. The 403 Ajax error is fixed BUT my issue is still there.

Again, please verify this issue is not on your side, in the premium version.

Go to https://www.oblade.fr/categorie-produit/bracelets-homme/bracelets-en-perles/collection-fuji/, click on the heart icon to add a product in wishlist, then refresh the page… and see that the icon is not showing the product is already in wishlist.

• This reply was modified 4 years, 3 months ago by jeff2mars.

PS3: I have activated the free version again, so you won’t see the issue at the moment if you go check the page

I’ve deleted all the caches, set the cache lifespan to 8 hours, the bug is still there. I’m using LSCache on a Litespeed server. I have other plugins using Ajax without any issue. Let me remember you that the problem is only on the premium version, what’s different from the free version regarding my issue? It’s only when i click on an add to wishlist button on the shop page, that the heart icons of each already-in-wishlist item turns fully colored… but when loading the page, all the icons of the already-in-wishlist items are outlined like if they were not already in the wishlist ! Have you checked that THIS issue is not on your side before answering me?

PS: it would be much appreciated that you don’t set the topic as resolved until it is.
PS2: please read my issue in details, have you considered that it is not present on the free version ?

• This reply was modified 4 years, 3 months ago by jeff2mars.
• This reply was modified 4 years, 3 months ago by jeff2mars.
• This reply was modified 4 years, 3 months ago by jeff2mars.
• This reply was modified 4 years, 3 months ago by jeff2mars.
• This reply was modified 4 years, 3 months ago by jeff2mars.
• This reply was modified 4 years, 3 months ago by jeff2mars.
• This reply was modified 4 years, 3 months ago by jeff2mars.
• This reply was modified 4 years, 3 months ago by jeff2mars.

https://www.oblade.fr/categorie-produit/bracelets-homme/bracelets-en-perles/collection-fuji/

When disabling my cache plugin the bug is still there

• This reply was modified 4 years, 3 months ago by jeff2mars.

Localize <IfModule mod_deflate.c> in your .htacess file and add below :

SetEnvIfNoCase Request_URI ^/thumb.php no-gzip dont-vary

Be careful when editing your .htacess, do it with a software like Notepad++, and in Encoding check UTF-8 without BOM before saving the file.

Localize <IfModule mod_deflate.c> in your .htacess file and add below :

SetEnvIfNoCase Request_URI ^/thumb.php no-gzip dont-vary

Be careful when editing your .htacess, do it with a software like Notepad++, and in Encoding check UTF-8 without BOM before saving the file.

I’m using the plugin “WooCommerce Email Customizer with Drag and Drop Email Builder” to customize the email templates.

If I desactivate the plugin, the info are displayed in the email. But with the previous version it worked well, something broke the association in your last version.

I would be very interested too in having this possibility !

Any news ?

I managed to make it work!!!

As woocommerce has its own query to order products, it works by making a function such as

if(isset($_GET['lat']) and $_GET['lat'] != "" and isset($_GET['lng']) and $_GET['lng'] != "")
{
add_filter( 'woocommerce_default_catalog_orderby','custom_woocommerce_get_catalog_ordering_args' );
}
function custom_woocommerce_get_catalog_ordering_args( $args ) {
  
		$args['orderby'] = ' (POW((acf_gms_geo.lng-{$lng}),2) + POW((acf_gms_geo.lat-

{$lat}),2))';
		$args['order'] = 'ASC';
		$args['meta_key'] = '';
	
	return $args;
}

I have this meta_query :

$today = current_time('Ymd');
 $args = array (
    'numberposts' => -1,
    'post_status'       => 'publish',
    'post_type'         => 'product',
    'meta_query' => array(
    'relation' => 'AND',
    'start_clause' => array(
        'key'=>'flash_sale_start',
        'value' => $today,
        'compare'=> '<=',
     'type' => 'DATE'
    ),
         'end_clause' => array(
         'key' => 'flash_sale_end',
     'value' => $today,
         'compare' => '>=',
     'type' => 'DATE'
)

       )
);
return $args;
}

// The main shop and archives meta query
add_filter( 'woocommerce_product_query_meta_query', 'custom_product_query_meta_query', 10, 2 );
function custom_product_query_meta_query( $meta_query, $query ) {
    if( ! is_admin() ) 
        return custom_meta_query( $meta_query );
}

from which depends this sql query that doesn’t display the orderby location :

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts
INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )
LEFT JOIN wp_acf_google_map_search_geodata AS acf_gms_geo ON wp_posts.ID = acf_gms_geo.post_id WHERE 1=1 AND wp_posts.ID NOT IN (968) AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (10)
)
) AND (
wp_postmeta.meta_key = ‘total_sales’
AND
(
(
( mt1.meta_key = ‘flash_sale_start’ AND CAST(mt1.meta_value AS DATE) <= ‘20180125’ )
AND
( mt2.meta_key = ‘flash_sale_end’ AND CAST(mt2.meta_value AS DATE) >= ‘20180125’ )
)
)
) AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘complete’ OR wp_posts.post_status = ‘paid’ OR wp_posts.post_status = ‘confirmed’ OR wp_posts.post_status = ‘unpaid’ OR wp_posts.post_status = ‘pending-confirmation’ OR wp_posts.post_status = ‘cancelled’ OR wp_posts.post_status = ‘private’)
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 100

And I have also this meta query :

$products = new WP_Query( array (
            'post_type'         => 'product',
            'post_status'       => 'publish',
            'posts_per_page'    => $atts['limit'],
            'meta_query'        => array(
                'relation'      => 'AND',
                'start_clause'  => array(
                    'key'       =>'flash_sale_start',
                    'value'     => $today,
                    'compare'   => '>',
                    'type'      => 'DATE'
                ),
                'end_clause'    => array(
                    'key'       => 'flash_sale_end',
                    'value'     => $today,
                    'compare'   => '>',
                    'type'      => 'DATE'
                ),
		'limit_clause'    => array(
                    'key'       => 'flash_sale_start',
                    'value'     => $limitdate,
                    'compare'   => '<=',
                    'type'      => 'DATE'
                )
)

        ));
}

        ob_start();

        if ( $products->have_posts() ) { ?>

            <?php woocommerce_product_loop_start(); ?>

                <?php while ( $products->have_posts() ) : $products->the_post(); ?>

                    <?php wc_get_template_part( 'content', 'product' ); ?>

                <?php endwhile; // end of the loop. ?>

            <?php woocommerce_product_loop_end(); ?>

            <?php
        } else {
            do_action( "woocommerce_shortcode_products_loop_no_results", $atts );
            echo "<p>Aucune vente à venir pour le moment.</p>";
        }

        woocommerce_reset_loop();
        wp_reset_postdata();

        return '<div class="woocommerce columns-' . $atts['columns'] . '">' . ob_get_clean() . '</div>';
    }

    add_shortcode( 'upcoming_sales', 'upcoming_sales' );

from which depends this sql_query displaying the orderby location :

SELECT wp_posts.*
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
INNER JOIN wp_postmeta AS mt2
ON ( wp_posts.ID = mt2.post_id )
LEFT JOIN wp_acf_google_map_search_geodata AS acf_gms_geo
ON wp_posts.ID = acf_gms_geo.post_id
WHERE 1=1
AND (
( wp_postmeta.meta_key = ‘flash_sale_start’
AND CAST(wp_postmeta.meta_value AS DATE) > ‘20180122’
)
AND ( mt1.meta_key = ‘flash_sale_end’
AND CAST(mt1.meta_value AS DATE) > ‘20180122’
)
AND ( mt2.meta_key = ‘flash_sale_start’
AND CAST(mt2.meta_value AS DATE) <= ‘20180127’
)
)
AND wp_posts.post_type = ‘product’
AND ((wp_posts.post_status = ‘publish’))
GROUP BY wp_posts.ID
ORDER BY (POW((acf_gms_geo.lng-6.640710899999931),2) + POW((acf_gms_geo.lat-43.26768079999999),2)) ASC

Do you know why the plugin cannot do the orderby in the first sql query ?

I identified the problem. I have two meta_query in my functions.php to display products in two different places of my page according to two different rules.

And the ORDER BY location triggered by the plugin only appears in one of the sql query but not in this one (although the LEFT JOIN part appears) :

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts
INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )
LEFT JOIN wp_acf_google_map_search_geodata AS acf_gms_geo ON wp_posts.ID = acf_gms_geo.post_id WHERE 1=1 AND wp_posts.ID NOT IN (968) AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (10)
)
) AND (
wp_postmeta.meta_key = ‘total_sales’
AND
(
(
( mt1.meta_key = ‘flash_sale_start’ AND CAST(mt1.meta_value AS DATE) <= ‘20180125’ )
AND
( mt2.meta_key = ‘flash_sale_end’ AND CAST(mt2.meta_value AS DATE) >= ‘20180125’ )
)
)
) AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘complete’ OR wp_posts.post_status = ‘paid’ OR wp_posts.post_status = ‘confirmed’ OR wp_posts.post_status = ‘unpaid’ OR wp_posts.post_status = ‘pending-confirmation’ OR wp_posts.post_status = ‘cancelled’ OR wp_posts.post_status = ‘private’)
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 100

• This reply was modified 7 years, 1 month ago by jeff2mars.
• This reply was modified 7 years, 1 month ago by jeff2mars.

no idea ?

SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_acf_google_map_search_geodata AS acf_gms_geo ON wp_posts.ID = acf_gms_geo.post_id WHERE 1=1 AND (
( wp_postmeta.meta_key = ‘flash_sale_start’ AND CAST(wp_postmeta.meta_value AS DATE) > ‘20180122’ )
AND
( mt1.meta_key = ‘flash_sale_end’ AND CAST(mt1.meta_value AS DATE) > ‘20180122’ )
AND
( mt2.meta_key = ‘flash_sale_start’ AND CAST(mt2.meta_value AS DATE) <= ‘20180127’ )
) AND wp_posts.post_type = ‘product’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY (POW((acf_gms_geo.lng-6.640710899999931),2) + POW((acf_gms_geo.lat-43.26768079999999),2)) ASC

• This reply was modified 7 years, 2 months ago by jeff2mars.