• Hello,
    I renecently upgraded WP and I am now getting a DB error when using the post search feature in the admin area. here is the error:

    I am using version 4.1.2

    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 ‘-1’ at line 19]
    SELECT posts.*, CASE WHEN posts.post_title REGEXP ‘all’ THEN 1 ELSE 0 END AS keyword_in_title, MATCH ( posts.post_title, posts.post_content ) AGAINST ( ‘all’ ) AS mysql_score FROM terry_posts as posts WHERE posts.post_date_gmt <= ‘2007-08-29 22:31:00’ AND ( posts.post_password = ” ) AND ( posts.post_status = ‘static’ OR posts.post_status = ‘publish’ ) AND ( posts.post_title REGEXP ‘all’ OR posts.post_content REGEXP ‘all’ ) ORDER BY keyword_in_title DESC, mysql_score DESC, posts.post_date DESC LIMIT 0, -1

  • The topic ‘Admin area post search error.’ is closed to new replies.