Taxonomy Add Duplicate entry [#753172]

To replicate issue:

Conditions
the content type is a blog entry (or whatever)

Actions
Load a taxonomy term
And assign it to the content

This works fine if a person has not manually chosen the same taxonomy term already, but if they have it throws an error. This is because both the node form and the Rules actions are trying to insert the same entry.

Likewise, this will also happen if you simply try to Edit the form later and submit (as the taxonomy term will be autofilled in the form).

user warning: Duplicate entry '4-31' for key 'PRIMARY' query: INSERT INTO term_node (nid, vid, tid) VALUES (20, 31, 4) in /Users/username/Sites/whatever/modules/taxonomy/taxonomy.module on line 698.

More validation is needed to prevent this.

Comment	File	Size	Author
#5	rules-duplicate_key_taxonomy-753172-5.patch	889 bytes	kevin hankens

Comments

Comment #1

fago

German

Vienna

commented 26 March 2010 at 11:02

Component:	Rules Core	» Rules Engine
Status:	Active	» Postponed (maintainer needs more info)

Rules does only

$node->taxonomy[$taxonomy_term->tid] = $taxonomy_term;

and then saves the node and that only if term isn't there yet. Thus a simple load and save should be fine? So with which event can reproduce that? Perhaps somehow after the node has been saved after a node edit?

Comment #2

Anonymous (not verified) commented 26 March 2010 at 13:30

You can reproduce this with what I posted above.

Actions
Load a taxonomy term
And assign it to the content

Then in your node form, manually add the same taxonomy term that Rules is going to Load and Assign. So the taxonomy term will be submitted via the standard user-entered taxonomy form field and Rules.

Create a node. Save. Edit. Save.