Wordpress problem -- not Revolution

[dada21]

I figured I'd post this here because the forum gets a TON of traffic. I've spent about 6 months trying to figure this out -- searching wordpress.org, checking blogs, etc. Others have had this problem, but NO ONE seems to have a solution.

I can't easily add categories or sub-categories because my database is fouled up somewhere. If I add a new category or subcategory, my database incorrectly creates values that don't match. For example, under the category of politics, if I create a subcategory called obama, it will successfully create that category, but the database values don't match.

The database enter for wp_term_taxonomy is the issue. Upon createing a new category, two fields in the MySQL database are added: term_taxonomy_id and term_id. New additions make these values DIFFERENT from each other: for example,term_taxonomy_id = 146, term_id = 140.

This "breaks" the rendering of that post. If I go into the database and update the values to be equal, everything is fixed. It's a pain to add subcategories or categories. It has also completely broken the tagging system, which are also added to this section of the database.

I'm considering exporting these database areas, erasing them, and reimporting them, to see if it fixes new records added.

Hopefully, someone else will have this same problem so I can work through a solution. Wordpress.org's support area has been completely useless. Anyone else have the same problem?