Duplicate entry for taxonomy SQL query

What other taxonomy-type modules are you using?

I would try to disable those modules one by one, and see when the problem disappear.

I am sorry; it's the usual problem with adding two comments at the same time.

Critical? Really, these look like warnings to me. I know what is causing them, and will find a fix at some point, for now, don't worry.

This may actually be fixed in the latest version. Can users please try it, and let me know if they still get the warnings as before, and if so, what they did to receive the warnings.

Thanks in advance.

Apologies for taking some time to reply to this. Thanks for the work earnie, sadly I already knew that was the issue, but am now having difficulty in recreating it on my site. Can somebody please try 6.x-1.17 and let me know if they're still experiencing this, and if so, how to recreate the issue.

Cheers.

I installed the lowername module and upgraded to 1.17. Then I ran cron.php and still see this error.

This shouldn't be anything to do with this module, as it has no hook_cron function.

Cheers for this earnie. This has inspired me to also fix http://drupal.org/node/291846 , which will be included in 6.x-1.18.

Thanks earnie, I've adapted your fix a little, although I don't feel that it is necessary to check if $node->taxonomy is_object.

Please completely uninstall the previous version of Autotag, and install the latest 6.x-1.19 version. When posting bug reports, please ensure you post a list of all other contributed modules that are installed, and the exact steps required to reproduce the bug you're experiencing from a clean Drupal install.

Receiving this error each time I use "Re-autotag by content type": "user warning: Duplicate entry '0-9' for key 1 query: INSERT INTO term_node (nid, vid, tid) VALUES (8, 9, 0) in /home/..../modules/taxonomy/taxonomy.module on line 701."

I'm using version 6x-1.27 and the following taxonomy modules:

Tagging 6.x-2.0-beta2
Tagging extractor suggestions 6.x-2.0-beta2
Tagging opencalais suggestions 6.x-2.0-beta2
Tagging vocabular suggestion 6.x-2.0-beta2

My settings are correct (i.e., "multiple" and "required"). Any help would be appreciated. I'm very interested in this module's development. Thanks.

I am changing the referring version as per previous comment.

Thanks. I'm following this thread - because the certain taxonomies aren't working correctly. Just a few. I consistently get this error, and it seems like certain tags are misapplied. For instance, the text string is something like "Dog" and it ends up tagging the node as "Cat."

I also get this error when updating an existing node with tags in it - using Autotag 1.27, Lowername 1.1 and the following Taxonomy related modules:

Simplenews
Simplenews Actions
Simplenews Analytics
Simplenews Statistics
XML sitemap taxonomy
Forum Access
Forum

Taxonomy is latest version 6.16 and the error message mentions now another line:

user warning: Duplicate entry '201-1687' for key 1 query: INSERT INTO term_node (nid, vid, tid) VALUES (1670, 1687, 201) in /srv/www/vhosts/MY-SITE.com/httpdocs/modules/taxonomy/taxonomy.module on line 693.

The vocabulary is "tags" with multiple select - other constellations did not work for me.

as there was no post for longer... does no one has this problem anymore??????

Yes, I am.
user warning: Duplicate entry '0-617' for key 'PRIMARY' query: INSERT INTO term_node (nid, vid, tid) VALUES (617, 617, 0) in /public_html/modules/taxonomy/taxonomy.module on line 701.
Taxonomy related module: Taxonomy hide, Taxonomy Menu, Taxonomy Node, Lowername

I'm having the problem, perhaps with a slightly older version:
// $Id: taxonomy.module,v 1.414.2.12 2009/09/15 11:13:08 goba Exp $

Anyway, in this code:

/**
 * Save term associations for a given node.
 */
function taxonomy_node_save($node, $terms) {
...

  // Free tagging vocabularies do not send their tids in the form,
  // so we'll detect them here and process them independently.
  if (isset($terms['tags'])) {
...
        // Defend against duplicate, differently cased tags
        if (!isset($inserted[$typed_term_tid])) {
          db_query('INSERT INTO {term_node} (nid, vid, tid) VALUES (%d, %d, %d)', $node->nid, $node->vid, $typed_term_tid);
          $inserted[$typed_term_tid] = TRUE;
        }
      }
    }
  }

  if (is_array($terms)) {
    foreach ($terms as $term) {
      if (is_array($term)) {
        foreach ($term as $tid) {
          if ($tid) {
            db_query('INSERT INTO {term_node} (nid, vid, tid) VALUES (%d, %d, %d)', $node->nid, $node->vid, $tid);
          }
        }
      }
      else if (is_object($term)) {
        db_query('INSERT INTO {term_node} (nid, vid, tid) VALUES (%d, %d, %d)', $node->nid, $node->vid, $term->tid);
      }
      else if ($term) {
        db_query('INSERT INTO {term_node} (nid, vid, tid) VALUES (%d, %d, %d)', $node->nid, $node->vid, $term);
      }
    }
  }

It looks to me like the INSERT is performed twice if isset($terms['tags']). Am I right that changing this line:
if (is_array($terms)) {
to:
else if (is_array($terms)) {
fixes the problem? EDIT: This causes problems when editing taxonomy from the GUI.

Also getting the error at line 693 in taxonomy.module. I get this error from the log when trying to update an ipaper content type (note: I do have autotag module set to autotag the ipaper content type):

Duplicate entry '223-966' for key 1 query: INSERT INTO term_node (nid, vid, tid) VALUES (170, 966, 223) in /home/MYSite/public_html/Directory/modules/taxonomy/taxonomy.module on line 693."

Is this an issue with the taxonomy module, the autotag module or both?

This issue should be fixed in v2 of the module. Please re-open this issue if you're still experiencing any of the problems above.

I have updated to the v2. But I still get the error.

Particular when I re-autotag, I get dozens of these errors:
Duplicate entry '41938-59316' for key 1 query: INSERT INTO term_node (nid, vid, tid) VALUES (59124, 59316, 41938) in //taxonomy.module in line 709.

I set up one content type with only one taxonomy (keywords).
I ran autotag and it successfully updated the keywords tags
I re-ran autotag (as an Autotag on Save with a single node) and got a report log filled with entries similar to the following:

Duplicate entry '375-801' for key 'PRIMARY' query: INSERT INTO term_node (nid, vid, tid) VALUES (755, 801, 375) in C:\xampp\htdocs\modules\taxonomy\taxonomy.module on line 709.

each of the keywords that were already there from the first autotag had a corresponding error in the log report. it looks as though autotag is doing an insert instead of an update?

will make it difficult to update tags to reflect changes to the keywords taxonomy, since legitimate errors will be buried in amongst these illegitimate bastards.

Exactly same issue. I am also getting double tags. I am going to have to go back to the old version for now. BTW, I love this module. Keep up the good work.

I receive the same errors when running the re-autotag at /admin/settings/autotag.

If I empty out the term_node table and run the re-autotag, it works great. Running the re-autotag a 2nd time results in the dozens of error messages.

Seems like this is still an issue, although, it doesn't seem to be affecting functionality. subscribe!

same here:

user warning: Duplicate entry '2076-1943' for key 'PRIMARY' query: INSERT INTO term_node (nid, vid, tid) VALUES (1926, 1943, 2076) in /var/www/vhosts/mysite/httpdocs/modules/taxonomy/taxonomy.module on line 709.

I have the same issue

Duplicate entry '11355-76' for key 'PRIMARY' query: INSERT INTO term_node (nid, vid, tid) VALUES (76, 76, 11355) in D:\xampp\htdocs\avian\modules\taxonomy\taxonomy.module on line 708.

llegal offset type in D:\xampp\htdocs\avian\modules\taxonomy\taxonomy.module on line 1042.

and some warning messages also...

warning: Illegal offset type in isset or empty in D:\xampp\htdocs\avian\modules\taxonomy\taxonomy.module on line 1038.
warning: Illegal offset type in D:\xampp\htdocs\avian\modules\taxonomy\taxonomy.module on line 1039.
warning: Illegal offset type in D:\xampp\htdocs\avian\modules\taxonomy\taxonomy.module on line 1042.
warning: Illegal offset type in isset or empty in D:\xampp\htdocs\avian\modules\taxonomy\taxonomy.module on line 1038.
warning: Illegal offset type in D:\xampp\htdocs\avian\modules\taxonomy\taxonomy.module on line 1039.
warning: Illegal offset type in D:\xampp\htdocs\avian\modules\taxonomy\taxonomy.module on line 1042.

Why is this major? Does your site crash? Does it stop the node from saving? Has data been lost?

Please find attached patch for your consideration for merging (and for those like me that use drush_make in the mean time)
The issue arises when there are multiple fields/form parts that autotags are created from, duplicate tags are marked.
This patch in a very crude fashion, removes those duplicates.

I have applied this patch, but it returns always this warning:

user warning: Duplicate entry '103-522' for key 'PRIMARY' query: INSERT INTO term_node (nid, vid, tid) VALUES (522, 522, 103) in /Applications/MAMP/htdocs/mysite/modules/taxonomy/taxonomy.module on line 716.
user warning: Duplicate entry '103-523' for key 'PRIMARY' query: INSERT INTO term_node (nid, vid, tid) VALUES (523, 523, 103) in /Applications/MAMP/htdocs/mysite/modules/taxonomy/taxonomy.module on line 716.
user warning: Duplicate entry '103-524' for key 'PRIMARY' query: INSERT INTO term_node (nid, vid, tid) VALUES (524, 524, 103) in /Applications/MAMP/htdocs/mysite/modules/taxonomy/taxonomy.module on line 716.
user warning: Duplicate entry '103-567' for key 'PRIMARY' query: INSERT INTO term_node (nid, vid, tid) VALUES (567, 567, 103) in /Applications/MAMP/htdocs/mysite/modules/taxonomy/taxonomy.module on line 716.
Etc........

the site does not crash and the update of the new nodes is still correct.

One request; it's possible to re-autotag ONLY NEW NODES? (infact this error appers because it attempts to update also the old nodes)

PS. I'm not very practical about Drupal API, but IMO may be there is something strange in autotag.module, line 96 ?:

foreach($tids as $tid){
          if(is_array($node->taxonomy[$tid['vid']])){
            $node->taxonomy[$tid['vid']][$tid['tid']] = $tid['tid'];
          }else{
            $node->taxonomy[$tid['vid']] = array(
              $tid['tid'] => $tid['tid']
            );
          }
        }
      }
      break;
    case 'update':
    case 'insert':
      // Here we can add the relevant tids to the autotag table.
      if(isset($_SESSION['autotag_tids'][$node->form_build_id])){
        // Lets get the ones that were tagged to the node from the term_node table
        $result = db_query('SELECT n.tid, t.vid FROM {term_node} n, {term_data} t WHERE n.tid = t.tid AND nid = %d', $node->nid);
        while($row = db_fetch_array($result)){
          $key = array_search($row, $_SESSION['autotag_tids'][$node->form_build_id]);
          if($key !== FALSE){
            unset($_SESSION['autotag_tids'][$node->form_build_id][$key]);
          }
        }

Are you sure that the module should have the same behavior in the two cases?
case-update
case-insert

Best

Closing this issue as seems to be outdate.

Please, re-open in case someone else needs support with it.