Switching Themes – Database error

  • 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

Viewing 2 replies - 1 through 2 (of 2 total)

  • Category Visibility plugin not activated?

    Thread Starter southbeach030

    (@southbeach030)

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Switching Themes – Database error’ is closed to new replies.