WordPress.org

Ready to get started?Download WordPress

Forums

"Recent Posts" Widget Fails on Search (2 posts)

  1. 112502
    Member
    Posted 5 years ago #

    In our setup, we have the "Recent Posts" widget coming immediate after Search and Navigation, and whenever we do a Search, the spot where "Recent Posts" sits returns:

    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 ( tter.name LIKE '%bugs%') OR ( c.comment' 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 = 'post_tag' ) 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.(wp_posts.post_status = 'publish') OR ( tter.name LIKE '%bugs%') OR ( c.comment_post_ID = wp_posts.ID AND c.comment_approved = '1' AND c.comment_content LIKE '%bugs%') ORDER BY wp_posts.post_date DESC LIMIT 0, 5

    Any ideas? Nothing has changed Server side except the 2.5 & 2.5.1 upgrades.

  2. 112502
    Member
    Posted 5 years ago #

    Nevermind ... issue with the Search Everything plugin ... if I disable the plugin, things work famously.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.