I installed the stable version, then installed the dev version shortly thereafter. I had an old taxonomy structure, which I then made into a CCK datatype and added to my story nodes. I've also checked "Add Used Terms as Node Tags," because I'm not currently using the CCK functionality -- I'm mostly just using this module at the moment for the hierarchical freetagging features.

When I then add a new tag to a story and submit the story, it works fine. But when I click on 'edit' for that page, change nothing, and submit it again, I get the following error:

user warning: Duplicate entry '127-84' for key 1 query: INSERT INTO term_node (nid, tid) VALUES (84, 127) in drupal/includes/database.mysql.inc on line 172.

Comments

rconstantine’s picture

rconstantine commented

Oops. I'll look into this.

rconstantine’s picture

rconstantine commented

Sorry it has taken so long to get back to you. I haven't been able to duplicate this error. Check out this function: cck_taxonomy_ssu_submit and play with it. Note that there is a SELECT check before each place that an INSERT is done to see if the term has already been inserted. So, I'm not sure how this could happen. Do you have at least a little programming skill such that you can do some print statements to get results of the the SELECT queries and see why it isn't finding the terms as existing?

Also, if you aren't now, you should install the devel module and activate the backtrace feature so that your error will be backtraced to the source and will give you exactly which line in my module is fouling things up.

Good luck.

rconstantine’s picture

rconstantine commented
Status: Active » Closed (fixed)

Unable to duplicate problem and never heard back from original poster.