Edit tag ID

  • Resolved Mister Twister

    (@mister-twister)


    9 years, 1 month ago

    Hello
    It’s necessary to edit tags ID in WordPress to make all of them to be by count (1, 2, 3, 4, 5 etc.)
    After several years of WordPress using I’ve got tags with ID’s order like this: 27, 31, 35, 78, 112, 125, 178, 250 and so on. Here is a screenshot for your convinience: http://i.imgur.com/7FWVg6M.png
    Many of tags were deleted, so that’s why there are a lot of gaps between IDs nums.
    As you know the table “wp-terms” in MySQL data base consists of:
    term_id (tag/cathegory ID value)
    name (your tag/cathegory name)
    slug (WordPress tag/cathegory name)
    Could you tell me, please, is it ok if I’ll edit table “wp-terms” and change tags IDs by count?
    Thank you in advance

Viewing 1 replies (of 1 total)
  • Thread Starter Mister Twister

    (@mister-twister)

    9 years, 1 month ago

    So I’ve looked through MySQL, made some tests on clean WordPress site and here is a solution of my question above:
    First of all it’s necessary to correct term_id value in wp_terms table. For example:
    Before: term_id -> X
    Later: term_id -> Y
    Secondly you should correct the same term_id value in wp_term_taxonomy table. It’s easy. For example:
    Before: term_id -> X
    Later: term_id -> Y
    Don’t change term_taxonomy_id value, otherwise all tags will became a mess in your posts.
    That’s it. Thank you for reading.

Viewing 1 replies (of 1 total)
  • The topic ‘Edit tag ID’ is closed to new replies.