Support » Plugins » [Plugin: Search Everything] Incompatibility with WP Recent Posts Widget

  • I reported this for version 2.4 and 2.5, but there was no followup and it’s still an issue.

    On WordPress 2.5.1, if you have your WP Recent Posts widget (stock) activated on your WP Sidebar and you search, all of the results pages return the following code:
    [blockquote]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 ( LIKE ‘%search-everything%’) O’ 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 ( LIKE ‘%search-everything%’) OR ( c.comment_post_ID = wp_posts.ID AND c.comment_approved = ‘1’ AND c.comment_content LIKE ‘%search everything%’) ORDER BY wp_posts.post_date DESC LIMIT 0, 5[/blockquote]

    Any ideas?

Viewing 5 replies - 1 through 5 (of 5 total)
  • I’m still waiting for the obvious to jump out at me.

    Okay, Dan … tell me what problem is, then? Am I that stupid? I might be — I’m legitimately asking.

    Sorry, I looked again. I’m not gettin’ it. Since you wrote this thing, I thought you might have some insight. *shrug* And it may be something something stupid or obvious I’m missng, but I really don’t get it. I’ve reported this for three versions with no response. So, seriously … What’s so obvious?

    Do it. I’ll take my lumps, whatever. I’m good like that.

    I’m waiting for the resolution to this issue to jump out at me. I’m still stuck…

    I couldn’t figure it out either, but I switched to the Search Unleashed plugin and everything is working fine now.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: Search Everything] Incompatibility with WP Recent Posts Widget’ is closed to new replies.