post2cat errors after 2.3 update

Hi there,

I have just updated my word press install to version 2.3 and while it is working there are some strange behaviours that didn’t occur before which I’d love to shed some light on.

When I go to save a post or a page I often get the following errors instead of being routed back to the Manage Posts page:

WordPress database error: [Table 'pa_wp.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

WordPress database error: [Table 'pa_wp.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 /home/virtualsites/pixelapes.com/httpdocs/wp-includes/wp-db.php:160) in /home/virtualsites/pixelapes.com/httpdocs/wp-includes/pluggable.php on line 390

In addition to this I have seen some of these errors pop up under the editor box when writing a post, such as:

WordPress database error: [Table 'pa_wp.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

Fortunately these errors don’t seem to actually be affecting posting at all and posts are still written correctly.

I went through the upgrade process as detailed in the codex and it all seemed to run fine, with wp-admin/upgrade.php encountering no errors.

Any thoughts?