I just upgraded one of my websites (www.biostatistics.co.il)
to WP2.3 from WP2.2.1
using the automated wordpress upgrade plugin.
After publishing a new post, I go to a white page with the following errors:
WordPress database error: [Table 'biostatistics.wp_post2cat' doesn't exist]
SELECT YEAR(post_date) AS <code>year</code>, MONTH(post_date) AS <code>month</code>, category_id FROM wp_posts INNER JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE post_date > 0 AND ID = 38 ORDER By post_date DESC
WordPress database error: [Table 'biostatistics.wp_post2cat' doesn't exist]
SELECT DISTINCT YEAR(p.post_date) AS <code>year</code> FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id) WHERE p.post_date > 0 ORDER By p.post_date DESC
WordPress database error: [Table 'biostatistics.wp_post2cat' doesn't exist]
SELECT DISTINCT MONTH(p.post_date) AS <code>month</code> FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id ) WHERE YEAR(p.post_date) = 2007 AND p.post_date_gmt < '2007-10-04 23:14:31' ORDER By p.post_date DESC
WordPress database error: [Table 'biostatistics.wp_post2cat' doesn't exist]
SELECT DISTINCT MONTH(p.post_date) AS <code>month</code> FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id ) WHERE YEAR(p.post_date) = 2006 AND p.post_date_gmt < '2007-10-04 23:14:31' ORDER By p.post_date DESC
WordPress database error: [Table 'biostatistics.wp_categories' doesn't exist]
SELECT cat_ID, cat_name, category_nicename, category_parent FROM wp_categories c WHERE c.cat_ID > 0 ORDER BY c.cat_ID asc
WordPress database error: [Table 'biostatistics.wp_categories' doesn't exist]
SELECT c.cat_ID, COUNT(distinct p2c.post_id) AS cat_count FROM wp_categories c INNER JOIN wp_post2cat p2c ON (c.cat_ID = p2c.category_id) INNER JOIN wp_posts p ON (p.ID = p2c.post_id) WHERE p.post_status = 'publish' AND p.post_date_gmt < '2007-10-04 23:14:31' GROUP BY p2c.category_id
WordPress database error: [Table 'biostatistics.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM <code>wp_posts</code> p LEFT JOIN <code>wp_post2cat</code> pc ON p.ID = pc.post_id LEFT JOIN <code>wp_categories</code> c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_IDany Idea what to look for ?
Thanks.
