I have my main site, www.whatsthatbug.com, and a test site, test.whatsthatbug.com. They are identical as far as I can tell - same version of wordpress, same plugins at the same versions, same theme with the same modifications.
The category widget on www shows a count of the parent category but does not include the subcategories in the count, whereas on test (and the way it always worked until recently on www), the category count includes the subtotals for the subcategories.
In wp-admin/edit-tags.php?taxonomy=category on www, I see no subcategories for any of the categories. Which makes some things difficult. And it means something is broken. On test, the subcategories are there as they should be (and as they used to be on www).
These two things seem related.
I thought it was some corruption in one of the wp_term tables, so I copied the data from test to www. No difference.
Any suggestions on where I should be looking at this point are most welcome. test is a snapshot from a few weeks ago. I suppose I could, worst case, export the posts and comments since then, import them into test, and make test into www. But that seems messy. And I'd like to know what went wrong here, anyway.
So, thank you in advance (and later as well) for any advice thrown my way.
For clarification, here is what I see on test.whatsthatbug.com for wp-admin/edit-tags.php?taxonomy=category:
And here is what I see on www.whatsthatbug.com:
And here is categories with counts from test:
and from www:
EDIT: In trying to troubleshoot this, I added this to the bottom of wp-admin/edit-tags.php:
wp_dropdown_categories(array('hide_empty' => 0, 'name' => 'select_name', 'hierarchical' => true, 'orderby' => 'name', 'order' => 'ASC'));
And it has the child categories for each parent category. I am lost as to why those child categories are not showing up on that page as shown in the image above. It does not appear to be a corrupt database...