WordPress: 6.6.1
Woocommerce: 9.1.4
PHP: 8.1.29
MariaDB: 10.6
[29-Jul-2024 11:39:24 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
GROUP BY terms.term_id' at line 9 for query SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
WHERE wp_posts.post_type IN ( 'product' )
AND wp_posts.post_status = 'publish'
AND terms.term_id IN ()
GROUP BY terms.term_id made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WC_REST_Product_Attributes_V1_Controller->get_items, WC_REST_Product_Attributes_V1_Controller->prepare_item_for_response, apply_filters('woocommerce_rest_prepare_product_attribute'), WP_Hook->apply_filters, flutter_custom_change_product_attribute, get_filtered_term_product_counts
I don’t know where this problem file.
My VPS high load CPU because this problem.
This problem i found it in logs folder in cPanel.
please help me fix this problem.
Thanks