{"id":18017040,"date":"2024-09-16T09:53:39","date_gmt":"2024-09-16T09:53:39","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/wordpress-database-error-you-have-an-error-in-your-sql-syntax-check-the-manual\/"},"modified":"2024-09-16T09:53:39","modified_gmt":"2024-09-16T09:53:39","slug":"wordpress-database-error-you-have-an-error-in-your-sql-syntax-check-the-manual","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/wordpress-database-error-you-have-an-error-in-your-sql-syntax-check-the-manual\/","title":{"rendered":"WordPress database error You have an error in your SQL syntax; check the manual"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">wordpress: 6.6.2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">woocommerce: 9.3.1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PHP: 8.1.29<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MariaDB: 10.6<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;16-Sep-2024 09:42:48 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 ')<br \/>\t\t 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 <br \/>\t\t\tINNER JOIN wp_term_relationships AS term_relationships ON wp_posts.ID = term_relationships.object_id<br \/>\t\t\tINNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )<br \/>\t\t\tINNER JOIN wp_terms AS terms USING( term_id )<br \/>\t\t\t <br \/>\t\t\tWHERE wp_posts.post_type IN ( 'product' )<br \/>\t\t\tAND wp_posts.post_status = 'publish'<br \/>\t\t\t<br \/>\t\t\tAND terms.term_id IN ()<br \/>\t\t GROUP BY terms.term_id made by require('wp-blog-header.php'), wp, WP-&gt;main, WP-&gt;parse_request, do_action_ref_array('parse_request'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, rest_api_loaded, WP_REST_Server-&gt;serve_request, WP_REST_Server-&gt;dispatch, WP_REST_Server-&gt;respond_to_request, WC_REST_Product_Attributes_V1_Controller-&gt;get_items, WC_REST_Product_Attributes_V1_Controller-&gt;prepare_item_for_response, apply_filters('woocommerce_rest_prepare_product_attribute'), WP_Hook-&gt;apply_filters, flutter_custom_change_product_attribute, get_filtered_term_product_counts<br \/><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"template":"","class_list":["post-18017040","topic","type-topic","status-publish","hentry","topic-tag-database"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18017040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18017040\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18017040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}