danfox

there are 3 errors in the file woocommerce-ajax-filters/includes/addons/woocommerce-variation.php from line 95 to 105.
Change from:

SELECT wp_posts.id as id, COALESCE(stock_table_init.out_of_stock_init1, "0") as out_of_stock_init
        FROM wp_posts
        LEFT JOIN (
            SELECT %1$s.id as id, "1" as out_of_stock_init1
            FROM %1$s
            ' . apply_filters('brAAPFcompat_WCvariation_out_of_stock_where', 'WHERE %1$s.id IN
            (
                SELECT object_id FROM %3$s
                WHERE term_taxonomy_id IN ( '.$outofstock.' )
            ) ') . '
        ) as stock_table_init on wp_posts.id = stock_table_init.id

to:

SELECT '.$wpdb->posts.'.id as id, COALESCE(stock_table_init.out_of_stock_init1, "0") as out_of_stock_init
        FROM '.$wpdb->posts.'
        LEFT JOIN (
            SELECT %1$s.id as id, "1" as out_of_stock_init1
            FROM %1$s
            ' . apply_filters('brAAPFcompat_WCvariation_out_of_stock_where', 'WHERE %1$s.id IN
            (
                SELECT object_id FROM %3$s
                WHERE term_taxonomy_id IN ( '.$outofstock.' )
            ) ') . '
        ) as stock_table_init on '.$wpdb->posts.'.id = stock_table_init.id

@amandanoronha

the modification in my previous post was for the logged users wishlist.
For the not logged users use this modification:

In the same file of above:
wp-content/plugins/yith-woocommerce-wishlist/includes/class.yith-wcwl.php
find the recurrence of:

$existing_products = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM {$wpdb->posts} AS p LEFT JOIN {$wpdb->postmeta} AS pm ON p.ID = pm.post_id WHERE post_type = %s AND post_status = %s AND pm.meta_key = %s AND pm.meta_value = %s", array( 'product', 'publish', '_visibility', 'visible' ) ) );

and change it to:

$existing_products = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM {$wpdb->posts} AS p LEFT JOIN {$wpdb->postmeta} AS pm ON p.ID = pm.post_id WHERE post_type = %s AND post_status = %s", array( 'product', 'publish' ) ) );

• This reply was modified 9 years, 3 months ago by danfox.
• This reply was modified 9 years, 3 months ago by danfox.
• This reply was modified 9 years, 3 months ago by danfox.
• This reply was modified 9 years, 3 months ago by danfox.

I found that the problem is in this query:

//                $sql = "SELECT *
//                        FROM <code>{$wpdb->yith_wcwl_items}</code> AS i
//                        LEFT JOIN {$wpdb->yith_wcwl_wishlists} AS l ON l.<code>ID</code> = i.<code>wishlist_id</code>
//                        INNER JOIN {$wpdb->posts} AS p ON p.ID = i.prod_id
//                        INNER JOIN {$wpdb->postmeta} AS pm ON pm.post_id = p.ID
//                        WHERE 1 AND p.post_type = %s AND p.post_status = %s AND pm.meta_key = %s AND pm.meta_value = %s";
                $sql = "SELECT *
                        FROM <code>{$wpdb->yith_wcwl_items}</code> AS i
                        LEFT JOIN {$wpdb->yith_wcwl_wishlists} AS l ON l.<code>ID</code> = i.<code>wishlist_id</code>
                        INNER JOIN {$wpdb->posts} AS p ON p.ID = i.prod_id
                        INNER JOIN {$wpdb->postmeta} AS pm ON pm.post_id = p.ID
                        WHERE 1 AND p.post_type = %s AND p.post_status = %s ";

check it for that join that doesn’t give any result…

• This reply was modified 9 years, 3 months ago by danfox.

I have the same issue, post update from facebook are not updating since the 28th of June…
I followed the same steps (with WP Control) of BillyHoller but I didn’t get any result.
Am I missing something?

Regards

Can you share the solution?

Hi there.
The problem is in get_post_list_with_thumbs.php at line 548
change:

$htmlcod .= '<tr><td><table cellspacing="0" cellpadding="0"><tr>';
	if($prevflg):
		$htmlcod .= '<td><a href="#'.$gplwtdiv.'" class="gplwt_pvlink" onclick="goprocess_gplwt(\''.$gplwtdiv.'\',\''.$parflw_p.'\')"><</a></td>';
        endif;
		if($nextflg):
		$htmlcod .= '<td><a href="#'.$gplwtdiv.'" class="gplwt_nxlink" onclick="goprocess_gplwt(\''.$gplwtdiv.'\',\''.$parflw_n.'\')">></a></td>';
        endif;
		$htmlcod .= '</tr></table></td></tr>';
		$htmlcod .= "</table></div>";
	if($ech):
    	echo $htmlcod;
	else:
		return $htmlcod;
	endif;

to:

if($prevflg):
		$htmlcod .= '<tr><td><table cellspacing="0" cellpadding="0"><tr>';

		$htmlcod .= '<td><a href="#'.$gplwtdiv.'" class="gplwt_pvlink" onclick="goprocess_gplwt(\''.$gplwtdiv.'\',\''.$parflw_p.'\')"><</a></td>';
        endif;
		if($nextflg):
		$htmlcod .= '<td><a href="#'.$gplwtdiv.'" class="gplwt_nxlink" onclick="goprocess_gplwt(\''.$gplwtdiv.'\',\''.$parflw_n.'\')">></a></td>';
        endif;
		$htmlcod .= '</tr></table></td></tr>';
		$htmlcod .= "</table></div>";
	if($ech):
    	echo $htmlcod;
	else:
		return $htmlcod;
	endif;

…and the empty <tr> will go away…