WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] post2cat errors after 2.3 update

[Resolved] 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?

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Resolved] post2cat errors after 2.3 update’ is closed to new replies.