WordPress.org

Forums

Category db table error when trying to publish post... (1 post)

  1. williscool
    Member
    Posted 7 years ago #

    when ever I try to publish a post to the blog I get this error

    WordPress database error: [Table '**********.wpUp1_post2cat' doesn't exist]
    SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM <code>wpUp1_posts</code> p LEFT JOIN <code>wpUp1_post2cat</code> pc ON p.ID = pc.post_id LEFT JOIN <code>wpUp1_categories</code> c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID
    
    WordPress database error: [Table '*****.wpUp1_post2cat' doesn't exist]
    SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM <code>wpUp1_posts</code> p LEFT JOIN <code>wpUp1_post2cat</code> pc ON p.ID = pc.post_id LEFT JOIN <code>wpUp1_categories</code> c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID

    and the post shows up in the manage section of the backend as if the post had only been saved and not published. It also does not show up on the blog :(

    I know its got to do with categories portion of the database structure changing but I've got no clue where to look.

    anyone got any Ideas?

Topic Closed

This topic has been closed to new replies.

About this Topic