I recently upgraded my hosted Wordpress from version 2.2 to 2.3.1. The upgradation process went smoothly but something strange happened when I tried to log into the administration dashboard. When I logged in, the page showed me a message stating that my database was old and I needed to upgrade it. I did as it suggested and the dashboard came into picture as usual. All till this point seemed fine, until I did the following things:

• Tried to add a new category
• Tried to edit a post
• Tried to comment from the blog post page

When I tried to do the above things I was shown a big fat error message which cried out,

WordPress database error: [Table ‘wordpress.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

I managed to resolve this error in some time but those few moments were somewhat shocking. If you are getting the same error, the solution is quite easy. At first Read the rest of this entry »