• I just switched servers and now the searcheverything plugin is throwing a SQL error when I attempt to search from the admin panel. I’ve found references to this in a couple of other posts and I think it has something to do with the wp_posts table alias. Here the 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 '(wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts' at line 1]
    SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships AS trel ON (wp_posts.ID = trel.object_id) LEFT JOIN wp_term_taxonomy AS ttax ON ( ( ttax.taxonomy = 'category' ) AND trel.term_taxonomy_id = ttax.term_taxonomy_id) LEFT JOIN wp_terms AS tter ON (ttax.term_id = tter.term_id) LEFT JOIN wp_comments AS c ON ( comment_post_ID = ID ) WHERE 1=1 AND (((wp_posts.post_title LIKE '%oregano%') OR (wp_posts.post_content LIKE '%oregano%'))) AND wp_posts.(wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private') OR (
  • The topic ‘[ searcheverything ] – Getting MySQL error on admin post search’ is closed to new replies.