Title: Database error
Last modified: December 12, 2020

---

# Database error

 *  [ashim221](https://wordpress.org/support/users/ashim221/)
 * (@ashim221)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/database-error-325/)
 * Hi there,
 * I am keeping on getting this 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 ‘) AND wp_posts.post_status
   = ‘publish’ AND ( wp_posts.ID NOT IN (…’ at line 7 Error code 1064
 * WC_Onsale_Page_Widget_Layered_Nav->get_filtered_term_product_counts()
    wp-content/
   plugins/on-sale-page-for-woocommerce/public/class-wc-onsale-page-widget-layered-
   nav.php:389 WC_Onsale_Page_Widget_Layered_Nav->layered_nav_list() wp-content/
   plugins/on-sale-page-for-woocommerce/public/class-wc-onsale-page-widget-layered-
   nav.php:405 WC_Onsale_Page_Widget_Layered_Nav->widget() wp-content/plugins/on-
   sale-page-for-woocommerce/public/class-wc-onsale-page-widget-layered-nav.php:
   167 WP_Widget->display_callback() wp-includes/class-wp-widget.php:380 dynamic_sidebar(‘
   shop-sidebar’) wp-includes/widgets.php:823 load_template(‘wp-content/themes/flatsome/
   woocommerce/layouts/category.php’) wp-includes/template.php:732 wc_get_template_part()
   wp-content/plugins/woocommerce/includes/wc-core-functions.php:284 wc_get_template()
   wp-content/plugins/woocommerce/includes/wc-core-functions.php:345

The topic ‘Database error’ is closed to new replies.

 * ![](https://ps.w.org/on-sale-page-for-woocommerce/assets/icon-256x256.png?rev
   =3511666)
 * [OnSale Page for WooCommerce](https://wordpress.org/plugins/on-sale-page-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/on-sale-page-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/on-sale-page-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/on-sale-page-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/on-sale-page-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/on-sale-page-for-woocommerce/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [ashim221](https://wordpress.org/support/users/ashim221/)
 * Last activity: [5 years, 6 months ago](https://wordpress.org/support/topic/database-error-325/)
 * Status: not resolved