term_id and taxonomy woes

  • Resolved r-a-y

    (@r-a-y)


    15 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:
    https://i49.tinypic.com/xct9qs.jpg

    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)
  • MichaelH

    (@michaelh)

    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.

    Thread Starter r-a-y

    (@r-a-y)

    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.

    Thread Starter r-a-y

    (@r-a-y)

    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:
    https://mu.www.ads-software.com/forums/topic/15553

    MichaelH

    (@michaelh)

    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.