I manually imported some taxonomy terms, now getting "duplicate entry" errors.
I imported about a thousand terms into the terms_data table and then added the parent-child relationships in the terms_hiearchy table. Everything went smoothly until I tried to add a term manually in another vocabulary using the "add terms" UI in taxonomy. a.. user warning: Duplicate entry '126' for key 1 query: INSERT INTO term_data (tid, name, description, vid, weight) VALUES (126, '2000s', '', 6, 0) in /home/mysite/public_html/includes/database.mysql.inc on line 172. b.. user warning: Duplicate entry '126' for key 1 query: INSERT INTO xmlsitemap_term (tid, pid, last_changed, priority_override) VALUES (126, NULL, 1212242801, NULL) in /home/mysite/public_html/includes/database.mysql.inc on line 172. the auto increment for these tables should be over 1000 and is showing as such in phpmyadmin - is that value stored somewhere where I can alter it? If I manually enter terms into the _data and _hierarchy tables, is there something else I need to alter to avoid problems when I go back to manually adding terms? Neil
If I manually enter terms into the _data and _hierarchy tables, is there something else I need to alter to avoid problems when I go back to manually adding terms?
Drupal 5 or Drupal 6? In Drupal 5, autoincrement wasn't used and IDs are stored in the sequences table. You'd have to edit that table to manually push up the ID to what you need it to be. In Drupal 6, right, this shouldn't be a problem (sequences is no more). -- Morbus Iff ( i think the "good book" is missing some pages ) Technical: http://www.oreillynet.com/pub/au/779 Enjoy: http://www.disobey.com/ and http://www.videounderbelly.com/ aim: akaMorbus / skype: morbusiff / icq: 2927491 / jabber.org: morbus
Yes, it was D5. I'll go and check that table. Thanks - this is thankfully not a live site! :-) ----- Original Message ----- From: "Morbus Iff" <morbus@disobey.com> To: <support@drupal.org> Sent: Saturday, May 31, 2008 4:27 PM Subject: Re: [support] I manually imported some taxonomy terms, now getting "duplicate entry" errors.
If I manually enter terms into the _data and _hierarchy tables, is there something else I need to alter to avoid problems when I go back to manually adding terms?
Drupal 5 or Drupal 6?
In Drupal 5, autoincrement wasn't used and IDs are stored in the sequences table. You'd have to edit that table to manually push up the ID to what you need it to be.
In Drupal 6, right, this shouldn't be a problem (sequences is no more).
-- Morbus Iff ( i think the "good book" is missing some pages ) Technical: http://www.oreillynet.com/pub/au/779 Enjoy: http://www.disobey.com/ and http://www.videounderbelly.com/ aim: akaMorbus / skype: morbusiff / icq: 2927491 / jabber.org: morbus -- [ Drupal support list | http://lists.drupal.org/ ]
participants (2)
-
Morbus Iff -
Neil: esl-lounge.com