WordPress.org

Ready to get started?Download WordPress

Forums

Switching Themes - Database error (3 posts)

  1. SouthBeach030
    Member
    Posted 7 years ago #

    I was switching Themes, and I got this error:

    Anyone know where I should start looking to fix this problem?

    WordPress database error: [Not unique table/alias: 'wp_post2cat']
    SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON (wp_post2cat.category_id = wp_categories.cat_ID) LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_catt_visibility ON (wp_post2cat.category_id = wp_catt_visibility.catt_ID) WHERE 1=1 AND 0=1 AND (category_id = '0') AND post_date_gmt <= '2007-06-21 21:27:52' AND (post_status = 'publish' OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != 'attachment' AND ((wp_catt_visibility.front=1 AND wp_catt_visibility.cv_user_level<=10) OR post_status='static' OR wp_catt_visibility.catt_ID IS NULL) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 1

  2. MichaelH
    Member
    Posted 7 years ago #

    Category Visibility plugin not activated?

  3. SouthBeach030
    Member
    Posted 7 years ago #

    I actually solved the problem. It was two-fold.

    1) I had to update the Category Visibility plugin to 1.0e
    2) then I realized that the theme I spent 5 hours working on (porting the layout from the old one) was designed for WORDPRESS 2.1.X+ (I'm still on 2.0.X)

    I should have realized that sooner.

    Unrelated question: Does anyone know if someone is working on a similar plugin for Quoting Comments? The reason I haven't upgraded to 2.2.X yet is because I rely on the Quoter plugin, and it's not supported.

Topic Closed

This topic has been closed to new replies.

About this Topic