Title: DBError
Last modified: April 26, 2017

---

# DBError

 *  [freya0](https://wordpress.org/support/users/freya0/)
 * (@freya0)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/dberror/)
 * Activated the plugin and got this on the plugin page in admin:
 *  [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 ‘)’ at line 4]
    SELECT
   count(posts.ID) as product_id FROM wp_posts as posts WHERE 1=1 AND posts.post_type
   =’product’ AND posts.post_status=’publish’ AND posts.ID NOT IN ()

 The topic ‘DBError’ is closed to new replies.

 * ![](https://ps.w.org/sales-trends-analysis-for-woocommerce/assets/icon-128x128.
   png?rev=1645562)
 * [Sales Trends Analysis for WooCommerce](https://wordpress.org/plugins/sales-trends-analysis-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/sales-trends-analysis-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/sales-trends-analysis-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/sales-trends-analysis-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/sales-trends-analysis-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/sales-trends-analysis-for-woocommerce/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [freya0](https://wordpress.org/support/users/freya0/)
 * Last activity: [9 years, 5 months ago](https://wordpress.org/support/topic/dberror/)
 * Status: not resolved