[ad_1]
Hello,
After the lates update i get my debug-log filled with the below database error:
[26-Aug-2022 20:27:42 UTC] WordPress database error Unknown column 'relevanssi.doc' in 'where clause' for query SELECT COUNT(DISTINCT product_or_parent_id) as term_count, term_id as term_count_id FROM wp_relevanssi AS relevanssi, wp_wc_product_attributes_lookup
LEFT JOIN wp_term_relationships ON (wp_wc_product_attributes_lookup.product_or_parent_id = wp_term_relationships.object_id)
INNER JOIN wp_posts ON wp_posts.ID = wp_wc_product_attributes_lookup.product_or_parent_id
WHERE relevanssi.doc = wp_posts.ID AND wp_posts.post_type IN ( 'product' )
AND wp_posts.post_status = 'publish'
AND (
wp_wc_product_attributes_lookup.product_or_parent_id NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE relevanssi.doc = wp_posts.ID AND term_taxonomy_id IN (7)
)
AND
wp_term_relationships.term_taxonomy_id IN (16,273,274,275,276,277,278,279,280,282,301,316,317,318,319,320,321,322,323,330,331,332,333,334,335,337,338,339,340,368,369,370,375,376,377,378,379,396,397,398,399,453,454,455,456,462,497,574,694,940)
)
AND wp_wc_product_attributes_lookup.taxonomy='pa_brand'
AND wp_wc_product_attributes_lookup.term_id IN (640,596,94,82,101,613,102,103,639,947,864,649,968,903,104,365,618,936,570,868,723,718,576,619,638,106,643,675,127,107,169,938,943,433,108,98,468,575,948,244,109,852,110,111,366,952,54,937,112,950,964,835,539,113,893,498,773,676,255,688,114,115,361,881,116,931,934,117,118,944,642,565,967,328,939,197,862,894,119,517,199,44,892,840,726,824,120,327,564,121,873,612,241,942,122,966,123,860,839,732,965,464,124,738,242,951,572,125,95,42,126,623)
AND product_or_parent_id IN ( SELECT product_or_parent_id FROM (
SELECT product_or_parent_id
FROM wp_wc_product_attributes_lookup lt
WHERE relevanssi.doc = wp_posts.ID AND is_variation_attribute=0
AND term_id in (202)
GROUP BY product_id
HAVING COUNT(product_id)=1
UNION
SELECT product_or_parent_id
FROM wp_wc_product_attributes_lookup lt
WHERE relevanssi.doc = wp_posts.ID AND is_variation_attribute=1
AND term_id in (202)
) temp ) GROUP BY wp_wc_product_attributes_lookup.term_id made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/woocommerce/templates/taxonomy-product-cat.php'), wc_get_template, include('/themes/woodmart/woocommerce/archive-product.php'), do_action('woocommerce_sidebar'), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_get_sidebar, wc_get_template, include('/plugins/woocommerce/templates/global/sidebar.php'), get_sidebar, locate_template, load_template, require_once('/themes/woodmart/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, WOODMART_Widget_Layered_Nav->widget, WOODMART_Widget_Layered_Nav->layered_nav_list, WOODMART_Widget_Layered_Nav->get_filtered_term_product_counts, Automattic\WooCommerce\Internal\ProductAttributesLookup\Filterer->get_filtered_term_product_countsDo you have any idea what can cause this?
Brgds
Rune
