Support » Fixing WordPress » term_id and taxonomy woes

  • Resolved r-a-y


    Let me try to explain the problem I have.

    When I create or edit any post tag, link category or custom taxonomy, the term_id in the wp_terms table doesn’t match the term_id in the wp_term_taxonomy table.

    To add to this, the term_ids are not unique and are duplicates of previous term_ids. This means that I see the wrong terms in the respective post tag, link category and custom taxonomy management screens.

    To better illustrate, I’ve taken a screenshot from phpMyAdmin:

    Please take a look and see if you can help me resolve my problem.

    Right now, it’s a hassle to go into phpMyAdmin to match up the term_id in both the wp_terms and wp_term_taxonomy tables every time I have to add a post tag, link category or custom taxonomy.

    For some reason, regular categories work though.

    I think this error occurred awhile ago when I tried some link category or custom taxonomy plugin, but instead it messed up the term_ids.

    I’m hoping that there’s some sort of SQL query I can run that will fix the term_id problem.

    Thanks in advance to those who read and especially to those who reply!

Viewing 4 replies - 1 through 4 (of 4 total)
  • A drastic measure for sure…but what about…
    1. Backup your database
    2. Do Tools->Export
    3. Drop your database tables
    4. Browse to to install a new set of database tables
    5. Use Tools->Import->WordPress using the file from step 2.

    If that’s too crazy, make sure your tables indexes match those in Database Description. Might also repair your tables.

    Thanks for replying, Michael.

    I’m a little hesitant to follow the process you outlined.

    Let me throw another problem at you; the problem occurs in the root blog of a MU install.

    So I’m not sure how I would drop the database tables for that one blog without reinstalling all the blogs!

    I should probably make a corresponding post on the MU forums for that; I’ll see what the guys over there say.

    If anyone has any other ideas, please let me know.

    I’m more convinced this is a MU problem caused when we imported a regular WordPress blog over to WPMU via PHPMyAdmin.

    If you’re interested in this issue, read on:

    Good idea. MU questions are always better asked at those forums. Marking this resolved.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘term_id and taxonomy woes’ is closed to new replies.