Title: Getting WordPress Database Error in SQL syntax with Empty Searches
Last modified: August 21, 2016

---

# Getting WordPress Database Error in SQL syntax with Empty Searches

 *  [glinch](https://wordpress.org/support/users/glinch/)
 * (@glinch)
 * [12 years ago](https://wordpress.org/support/topic/getting-wordpress-database-error-in-sql-syntax-with-empty-searches/)
 * Hi,
 * As per the title, I have checked the error log of my site and Im receiving the
   following error when a user performs an empty search.
 * `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_11_posts.ID NOT IN ( 24,34,32 )) AND wp_11_posts.post_type IN ('pos' 
   at line 1 for query SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_11_posts.* FROM wp_11_posts
   LEFT JOIN wp_11_term_relationships AS trel ON (wp_11_posts.ID = trel.object_id)
   LEFT JOIN wp_11_term_taxonomy AS ttax ON ( ( ttax.taxonomy = 'category' OR ttax.
   taxonomy = 'post_tag' OR ttax.taxonomy = 'post_format' OR ttax.taxonomy = 'tax_prac_areas')
   AND trel.term_taxonomy_id = ttax.term_taxonomy_id) LEFT JOIN wp_11_terms AS tter
   ON (ttax.term_id = tter.term_id) LEFT JOIN wp_11_postmeta AS m ON (wp_11_posts.
   ID = m.post_id) WHERE 1=1 AND ( ( ((())) AND (wp_11_posts.ID NOT IN ( 24,34,32))
   AND wp_11_posts.post_type IN ('post', 'page', 'attachment', 'csk_practice', '
   csk_case_study', 'csk_testimonial') AND (wp_11_posts.post_status = 'publish' 
   OR wp_11_posts.post_status = 'private')) AND post_type != 'revision') AND post_status!
   = 'future' ORDER BY wp_11_posts.post_title LIKE '% %' DESC, wp_11_posts.post_date
   DESC LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts,
   WP_Query->query, WP_Query->get_posts`
 * Any advice would be great.
 * Cheers for putting together a great plugin.
 * Noel
 * [https://wordpress.org/plugins/search-everything/](https://wordpress.org/plugins/search-everything/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [PetraP](https://wordpress.org/support/users/petrap/)
 * (@petrap)
 * [12 years ago](https://wordpress.org/support/topic/getting-wordpress-database-error-in-sql-syntax-with-empty-searches/#post-4961107)
 * Hey Noel,
 * thanks for the heads up, we would definitely like to take a closer look at this
   error. Would you be so kind and give us a link to your blog? Also your WP version
   and a list of your other plugins, if possible?
 * Looking forward to your reply,
    Petra
 *  Thread Starter [glinch](https://wordpress.org/support/users/glinch/)
 * (@glinch)
 * [12 years ago](https://wordpress.org/support/topic/getting-wordpress-database-error-in-sql-syntax-with-empty-searches/#post-4961115)
 * Hi Petra,
 * No problem at all. The sites in development at the moment so i couldn’t actually
   post you a link.
 * Multisite installation, WP Version is 3.9.1
 * As its only in development I’m not using that many plugins: Search Everything,
   Advanced Custom Fields and Yoast SEO.
 * Have disabled the search everything plugin and the error disappears, reinstall
   and it shows up again. Although the error shows up in the logs, the search functionality
   still works.
 * Any other info needed please get in touch.
 * Cheers
 * Noel

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Getting WordPress Database Error in SQL syntax with Empty Searches’ 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/)

 * 2 replies
 * 2 participants
 * Last reply from: [glinch](https://wordpress.org/support/users/glinch/)
 * Last activity: [12 years ago](https://wordpress.org/support/topic/getting-wordpress-database-error-in-sql-syntax-with-empty-searches/#post-4961115)
 * Status: not resolved