[wp-testers] incorrect post counts
]V[orlock Zernebock
morlockz at gmail.com
Thu Feb 7 21:34:09 GMT 2008
When I run the query directly in MySQL I got the correct number. All my old
published posts are with that status in MySQL.
Here you have the results to compare against dashboard numbers:
You have 1 posts, 12 pages, 1 draft, contained within 35 categories and 1
tags.
SELECT COUNT( * )
FROM wp_posts
WHERE post_status = 'publish'
AND post_type = 'post';
COUNT(*)
1419
SELECT COUNT( * )
FROM wp_posts
WHERE post_status = 'publish'
AND post_type = 'page';
COUNT(*)
12
SELECT COUNT( * )
FROM wp_posts
WHERE post_status = 'draft'
AND post_type = 'post';
COUNT(*)
1
SELECT COUNT( * )
FROM wp_posts
WHERE post_status = 'future'
AND post_type = 'post';
COUNT(*)
0
SELECT COUNT( * )
FROM wp_comments
WHERE comment_approved = '1'
COUNT(*)
2053
SELECT COUNT( * )
FROM wp_term_taxonomy
WHERE taxonomy = 'category'
COUNT(*)
35
SELECT COUNT( * )
FROM wp_term_taxonomy
WHERE taxonomy = 'post_tag'
COUNT(*)
1475
2008/2/7, Lloyd Budd <lloydomattic at gmail.com>:
>
> On Feb 7, 2008 11:34 AM, ]V[orlock Zernebock <morlockz at gmail.com> wrote:
> > My database is correct, my files are updated, but all counts are still
> wrong
> > except the one for pages.
>
> When you record the query and run it manually does it provide a
> different result? I expect not. Do you older published posts not have
> that status?
>
> Thank you,
> Lloyd
> _______________________________________________
> wp-testers mailing list
> wp-testers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-testers
>
More information about the wp-testers
mailing list