Support » Fixing WordPress » No Results For Search

  • Since I upgraded to 2.1 words I enter in my search bar yield no results. Instead I get this:

    WordPress database error: [Column ‘category_id’ in where clause is ambiguous]
    SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.* FROM wp_posts LEFT JOIN wp_post2tag p2t on wp_posts.ID = p2t.post_id INNER JOIN wp_tags on p2t.tag_id = wp_tags.tag_id LEFT JOIN wp_post2cat ec3_post2cat ON ec3_post2cat.post_id=id LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id AND ec3_sch.end>=’2007-01-30 00:00:00′ LEFT JOIN wp_post2cat ON ( wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND (((post_title LIKE ‘%moshu%’) OR (post_content LIKE ‘%moshu%’))) AND (post_type = ‘post’ AND (post_status = ‘publish’ OR post_status = ‘private’)) OR wp_tags.tag like ‘%moshu%’ AND category_id NOT IN (14) AND (ec3_sch.post_id IS NOT NULL OR ec3_post2cat.category_id!=41) GROUP BY ID ORDER BY post_date DESC LIMIT 0, 6

    Is this a tag issue?


  • The topic ‘No Results For Search’ is closed to new replies.