[wp-hackers] phpmyadmin post count vs wordpress dashboard's own post count

[Haluk Karamete]

In phpmyadmin, I sorted the records by 'post_status' field just to see
what's out there to see 'other than' the 'draft'.
Top of the list was one single record with the post_status is
auto-draft which happens to be the last one and I have no idea how it
got there.

At the end of the migration routine, I ended up with 10222 posts and
only one of them is missing the title/body/etc...

How does it get there?


On Fri, Jun 22, 2012 at 10:44 AM, chris mccoy <chris at lod.com> wrote:
> Item in trash maybe?
>
> -----Original Message-----
> From: wp-hackers-bounces at lists.automattic.com [mailto:wp-hackers-bounces at lists.automattic.com] On Behalf Of Haluk Karamete
> Sent: Friday, June 22, 2012 1:36 PM
> To: wp-hackers at lists.automattic.com
> Subject: [wp-hackers] phpmyadmin post count vs wordpress dashboard's own post count
>
> php myadmin view:
> Showing rows 0 - 29 (10,223 total, Query took 0.0022 sec) SQL query:
> SELECT * FROM wp_posts LIMIT 0 , 30
>
> vs
> wordpress dashboard view:
> All (10,222) | Published (10,222) Search Posts: 10,222 items « ‹ of 512 › »
>
> Why is there a disconnect? Does anyone know why phpmyadmin reports
> 10223 on an unconditional SQL query while admin dashboard reports one less?
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers