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...
20 hours 51 min ago - More coming
2 days 15 hours ago - No bad post, write more
2 days 15 hours ago - Great!
5 days 22 hours ago - This helped me!
5 days 22 hours ago - Its back!
1 year 19 weeks ago - Any Updates?
1 year 25 weeks ago - Affiliate Marketing - A Long Road
1 year 28 weeks ago - Thanks bro :) I have enjoyed
1 year 34 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