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?