[master] gmap taxonomy "Duplicate Entry" sql warning [#351206]

Possible duplicate of #342387 but that issue is in d.5 and I'm in D6.8.
Perhaps it's an issue w/ taxonomy module, and not gmap? Suggestions appreciated. The text of the warning is:
user warning: Duplicate entry '20' for key 1 query: INSERT INTO gmap_taxonomy_node (nid, vid, tid, marker) (SELECT t.nid, t.vid, t.tid, g.marker FROM term_node t INNER JOIN gmap_taxonomy_term g ON t.tid = g.tid WHERE t.tid = 60) in /Applications/MAMP/htdocs/foid6/sites/all/modules/gmap/gmap_taxonomy.module on line 103.
I just don't have the skills to interpret the error message.

The error message occurs when I modify a vocabulary term and hit "save".
Thanks for any tips!
TV

Comments

Comment #1

tom_o_t commented 26 December 2008 at 11:09

Sounds like exactly the same issue. It's in the gmap taxonomy module. If I remember right it's only a problem if you have several terms applied to a node. The SQL query that runs when you update a term can't handle that. I wrote a fix for that for a recent version of the 5 release that I've been meaning to share. I'm away from computer for a few days but will dig out the code if someones not already fixed. The problem though is that there's no way for the code to know which should be the term to use foe the marker if you select several terms. I used the primary term module and some custom code for this.