Ready to get started?Download WordPress


[Plugin: Search Everything] Incompatibility with WP Recent Posts Widget (6 posts)

  1. 112502
    Posted 6 years ago #

    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 ( tter.name 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 ( tter.name 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?


  2. Dan Cameron
    Posted 6 years ago #

    I'm still waiting for the obvious to jump out at me.

  3. 112502
    Posted 6 years ago #

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

  4. 112502
    Posted 6 years ago #

    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.

  5. Dan Cameron
    Posted 6 years ago #

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

  6. L B
    Posted 5 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic