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

WordPress Trac wp-trac at lists.automattic.com
Tue Dec 16 10:47:16 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              |   Resolution:           
 Keywords:  reporter-feedback  |  
-------------------------------+--------------------------------------------
Comment (by mlebkowski):

 The inherit-type items are some kind of attachments. But I dont think
 that`s relevant -- it`s another topic/issue. Maybe there were inserted in
 some strange way, dunno (it was back in february, and the second one in
 september '07). There also a lot of items with post-type=inherit and post-
 parent!=0, but those are from "before 2.5 wordpress".

 After some sniffing:
 {{{
 mysql> select count(*), max(post_date), group_concat(distinct post_status)
     -> from wp_posts where post_parent != 0 and post_type = 'post';
 +----------+---------------------+------------------------------------+
 | count(*) | max(post_date)      | group_concat(distinct post_status) |
 +----------+---------------------+------------------------------------+
 |      158 | 2008-04-14 10:08:19 | inherit                            |
 +----------+---------------------+------------------------------------+
 1 row in set (0.01 sec)
 }}}

 Looks like all of these attachments are from wordpress 2.2 or 2.3.

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


More information about the wp-trac mailing list