Anyone have any idea what happened? I installed a new theme...and some of my categories disappeared so I re-added them and went back to put posts in the categories instead of uncategorized and got this error when I tried to edit the category. WordPress database error: [Table 'amiecn14_wrdp1.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 'amiecn14_wrdp1.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
Did you recently upgrade to WP 2.3.1? If so, you'll need to recreate wp_post2cat and possibly wp_categories. Do you have a database backup?
make sure you run the upgrade script. and if you install ultimate tag worrior, uninstall it. -cypher.
I didn't upgrade...its a new installation (as of about a month ago) and I didn't have ultimate tag warrior but I had a few others. I deleted almost all of them, but the problem remains. I was told that the database would have to be repaired, as it would not resolve itself.
why delete all the plug-in? Just upgrade the plug-in to its new compatible version, like sitemap plug-in. try it
first you must make sure all plugins and theme you are using is compatible with version 2.3.1. version 2.3.1 does not use wp_post2cat and wp_categories table anymore. that is why your server gives you that error. -cypher.
ideas_man fixed it for me...apparently it had nothing to do with the WP version or the database...it was a coding issue. thank you!