[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