How To Solve Worpress wp_post2cat doesn’t exist Problems
December 17, 2007

After upgrading to Wordpress 2.3.1 I kept getting this rather perplexing and frustrating problem cropping up whenever I tried to post or modify my existing blog articles. If you have been facing problems regarding a ‘wp_post2cat doesn’t exist’ error right after trying to publish a post or when commenting, here is a quick solution to fix your woes.
The problem is simply a nuisance because all comments and posts are still published perfectly, but it certainly creates usability issues for your blog visitors. Here’s what it looked like so that other bloggers may find this tip of some assistance:
WordPress database error: [Table ‘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_IDWarning: Cannot modify header information - headers already sent by (output started at /public_html/wp-includes/wp-db.php:160) in
/public_html/wp-includes/pluggable.php on line 391
After looking through the aforementioned files and getting thoroughly confused, I realized that the Google Sitemaps plugin was the offending party. Simply disabling the Google Sitemaps plugin will fix this issue and get you started on trouble-free blogging again.

Posted in
A Toronto Based Serial Entrepreneur and Internet Marketer


December 18th, 2007 at 10:47 am
I have been trying to figure out what I did to cause this problem and here it wasn’t even me. Well I’m some glad to hear that.
I will go ahead and disable the Google sitemap plugin and see what happens.
thanks for doing the leg work on this one.
December 18th, 2007 at 9:04 pm
There are actually several plugins that can cause this issue. I actually had several that I had to find. I just disabled one at atime until I found all the culprits.
There is an updated sitemap plugin that will allow you to still use this excellent plugin with 2.3.1
December 20th, 2007 at 4:08 am
Fantastic! Thank you for finding out what the problem was.
January 3rd, 2008 at 7:40 am
Same problem with Ultimate Tag Warrior. Update needed.
January 16th, 2008 at 4:26 pm
Thank you so much. You just cured a severe headache.
April 2nd, 2008 at 8:13 am
Yep, the sitemap plugin was the culprit. You saved me at least 30 minutes of troubleshooting! Much appreciated.
~David
August 24th, 2008 at 9:19 am
thanks,
fixed my problem, need to update the google sitemap plugin