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.

Best,
Cent