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 <[EMAIL PROTECTED]>: > > On Feb 7, 2008 11:34 AM, ]V[orlock Zernebock <[EMAIL PROTECTED]> 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 > [email protected] > http://lists.automattic.com/mailman/listinfo/wp-testers > _______________________________________________ wp-testers mailing list [email protected] http://lists.automattic.com/mailman/listinfo/wp-testers
