Apologies guys!

I just did a WordPress upgrade (2.3) and I am experiencing some serious database error. I reckon you will face the same error too when you browse through the Categories… :(

Initially, I thought it was some tables were dropped during the upgrade or a database error is occurring at the hardware-level. After some checks, it looks very much like the later. I did a database restore and the error still persist.

So, I did a search and it looks like others had experienced the same problem too. Currently, the help I have gone through has advised me to deactivate my Google Sitemap plugin, but this doesn’t seem to work.

I am still searching for a solution… so please bear with me while I fix this.

UPDATES

4:30pm - It looks like I will have to deactivate and reactivate the plugin one by one to find the culprit. Gee…this is quite an ordeal.

4:45pm - I just found a list of incompatible plugins here! I am going through the list to pin-point plugins that are not compatible with this WordPress 2.3

5:000pm - I have deactivated all “suspect” plugins and I am reactivating them. Feel like banging my head on the wall…haha :P

5:03pm -Need to seek new solutions.

5:30pm - According to this post by Ryan Boren, “post2cat, and link2cat tables were dropped and replaced by three new tables. Plugins that reference the old tables will break.”

6:42pm -After going through countless of blogs and forums, I have found my “bug”:

<?php $myvar = $wp_query->query_vars['cat']; ?>

It appears to be that the method is querying the wrong table and wrong field name.

Problem fixed! :)