{"id":9512638,"date":"2017-09-20T09:24:55","date_gmt":"2017-09-20T09:24:55","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/wp-database-error-sql-syntax\/"},"modified":"2017-09-20T09:24:55","modified_gmt":"2017-09-20T09:24:55","slug":"wp-database-error-sql-syntax","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/wp-database-error-sql-syntax\/","title":{"rendered":"WP Database error (SQL Syntax)"},"content":{"rendered":"

Dear support,
\nthis morning i went on my woocommerce products and noticed an error showing up, then i went to check it the error log and it says:<\/p>\n

[20-Sep-2017 09:18:25 UTC] WordPress errore sul database 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 ‘%1$s )’ at line 3 per la query
\n\t\t\t\tSELECT internal_link_count, incoming_link_count, object_id
\n\t\t\t\tFROM wpCBI_yoast_seo_meta
\n\t\t\t WHERE object_id IN ( %1$s ) fatta da WP_List_Table->display, WP_List_Table->display_tablenav, WP_Posts_List_Table->extra_tablenav, do_action(‘manage_posts_extra_tablenav’), WP_Hook->do_action, WP_Hook->apply_filters, WPSEO_Link_Columns->count_objects, WPSEO_Link_Columns->set_count_objects, WPSEO_Link_Column_Count->set, WPSEO_Link_Column_Count->get_results
\n[20-Sep-2017 09:18:39 UTC] WordPress errore sul database 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 ‘%1$s )’ at line 3 per la query
\n\t\t\t\tSELECT internal_link_count, incoming_link_count, object_id
\n\t\t\t\tFROM wpCBI_yoast_seo_meta
\n\t\t\t WHERE object_id IN ( %1$s ) fatta da WP_List_Table->display, WP_List_Table->display_tablenav, WP_Posts_List_Table->extra_tablenav, do_action(‘manage_posts_extra_tablenav’), WP_Hook->do_action, WP_Hook->apply_filters, WPSEO_Link_Columns->count_objects, WPSEO_Link_Columns->set_count_objects, WPSEO_Link_Column_Count->set, WPSEO_Link_Column_Count->get_results<\/p>\n

Why did it come out like this?
\nThanks<\/p>\n","protected":false},"template":"","class_list":["post-9512638","topic","type-topic","status-publish","hentry","topic-tag-database","topic-tag-sql","topic-tag-wordpress-database-error"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/9512638","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\/9512638\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=9512638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}