wp_dropdown_categories, show_count=1 counts unpublished posts as well

[1manfactory]

When using the function

wp_dropdown_categories

and setting the argument

show_count=1

Wordpress will also count posts which are not published.

I tested it with different combinations of parent categories and child categories. It is always the same.

I checked on Windows/Apache and Unix/Lamp.

[scribu]

Does wp_list_categories() behave the same?

[dcowgill]

Yeah, I'm having the same issue with wp_list_categories(). It appears to be missing something like:

$where .= " AND post_status = 'publish'";

I believed it needs to be added in the 'get_terms' function but don't know how to fix it exactly.

[scribu]

Actually, the post count is stored in a dedicated column. See also #14076

[mdawaffe]

The count column is COUNTed from the term_relationships table, which doesn't know about the statuses of its object_ids.

Fixing would involve filtering the query in wp_update_term_count_now().

[mdawaffe]

Replying to mdawaffe:

The count column is COUNTed from the term_relationships table, which doesn't know about the statuses of its object_ids.

Fixing would involve filtering the query in wp_update_term_count_now().

Um... I think I'm lying. I thought I could reproduce, but can't now. Looking more.

[mdawaffe]

OK. I can't reproduce this bug. And this situation is exactly what $taxonomy->update_count_callback is for.

Closing as WFM. If you can still reproduce with WordPress trunk, please reopen with more details.

[mdawaffe]

Related? #14788