0

When I go to /wp-admin/edit-tags.php?taxonomy=category

it says there are 19 categories, but will only list 13 of them. There is no second page to go to. If I Search Categories for " ", all 19 do show up. If I click the "Parent Category" on the left, it shows all 19 in the drop down. Pretty much everywhere else except for the main category list page. What would cause this issue and how can I fix it?

Improve this question

1 Answer 1

Reset to default
1

Can't answer your question, but I just had a poke around with Query Monitor and this is the query that seems to get all the categories (it runs last so you don't have to search through every single query). If you can be bothered running this against your database and having a poke around with the results might help you figure out what's going on.

Or maybe you want to use Query Monitor to double check what query gets run for you to see why not all the categories are returned.

SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('category')
ORDER BY t.name ASC

Edit: And if this query shows all your categories, then you know that something else is removing them from this view somehow.

Improve this answer
1
  • Thanks, that query does return all 19 categories. I may look into using Query Monitor if no other solution presents itself.
    – Dan Goodspeed
    Commented Jun 30, 2020 at 20:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.