The wordpress database error was caused by this wordpress plugin Google sitemaps 2.7.1. Thanks to Azmeen for informing me this wordpress database error at Wordpress Trac.

It seems that I am not the only one experiencing it. Well, you will not have the same problem if you are still below the current new version of Wordpress 2.3. I will talk about the wordpress 2.3 upgrade but for now, it is good to know that the current version of Google Sitemaps generator 3 is available for download here. The new name is under Google XML sitemaps 3.0. Let say thanks to Arne Brachhold. Thanks Arne

What is this.. I just have my new theme and upgraded every plugins to the latest one and what do I get? All the error codes after every comment and even doing this posting. The comment did went through. The post is published but why the error?? I am still puzzle. This blog is now powered by Wordpress 2.3. Is it because of that? I do not think so.

Here the error code.

WordPress database error: [Table 'pjoneh_pj.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