Just upgraded to WordPress 2.3, but encountered a couple of problems even after running the upgrade.php file from my browser:

1.  Database Error 

When I tried to save my post the following error appears:

WordPress database error: [Table ‘blog.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 /home/content/m/a/r/markteh/html/blog/wp-includes/wp-db.php:160) in /home/content/m/a/r/milo/html/blog/wp-includes/pluggable.php on line 390

However, the post did saved normally.

2.  Adsense Deluxe plugin error

Adsense deluxe plugin is supposed to limit the number of Adsense Ads in a page to 3 as in the TOS of Googles Adsense. However, since upgrading, the 4th Ad doesn’t disappear smoothly but shows up as an error, “The page could not be found”. Although the 5th Ad does disappear correctly. Wonder if this is a compatability problem.

Inspite of all these I did not experience any lost of data.

I must admit I am a bit too gungho as I upgraded without any backups. I wonder if its the first problem that causes the second. If I can’t solve the problems over the next few days, I might just reinstall WordPress all over again.

Wish me luck.

13th October 2007

Problems solved. Instead of putting in a separate post I thought it would be better to edit this post and insert the conclusion here.

Problem no. 1 resolved – I deactivated all plugins and then reactivate them one at a time and test out each one by editing and saving a post. The culprit was found to be related to the Google Sitemap plugin. The wp_post2cat database table is no longer needed in WP2.3, therefore was automatically removed during upgrade. Problem solved after it was deactivated. A WP2.3 compatible version is available for download.

Problem no. 2 resolved – The erratic Ad was removed and repositioned somewhere else. Wala … problem somehow disappeared.

 I’m back in business.