[wp-trac] [WordPress Trac] #5044: WordPress database error

WordPress Trac wp-trac at lists.automattic.com
Sat Sep 22 05:52:37 GMT 2007


#5044: WordPress database error
---------------------+------------------------------------------------------
 Reporter:  mann3r   |       Owner:  anonymous
     Type:  defect   |      Status:  new      
 Priority:  normal   |   Milestone:  2.3      
Component:  General  |     Version:  2.3      
 Severity:  normal   |    Keywords:           
---------------------+------------------------------------------------------
 when moderating comment, it always go to this
 WordPress database error: [Table 'mydatabase.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

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

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

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

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

 but trying to refresh the browser yield to a success with no error.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/5044>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list