WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] post2cat errors after 2.3 update (4 posts)

  1. alexleonard
    Member
    Posted 6 years ago #

    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?

  2. alexleonard
    Member
    Posted 6 years ago #

    Also, I've noticed that my plugins page seems to not be showing that there are updates available to some of the plugins that I have installed (even though I know there are updates available and at first it was showing these available updates).

  3. Jeremy Clark
    Moderator
    Posted 6 years ago #

    You didn't happen to see the sticky on the front page of this forum about this very topic.
    http://wordpress.org/support/topic/135564?replies=70

  4. alexleonard
    Member
    Posted 6 years ago #

    Extremely sorry. My bad.

    I'm usually quite good at searching around for answers but I guess I just panicked as this is my business website.

    So, can I delete my question?

Topic Closed

This topic has been closed to new replies.

About this Topic