[wp-trac] [WordPress Trac] #8635: Invalid post count in dashboard

WordPress Trac wp-trac at lists.automattic.com
Tue Dec 16 10:22:30 GMT 2008


#8635: Invalid post count in dashboard
------------------------+---------------------------------------------------
 Reporter:  mlebkowski  |       Owner:  anonymous
     Type:  defect      |      Status:  new      
 Priority:  low         |   Milestone:  2.7.1    
Component:  General     |     Version:  2.7      
 Severity:  minor       |    Keywords:           
------------------------+---------------------------------------------------
 In dashboard (/wp-admin/edit.php) I see invalid posts count. It states
 that there are about 357 posts in total, while there`s only 180 published
 and 17 drafts. See attachment.

 Here are some SQL:

 {{{
 mysql> select count(*) from wp_posts where post_type = 'post' ;
 +----------+
 | count(*) |
 +----------+
 |      357 |
 +----------+
 1 row in set (0.00 sec)

 mysql> select count(*) from wp_posts where post_type = 'post' and
 post_parent = 0
     -> and post_status != 'inherit' -- there are two posts with inherit
 status... dunno
     -> ;
 +----------+
 | count(*) |
 +----------+
 |      197 |
 +----------+
 1 row in set (0.00 sec)

 }}}

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


More information about the wp-trac mailing list