Error on my archive page

  • wagawaga

    (@wagawaga)


    16 years, 7 months ago

    Hi,
    I’m using wordpress 2.2.2 and plug in extended live archive for my archive page. When open the page, this error will come up aboe my header.

    WordPress database error: [Not unique table/alias: ‘wp_post2cat’]
    SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.*, wp_sticky.sticky_status FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_post2cat ON wp_post2cat.post_id = wp_posts.ID LEFT JOIN wp_sticky ON wp_sticky.sticky_post_id = wp_posts.ID WHERE 1=1 AND wp_post2cat.category_id IN (3) AND (post_type = ‘post’ AND (post_status = ‘publish’ OR post_status = ‘private’)) AND wp_post2cat.category_id NOT IN (1) GROUP BY wp_posts.ID ORDER BY (wp_sticky.sticky_status = 2 AND wp_sticky.sticky_status IS NOT NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%Y-%m-%d’) DESC, (wp_sticky.sticky_status = 1 AND wp_sticky.sticky_status IS NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%T’) DESC LIMIT 0, 10

    Why and how?

  • The topic ‘Error on my archive page’ is closed to new replies.