TechCounter - TechNews, Money & SEO

If you are getting a database error like this after upgrading to WordPress 2.3

WordPress database error: [Table ‘yourdb.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 /homepages/18/yourdb/htdocs/wp-includes/wp-db.php:160) in /homepages/18/yourdb/htdocs/wp-comments-post.php on line 67

Warning: Cannot modify header information - headers already sent by (output started at /homepages/18/yourdb/htdocs/wp-includes/wp-db.php:160) in /homepages/18/yourdb/htdocs/wp-comments-post.php on line 68

Warning: Cannot modify header information - headers already sent by (output started at /homepages/18/yourdb/htdocs/wp-includes/wp-db.php:160) in /homepages/18/yourdb/htdocs/wp-comments-post.php on line 69

Warning: Cannot modify header information - headers already sent by (output started at /homepages/18/yourdb/htdocs/wp-includes/wp-db.php:160) in /homepages/18/yourdb/htdocs/wp-includes/pluggable.php on line 391

The cause of these database errors where wp_post2cat does not exist is due to a single plugin which is not compatible with WordPress 2.3

Google Sitemaps Generator. I had Google Sitemaps generator 2.7.1. You NEED to upgrade to the new version of Google Sitemaps Generator

Download Google XML Sitemaps version 3.0.1

This plugin will create a Google sitemaps compliant XML-Sitemap of your WordPress blog. It supports all of the WordPress generated pages as well as custom ones. Everytime you edit or create a post, your sitemap will be updated and all major search engines which support the sitemap protocol like ASk.com, Google, MSN Search and YAHOO are notified about the update.

Installation

1. Upload the full directory into your wp-content/plugins directory
2. Make your blog directory writable OR create two files named sitemap.xml and sitemap.xml.gz and make them writable via CHMOD. In most cases, your blog directory is already writable so you don’t need to do anything.
3. Double make sure that your blog directory is writable or two writable files named sitemap.xml and sitemap.xml.gz exist!
4. Activate it in the Plugin options
5. Edit or publish a post or click on Rebuild Sitemap on the Sitemap Administration Interface in the menu under Options -> XML Sitemap

Popularity: 21% [?]