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!