Categories Missing

Odd… never heard of anything like that. Could you install the dump environment plugin: https://dev.wp-plugins.org/file/dump_env/trunk/dump_env.php?rev=4235 and tell us the output. The Categories box is set to a maximum height and has a scrollbar so you can get to the lower categories, so could that be your problem?

Can you work out any pattern to which categories are missing? Could you list _exactly_ which categories are in your DB and which ones aren’t showing up?

(copied from Trac)

Unable to detect a pattern. I do have a large number of categories, so I will avoid reciting the list. The ones I noticed missing were 1) architecture, 2) housing and 3) shelter.

I also note that when I use performancing, those categories are present and I can select them like any others. Is quite odd.

Is there any sort of index that could have been corrupted? When I used PHP to add those categories to the post, I noted that the category table showed an overload, which disappeared when I optimized the table. Unfortunately, this failed to solved the problem.

Will install the plugin and upload the dump.

Sorry, when I copied the php, uploaded it to the remote server, and activated the plugin, I got garbage at the top of the page until I deactivated the plugin again.

BTW: My profile includes my weblog, which would show my categories in the sidebar. Architecture has 11 posts, housing (9) and shelter (10).

And, the IDs are 6, 410 and 355.

OooooK, in the strange getting stranger department…

You know how I said that I edited the wp2cat table using phpAdmin to add the additonal categories (missing from the checklist) that I wanted for a particular post and how adding them to the post had no effect on the list.

Well, they appeared as categories for the post (#1207 “Ready or Not”) right? … appeared… as in past tense. Now gone again.

And, in the post2cat table the rel_id now jumps from 6444 to 6452.

WHAT THE????

I followed the admonition to switch off all plugins and use the default theme. Made no difference to the missing categories.

Well, if you’ve had problems with corrupt tables in the past then something could be up. Try doing a phpmyadmin export of wp_categories and wp_post2cat (the wp_ bit may change depending on what you’ve got your table prefix set to) then re-importing them. Other than that I can only suggest a reinstall.

Oh, and flush the cache. That’ll help. There’s no easy way of doing this, perhaps the simplest is just to write a one-line plugin that calls wp_cache_flush(). Then enable that plugin, then disable it right away. See if that solves anything.

Nope. An export of the data as replacement and uploading the file failed to change anything. I made no change to the previx.

Also, the flush failed to help matters.

As to reinstalling, what about the 1,134 posts and 586 comments, contained within 417 categories?

Yeah, I think you’ve got a corrupt table somewhere, as this has not happened for anyone else and you’ve mentioned it could be possible. I’m afraid that I don’t know enough about mysql to know how to recover it, I guess you should ask in the MySQL forums, or someone that knows a bit more about databases could come and help you out here ??

I think that you are wrong. By isolating me as an individual, you can ignore what you fail to understand. Unfortunately, too often a technique used by WP volunteers in “helping”.

It may take a while for another WP user to recognize what is happening. Take a look at the code in wp-admin for edit-form-ajax-cat and tell me what decisions “sanitize” makes for the user?

I have all those categories for my weblog because WP copied and improved on MT. I now like and want to use the feature. So, developers enamored with making a new whizbang break essential functionality previously provided, then blame the user for it.

That is wrong, poets!

BTW: I have checked, re-checked, triple-checked the mysql and something repeatedly is breaking wp-options and wp-post2cat. And, I perceive it to be the design of Duke, boopsie. Not something that was working perfectly fine until I upgraded.

Okay, I have a working premise: any category with a category_count less than 20 fails to appear in the checklist

And, since missing from the checklist, the category is removed from the post upon edit.

Trying to downgrade was frustrating. I even tried a script to reset the database, so that it would again work with the earlier version. This attempt not only failed, but also meant that I no longer could use the database with 2.0.

I deleted the database and did a fresh install of 2.0. Attempts to reconstruct the database, either with a complete SQL or XML of just posts failed. Eventually, I restored the weblog by capturing insertions from the SQL and running sets of insertions to restore what I had lost.

The same problem still exists.

I’m also experiencing the same problem jcwinnie is after I upgraded to 2.0 as have several of my friends. I’m browsing the support forums for help and hope someone realizes this isn’t an isolated issue.

I also found this page:
edit-form-ajax-cat.php

Anyone find any solutions to this?

I upgraded to 2.0, everything went fine.
At wp-admin/post.php, the categories displays a partial list of all my categories. The pulldown menu does not cut off. I can scroll from top to bottom alphabetical. The odd thing is there is some logic that is displaying some categories but not others. For example I have a category called “People: Alexandre Aja.” In the admin now this category (among several others do not display). When I view that specific category via the site it shows everything fine.
https://www.cinemastrikesback.com/index.php?cat=444
However now in the admin when I go to create a new post I have no option to flag this category as it doesn’t display (this is also of course the case for several other categories). What logic is now included for any exclusion of categories for posting/editing posts in the admin? Is it as jcwinnie suggests that at a certain range categories display (over 20).