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.
Thanks in advance.