legacy taxonomy import sometimes has sequencing conflicts [#59163]

I have just tried to import my first vocab into a category it only had five terms but they have all failed with an error similar to the following

Type php
Date Monday, April 17, 2006 - 20:03
User XXXXX
Location http://cms.dibbletree.com/admin/category_legacy
Referrer http://cms.dibbletree.com/admin/category_legacy
Message Duplicate entry '92' for key 1 query: INSERT INTO term_data (tid, name, description, vid, weight) VALUES (92, 'Carnoustie High School Theatre', 'A 300 seater theatre in Carnoustie high school. This theatre underwent a major refurbishment funded by the national lottery and the Scottish Arts Council. Uniquely managed by the major users of the theatre on behalf of the local council.', 91, 0) in xxxxx/drupal/includes/database.mysql.inc on line 120.
Severity Error

the tid it is trying to use for each one does already exist,

Have I done something wrong on my import settings ?

tkgafs

Comments

Comment #1

tkgafs commented 17 April 2006 at 21:22

I have restored my database and reran the category_legacy import the output from the run is attached

* Backed up selected data.
* Deleted data from taxonomy tables.

* user warning: Duplicate entry '92' for key 1 query: INSERT INTO term_data (tid, name, description, vid, weight) VALUES (92, 'Carnoustie High School Theatre', 'A 300 seater theatre in Carnoustie high school. This theatre underwent a major refurbishment funded by the national lottery and the Scottish Arts Council. Uniquely managed by the major users of the theatre on behalf of the local council.', 91, 0) in /xxxxxx/drupal/includes/database.mysql.inc on line 120.
* user warning: Duplicate entry '92-76' for key 1 query: INSERT INTO term_node (nid, tid) VALUES (76, 92) in /xxxxxx/drupal/includes/database.mysql.inc on line 120.
* user warning: Duplicate entry '93' for key 1 query: INSERT INTO term_data (tid, name, description, vid, weight) VALUES (93, 'Dibble Tree Theatre', 'Our own little theatre in Carnoustie High Street', 91, 0) in /xxxxxxx/drupal/includes/database.mysql.inc on line 120.
* user warning: Duplicate entry '94' for key 1 query: INSERT INTO term_data (tid, name, description, vid, weight) VALUES (94, 'Orkney Arts Theatre', 'The major theatre venue in Orkney.', 91, 0) in /xxxxxx/drupal/includes/database.mysql.inc on line 120.
* user warning: Duplicate entry '95' for key 1 query: INSERT INTO term_data (tid, name, description, vid, weight) VALUES (95, 'Pitlochry Festival Theatre', 'Pitlochry Festival Theatre is a theatrical haven offering a unique cultural experience in beautiful countryside on the banks of the River Tummel. It is a long established and well respected theatre company famous for its classic dramas, concerts and more', 91, 0) in /xxxxxx/drupal/includes/database.mysql.inc on line 120.
* user warning: Duplicate entry '96' for key 1 query: INSERT INTO term_data (tid, name, description, vid, weight) VALUES (96, 'Webster Theatre Arbroath', 'This is the main theatre in Angus, currently about to undergo a major refrubishment', 91, 0) in /xxxxxx/drupal/includes/database.mysql.inc on line 120.

can anybody suggest what the problem is

tkgafs

Comment #2

Jaza commented 18 April 2006 at 02:09

Title:

category_legacy import failed

» legacy taxonomy import sometimes has sequencing conflicts

Looks to me like the node IDs that are being generated for your new categories are conflicting with existing term IDs in your taxonomy data. This occurs in the unlikely case that you have more taxonomy terms than nodes on your site.

This is a bug that I will have to look into fixing. In the meantime, if you change the 'node_nid' value in your site's 'sequences' table to a value that is HIGHER than the biggest term ID on your site, the conflict of IDs should be avoided.

Comment #3

tkgafs commented 18 April 2006 at 07:10

Yes I will have many more terms than nodes on my site certainly at the moment whilst it is being developed and tested. I will do the update you suggest today and let you know the outcome

tkgafs