Support » Fixing WordPress » WP 2.1 Manage Posts (Browse by Category) Error

  • Hi,

    Have had WP 2.1 up and running for 3 weeks now with over 200+ posts and multiple categories. Now that things are getting a little difficult to manage, I thought it was time to use the Browse By Category drop-down menu in the admin.

    However, when I go to select a category to browse by from WP Admin -> Manage Posts -> Browse By Category, I get the following error:

    WordPress database error: [Unknown column 'category_id' in 'where clause']
    SELECT wpsu_posts.* FROM wpsu_posts WHERE 1=1 AND
    category_id IN (29) AND (post_type = 'post' AND
    (post_status = 'publish' OR post_status = 'future' OR
    post_status = 'draft' OR post_status = 'private'))
    GROUP BY wpsu_posts.ID ORDER BY post_date DESC

    The <wpsu_posts> database doesn’t have a category_id, but it has a <post_category> field. However, WP doesn’t actually use this field as it manages things through <wpsu_post2cat> so I’m not sure why that is even in there. Also, its a little odd that there is a WHERE 1=1 condition in that statement which is a little crazy.

    Please help!

    Thanks in advance.


  • The topic ‘WP 2.1 Manage Posts (Browse by Category) Error’ is closed to new replies.