{"id":5653334,"date":"2015-01-09T16:00:43","date_gmt":"2015-01-09T16:00:43","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-errors-coming-up\/"},"modified":"2016-08-22T15:14:27","modified_gmt":"2016-08-22T15:14:27","slug":"sql-errors-coming-up","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-errors-coming-up\/","title":{"rendered":"SQL Errors coming up"},"content":{"rendered":"<p>Hi Dima,<\/p>\n<p>We&#8217;re getting the following error showing up a lot in our error_log\u2026<\/p>\n<pre><code>[09-Jan-2015 09:00:56 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 &#039;*) as nb\n\t\t\tFROM wp_stockist s,\n\t\t\twp_stockist_relation r,\n\t\t\twp_stockist_cat&#039; at line 1 for query  SELECT count(s.*) as nb\n\t\t\tFROM wp_stockist s,\n\t\t\twp_stockist_relation r,\n\t\t\twp_stockist_category c\n\t\t\tWHERE s.id=r.stockist\n\t\t\tAND r.category=c.id\n\t\t\tAND c.id=&#039;22&#039; made by require(&#039;wp-blog-header.php&#039;), require_once(&#039;wp-includes\/template-loader.php&#039;), include(&#039;\/themes\/legenda\/woocommerce\/single-product.php&#039;), woocommerce_get_template_part, wc_get_template_part, load_template, require(&#039;\/themes\/fydwd\/woocommerce\/content-single-product.php&#039;), woocommerce_output_product_data_tabs, wc_get_template, include(&#039;\/themes\/legenda\/woocommerce\/single-product\/tabs\/tabs.php&#039;), call_user_func, Stockist-&gt;woocommerce_product_stockists_tab, Stockist_shortcode-&gt;display_stockists, Stockist_db-&gt;return_nb_stockists<\/code><\/pre>\n<p>Any idea what is causing it, and what we can do to solve it?<\/p>\n<p>Thanks,<\/p>\n<p>James<\/p>\n<p>https:\/\/wordpress.org\/plugins\/stockists-manager\/<\/p>\n","protected":false},"template":"","class_list":["post-5653334","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5653334","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\/5653334\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5653334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}