- Favorite BlackBerry Storm Apps
- How To Search Twitter with FireFox
- 2008 Cyber Monday deals from Buy.com
- Happy Thanksgiving and stuff(ing)
- My Favorite Drupal 6 Modules
- World... Meet Luke the Boxer
- Taxonomy Error after Drupal 5 to 6 Upgrade
- Mobile Web Surfing - iPhone, BlackBerry, Etc
- Drupal Upgrade & Theme Change
- Can I have my old iGoogle back?
Taxonomy Error after Drupal 5 to 6 UpgradeSubmitted by Jerry on Sun, 2008-10-26 19:25 |
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.


Recent comments
17 weeks 11 hours ago
20 weeks 3 hours ago
25 weeks 6 days ago
28 weeks 3 days ago
30 weeks 2 days ago
32 weeks 6 days ago
33 weeks 3 days ago
33 weeks 3 days ago
34 weeks 1 day ago
41 weeks 6 days ago