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

Jackson Whelan jw at jacksonwhelan.com
Fri Jun 22 20:07:32 UTC 2012


Perhaps you visited

http://domain.com/wp-admin/post-new.php

On 6/22/12 3:51 PM, Haluk Karamete wrote:
> 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
> _______________________________________________
> 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