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

[Haluk Karamete]

It cannot be the sample page. cause my migration routine blows it away
to start with 0 posts.
the culprit is the last post and its post status is auto-draft.


it all comes down to this http://core.trac.wordpress.org/ticket/11889

so, there is nothing to worry about it for the time being.


On Fri, Jun 22, 2012 at 1:42 PM, Brian Layman
<wp-hackers at thecodecave.com> wrote:
> It's probably the sample Page that came in with the initial WordPress
> install.
>
> You need to include `post_type`='post' if you are just looking at posts.
> Then after that you'll need to do things like filter out
> `post_status`='inherit'.
>
> The days are gone when you can expect a 1 to 1 relationship between any part
> of the UI and a WP table.  There's always something more to consider. But if
> you spend some time looking at each of the columns, you'll be able to
> understand what's going on.  everything except for the terms structure is
> pretty straight forward.
>
> Brian Layman
>
>
> On 6/22/2012 1:37 PM, Mika A Epstein wrote:
>>
>> Post revisions? Drafts? CPTs?
>>
>> ----
>> Mika A Epstein (aka Ipstenu)
>> http://ipstenu.org | http://halfelf.org
>>
>> On 22 Jun 2012, at 12:35:59PM, Haluk Karamete wrote:
>>
>>> 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
>
>
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers