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

Mika A Epstein ipstenu at ipstenu.org
Fri Jun 22 18:21:14 UTC 2012


All doesn't count trash.

All (641)
Published (638)
Drafts (3)
Trash (1)

----
Mika A Epstein (aka Ipstenu)
http://ipstenu.org | http://halfelf.org

On 22 Jun 2012, at 1:06:39PM, Jesper Jarlskov wrote:

> But then, why is there no difference between "all" and "published"?
> 
> On Fri, Jun 22, 2012 at 7:44 PM, 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
>> 
> 
> 
> 
> -- 
> Jesper Jarlskov
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers



More information about the wp-hackers mailing list