Wordpress 2.3
Posted by marc, Tue Sep 25 12:49:28 UTC 2007
Problem:
UPDATE: Maybe just updating to the latest version of the google sitemap plugin could have helped... don't know :)
WordPress database error: [Table 'mseeger_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_IDSolution:
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 :)
