Taxonomy Error after Drupal 5 to 6 Upgrade

In my previous post regarding my Drupal 5 to Drupal 6 upgrade I stated that the upgrade went smooth.  Well, unfortunately that was not 100% correct.  After making a second post, I noticed an odd error occurring with the taxonomy entries:

Duplicate entry '0' for key 1 query: INSERT INTO term_data (vid, name, description, weight)

After a bit of searching, I wasn't able to easily fix the issue.  However, after comparing the term_data table with a clean drupal 6 install I noticed that the 'tid' field was not set to auto_increment.  I then changed that field to auto_increment and edited my last post.  And the result.... it worked!

It appears there was a small glitch on my upgrade.  Not 100% sure if it was something on my end or a bug on Drupal's end (most likely not).  I hope this post will help anyone who runs accross the same issue.

This helped me!

Thanks very much.

Great!

Good to hear!  You may also want to check out this post: Duplicate Entry Comment Issue