Title: [Plugin: Search Everything]  SQL Error in Search Everything
Last modified: August 20, 2016

---

# [Plugin: Search Everything] SQL Error in Search Everything

 *  [Scott (@scottsweb)](https://wordpress.org/support/users/scottsweb/)
 * (@scottsweb)
 * [14 years ago](https://wordpress.org/support/topic/sql-error-in-search-everything/)
 * I am experiencing some odd SQL errors from the search everything plugin. With
   WP_DEBUG turned on I get the following message:
 *     ```
       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 '))) AND wp_posts.post_type IN ('product') AND (wp_posts.post_status = 'publish'' at line 5]
       SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (60) ) ) AND ((())) AND wp_posts.post_type IN ('product') AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10
       ```
   
 * The SQL query is obviously being modified by search everything and the problem
   looks to be around `AND ((())) AND` which certainly does not look like a valid
   SQL query.
 * I am using custom post types and taxonomies and have search ‘all taxonomies’,‘
   categories’ and ‘authors’ enabled in the search everything settings.
 * Any pointers would be greatly appreciated.
 * [http://wordpress.org/extend/plugins/search-everything/](http://wordpress.org/extend/plugins/search-everything/)

The topic ‘[Plugin: Search Everything] SQL Error in Search Everything’ is closed
to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/search-everything_242529.svg)
 * [Search Everything](https://wordpress.org/plugins/search-everything/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/search-everything/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/search-everything/)
 * [Active Topics](https://wordpress.org/support/plugin/search-everything/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/search-everything/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/search-everything/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [Scott (@scottsweb)](https://wordpress.org/support/users/scottsweb/)
 * Last activity: [14 years ago](https://wordpress.org/support/topic/sql-error-in-search-everything/)
 * Status: not resolved