Wordpress 2.3

Problem:

WordPress database error: [Table ‘mseeger_wordpress.wp_post2cat' doesn't exist]SELECT cat_ID AS ID, MAX 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 

Solution:

CREATE TABLE wp_post2cat (rel_id int(11) NOT NULL auto_increment,post_id int(11) NOT NULL default ‘0',category_id int(11) NOT NULL default ‘0',PRIMARY KEY (rel_id),KEY post_id (post_id,category_id)) TYPE=MyISAM;

UPDATE: Maybe just updating to the latest version of the google sitemap plugin could have helped… don't know :)