I have encountered the same thing, only I don’t nest my categories. I have 138 categories and recently noticed this. You can manage categories manually to add or remove by:
1. Assign the category: enter the category name using the Add function in the write post page. It should normally result in an error if you duplicate a category, but it doesn’t.
2. Remove a category: usually the default category. Type it in, hit the add button, and when it shows up at the top of the list checked off? Uncheck it.
Not my favorite way to deal with it, but it does make it possible to assign, reassign, or remove categories while this is resolved.
I have exactly the same problem (categories not showing up on the Write Post page). In addition, an incomplete list of categories is created by the wp_list_cats tag. The two lists are missing the same categories.
WP 2.0.1
184 categories, not nested
Plugins: Add Meta Tags, Akismet, Jerome’s Keywords, WP-PageNavi, Related Posts, External Links, WP Database Backup, Contact Form ][ (WP-2.0.x)
Anybody got any ideas?
I’ve been searching for the answer to this question for the past week and I finally fixed my problem, maybe this can help you guys.
In the admin-functions.php (in your wp-admin) folder find this:
function return_categories_list($parent = 0) {
global $wpdb;
return $wpdb->get_col(“SELECT cat_ID FROM $wpdb->categories WHERE category_parent = $parent ORDER BY category_count DESC LIMIT 100”);
See where it says LIMIT 100? I think that limits the number of categories shown to 100, I changed it to 1000 and all my categories appear now in my “Write Post” page. Hope this helps someone!
Excellent aprilprincesse, I had the same problem, and this fixed it for me. Anyone who can explain why this limit is there?
I’m abusing the WordPress categories as tags, so they’ve quickly gone from a few to over a hundred…
Thread Starter
fpanko
(@fpanko)
That is excellent aprilprincesse. I didn’t even see the limit in the code. That should fix it.
I’m thinking of removing the limit all together. The SQL should still be fine.
Worked like a charm! Thanks, aprilprincesse! 🙂
fpanko… how would you remove the limit?
kaeru… I agree that there appears to be no reason for having the limit there in the first place.
I am having this problem too! The dropdown menu will not show more than 20 page parents/categories. I don’t have that limit in my admin-functions.php file though. I’m using 2.0.4 (the latest version). Please help! I’ve also tried changing numerous bigint numbers in the database from 20 to 100 with no result. I don’t know what to do.
