check the manual that corresponds to your MariaDB server version for the right s

  • WordPress: 6.5.5

    PHP: 8.3

    ________________________________________

    [26-Jun-2024 09:54:27 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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    What plugin is responsible for creating or modifying this SQL? Appears to be the plugin with this filter hook: “flutter_custom_change_product_attribute”. I recommend seeking assistance through that plugin’s dedicated support channel.

    The GROUP BY error is in the table name.column terms.term_id. Table name.column should be wp_terms.term_id. If you know how to correct this yourself, do it. The reason for using the dedicated support channel of the plugin is to get guidance on how to properly correct the relevant source code.

    Thread Starter Khaled Alkhamesi

    (@khaledalkhamesi)

    Ok, Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘check the manual that corresponds to your MariaDB server version for the right s’ is closed to new replies.