How To Solve Worpress wp_post2cat doesn’t exist Problems

Date December 17, 2007

Wordpress Logo

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_ID

Warning: 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.

Subscribe to Daily Moolah by RSS

Related Posts

  • 5 WordPress Plugins That Make Life Easier
  • WordPress 2.3 Release Candidate 1
  • I’m Having Trouble With MySQL Databases
  • Wordpress 2.2.3 Security Update
  • See What Other People Are Saying

    7 Responses to “How To Solve Worpress wp_post2cat doesn’t exist Problems”

    1. James Mann said:

      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.

    2. Bruce said:

      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

    3. Flannel said:

      Fantastic! Thank you for finding out what the problem was.

    4. Pubard said:

      Same problem with Ultimate Tag Warrior. Update needed.

    5. Todd Carpenter said:

      Thank you so much. You just cured a severe headache.

    6. Free Blog Templates said:

      Yep, the sitemap plugin was the culprit. You saved me at least 30 minutes of troubleshooting! Much appreciated.

      ~David

    7. Dr T said:

      thanks,

      fixed my problem, need to update the google sitemap plugin

    Leave a Reply

    XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>