[wp-hackers] phpmyadmin post count vs wordpress dashboard's own post count
halukkaramete at gmail.com
Fri Jun 22 22:08:03 UTC 2012
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
> 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
> 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
>>> 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
>>> wp-hackers mailing list
>>> wp-hackers at lists.automattic.com
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers