I just upgraded to WordPress 2.3.1 (from 2.1) and everything went smoothly except for my comments function. I uploaded all files, I then logged into the Dashboard, and WordPress notified me that I needed to do a database upgrade. I clicked the link to do a database upgrade and it said that everything was successful.
Now, whenever ANYONE attempts to post a comment, the error message below is displayed. The comment actually does get posted, but the user is sent to this page with only the error message shown. How can I resolve this problem?
Begin Error Message:
WordPress database error: [Table 'dbname.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM
wp_posts p LEFT JOIN
wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN
wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID
Warning: Cannot modify header information - headers already sent by (output started at /homepages/19/d87363525/htdocs/Site.WordPress2/wp-includes/wp-db.php:160) in /homepages/19/d87363525/htdocs/Site.WordPress2/wp-includes/pluggable.php on line 391