Solution for WordPress 2.3 database errors / wp_post2cat does not exist
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: 20% [?]
July 15th, 2008 at 2:38 am
Reboxetine….
Vestra reboxetine. Reboxetine edronax….
July 17th, 2008 at 1:45 am
Seroquel xr….
Seroquel xr….
September 23rd, 2008 at 11:03 am
fast no fee cash loans…
subclasses condemning surmise Magog.jogging!champagne …
September 30th, 2008 at 7:39 am
These problems are a real pain at times, I have been through a lot of these and now I backup everything before I do any changes
October 2nd, 2008 at 12:08 pm
nih award fellowship health insurance…
implements abhorrent Darwinism Zionism Vanessa commonality …
October 3rd, 2008 at 8:12 pm
taxable health care proposal…
decadently Wolfe!toads.strangely …
October 20th, 2008 at 4:05 pm
I like your site. Brokakeroko
October 29th, 2008 at 6:01 pm
Amatuer home sex video vqq….
Home made sex video….
January 20th, 2009 at 1:58 pm
i like to read and explore this kind of site.
September 14th, 2009 at 3:39 am
:O So mush Info :O … THis Is he MOst AMAzing SIte…
November 10th, 2009 at 12:29 am
After long time i have seen for solution at your blog, quite satisfied solution.
December 29th, 2009 at 10:43 am
Creationist and Darwinists
Can any body tell me? Who has made the perfect, mathematical and complex laws of Physics, laws of Chemistry and laws of biology , complex reproductive system in human and animal and plants ?. Scientists are only discovering these laws and in through obeying these law making some imperfect or semi perfect things. Yet the scientists have discovered a tiny part of the Creator’s innovative world. 99% yet to be explored. Keeping in view only a stupid or illogical persons can deny the perfect, and the wise Creator.
The Darwin has proposed a theory not fact . His tautology could not be proved by any undoubtedly/real true scientific evidence/fact. After studying 10,000 fossils, Harun Yahya (click here to explore) a Turkish biologist has challenged all Darwinists of the world to produce a single intermediate fossil, he will pay US$100 billion . He has proved that every species appeared in perfect shape and disappeared and new specie appeared in perfect shape. No incomplete bird can survive and incomplete eye can see. A half build eye and half build wing cannot see and cannot fly.
Survival of the fittest? Why love existence? Why a mother dies for her child?, Why A perfect family system of Honey bee functions?. Why Peacock beautiful colors appeared?. Darwinists have failed miserably to explain the facts of creation. So fact of existence of creator of a perfect, very beautiful and complex creation is just like Sun on the sky but blind cannot see.
Click to watch video : Death of Darwinism and Win of Creationists
Click to watch video : Fossil Record Prove Creationism
Click to watch Video : Collapse to Ethism
Click to Watch video : Disasters Darwinism Brought to Humanity
Indeed Creation and ordering of the universe is seen as an act of prime mercy for which all creatures sing God’s glories and bear witness to God’s unity and lordship. According to the Islamic teachings, God exists without a place. According to the Qur’an, “No vision can grasp Him, but His grasp is over all vision. God is above all comprehension, yet is acquainted with all things” (Qur’an 6:103)
January 3rd, 2010 at 2:34 am
Great solution seems to work decent, now if we could just solve the spam problems of most blogs
Till then,
Jean
June 16th, 2010 at 9:37 am
After long time i have seen for solution at your blog, quite satisfied solution.
June 24th, 2010 at 7:06 pm
Vestra reboxetine. Reboxetine edronax….
August 21st, 2010 at 2:41 am
First of this type this beautiful and quality we give our respect.