WordPress.org

1. cent
   Member
   Posted 5 years ago #

   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

Topic Closed

This topic has been closed to new replies.