WordPress database error You have an error in your SQL syntax

  • PHP: 8.2.24

    WordPress: 6.6.2

    Woocommerce: 9.3.3

    MStore API: 4.15.5

    [12-Oct-2024 08:22:17 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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

  • You must be logged in to reply to this topic.