• 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)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘database error when searching for ” “’ is closed to new replies.