[resolved] term_id and taxonomy woes (5 posts)

  1. r-a-y
    Posted 5 years ago #

    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!

  2. MichaelH
    Posted 5 years ago #

    A drastic measure for sure...but what about...
    1. Backup your database
    2. Do Tools->Export
    3. Drop your database tables
    4. Browse to yourdomain.com/wp-admin/install.php 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.

  3. r-a-y
    Posted 5 years ago #

    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.

  4. r-a-y
    Posted 5 years ago #

    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:

  5. MichaelH
    Posted 5 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic