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.
Popular content
Recent comments
- Import...
4 days 1 hour ago - More coming
5 days 20 hours ago - No bad post, write more
5 days 20 hours ago - Great!
1 week 2 days ago - This helped me!
1 week 2 days ago - Its back!
1 year 19 weeks ago - Any Updates?
1 year 26 weeks ago - Affiliate Marketing - A Long Road
1 year 29 weeks ago - Thanks bro :) I have enjoyed
1 year 35 weeks ago - Thanks for sharing these
1 year 37 weeks ago

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