[support] I manually imported some taxonomy terms, now getting "duplicate entry" errors.

[Neil: esl-lounge.com]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20080531/18d8231b/attachment.htm