Solution for 2.3 database errors / wp_post2cat does not exist
-
If you are getting a database error like this:
WordPress database error: [Table ‘wp_post2cat’ doesn’t exist]
SELECT p2c.category_id AS cat_id, COUNT(p2c.rel_id) AS numposts, UNIX_TIMESTAMP(max(posts.post_date_gmt)) + ‘8’ AS last_post_date, UNIX_TIMESTAMP(max(posts.post_date_gmt)) AS last_post_date_gmt FROM wp_post2cat p2c INNER JOIN wp_posts posts ON p2c.post_id=posts.id WHERE 1 = 1 AND posts.post_type = ‘post’ AND posts.post_status = ‘publish’ AND posts.post_date_gmt <= ‘2007-09-19 12:08:25’ GROUP BY p2c.category_id ORDER BY numposts DESCor like this:
WordPress database error: [Table ‘wordpress.wp_post2cat’ doesn’t exist]
SELECT c.cat_name FROM wp_post2cat p2c INNER JOIN wp_categories c ON p2c.category_id = c.cat_id WHERE p2c.post_id = 218or like this:
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_IDor any other database error which contains wp_post2cat or wp_categories, you are using a plugin or theme which is not compatible with WordPress 2.3.
Example plugins which don’t work:
- Google Sitemaps Generator older than 3.0 (Download new version here)
- Posts by Author plugin
- Ultimate Tag Warrior
It could also be that your theme is causing this error:
- K2 Theme (See this thread)
Please double check before posting that you don’t use any incompatible plugins. A list of plugins that work and which won’t work can be found at the WordPress Codex.
- The topic ‘Solution for 2.3 database errors / wp_post2cat does not exist’ is closed to new replies.