2.1 Database Error

  • mwselz

    (@mwselz)


    17 years, 3 months ago

    Just installed 2.1 on my http://www.mattselznick.com site, and this database error is listed at the very top of my page:


    WordPress database error: [Unknown column 'wp_post2cat.category_id' in 'on clause']
    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_catt_visibility ON (wp_post2cat.category_id = wp_catt_visibility.catt_ID) WHERE 1=1 AND (post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')) AND (post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')) ORDER BY post_date DESC LIMIT 0, 5

    Could this be a plugin error? Any ideas? Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter mwselz

    (@mwselz)

    17 years, 3 months ago

    Update: On more digging, my aforementioned problems seems to have to do with Pages on my site… links to pages result in a 404, and this is the error on the admin section’s “page management” page:


    WordPress database error: [Unknown column 'wp_post2cat.category_id' in 'on clause']
    SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_catt_visibility ON (wp_post2cat.category_id = wp_catt_visibility.catt_ID) WHERE 1=1 AND (post_type = 'page' AND (post_status = 'publish' OR post_status = 'future' OR post_status = 'draft' OR post_status = 'private')) AND (post_type = 'page' AND (post_status = 'publish' OR post_status = 'future' OR post_status = 'draft' OR post_status = 'private')) ORDER BY menu_order DESC

    This is bad..!

    Thread Starter mwselz

    (@mwselz)

    17 years, 3 months ago

    Okay, sorry for my panicking. Upgrading the plugin “Category Visibility” (http://ryowebsite.com/?p=46) fixed it. Now I’m gonna go through and upgrade all my plugins…!

    25kgbox

    (@25kgbox)

    17 years, 1 month ago

    i am having a similar proble, but i do not have the Category Visibility plugin.

    pipedreamergrey

    (@pipedreamergrey)

    16 years, 11 months ago

    This problem can also be caused by the Side Blog plugin.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘2.1 Database Error’ is closed to new replies.

Tags