Title: database error when searching for ” “
Last modified: August 18, 2016

---

# database error when searching for ” “

 *  [ko0pa](https://wordpress.org/support/users/ko0pa/)
 * (@ko0pa)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-error-when-searching-for/)
 * Hi
 * I always get the following WordPress database error when searching for ” ” ( 
   a whitespace ):
 * > WordPress database error:
   > 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 (post_type = ‘post’ AND (post_status = ‘publish’ OR post_]
   > 
   > SELECT SQL_CALC_FOUND_ROWS *_posts.* FROM *_posts WHERE 1=1 AND () AND (post_type
   > = ‘post’ AND (post_status = ‘publish’ OR post_status = ‘private’)) ORDER BY
   > post_date DESC LIMIT 0, 10
 * It only appears when searching for a space or some special symbols. I’ve seen
   this error on some other WP 2.1 blogs, too. BTW: This is a great trick to find
   out how the admin set the database-prefix ( i replaced my prefix with * ).
 * I have “Search Everything 2.6” installed, but the error still appears when i’ve
   disabled the plugin.
 * Does anyone know why I see this error and how to fix it?

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

 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-error-when-searching-for/#post-523263)
 * I’ve tried 3 differing blogs and can’t reproduce this. I just get the old:
    “
   Oh no! You’re looking for something which just isn’t here! ”
 *  Thread Starter [ko0pa](https://wordpress.org/support/users/ko0pa/)
 * (@ko0pa)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-error-when-searching-for/#post-523456)
 * These blogs are affected, too:
 * [http://www.usefulidiocy.com](http://www.usefulidiocy.com) (please search for”“)
   
   [http://gamelog.maxxed.de/?s=+](http://gamelog.maxxed.de/?s=+) (german) [http://blog.jazzle.co.uk/?s=+&searchsubmit=Find+%C2%BB](http://blog.jazzle.co.uk/?s=+&searchsubmit=Find+%C2%BB)
 *  [spot](https://wordpress.org/support/users/spot/)
 * (@spot)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-error-when-searching-for/#post-523515)
 * i experience exactly the same problem on my blog: [http://www.onoff.ch](http://www.onoff.ch)–
   just type in for example ‘blackman’ (with the single quotation marks) -> error
   message. if i type in blackman without it -> no error. strangely enough that 
   the search engine doesn’t find anything because the word exists.

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

The topic ‘database error when searching for ” “’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [whitespace](https://wordpress.org/support/topic-tag/whitespace/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [spot](https://wordpress.org/support/users/spot/)
 * Last activity: [19 years, 3 months ago](https://wordpress.org/support/topic/database-error-when-searching-for/#post-523515)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics