Download & Extend
NodeReferrer » Issues

Duplicate entry error when saving a node with rules.module

Posted by mikeytown2 on April 25, 2009 at 11:04pm
Project:NodeReferrer
Version:6.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:postponed (maintainer needs more info)

Issue Summary

Error happens right before the node is successfully created via watchdog.

Duplicate entry '778-0' for key 1 query: INSERT INTO content_field_referrers (vid, nid, delta) VALUES (778, 431, 0) in /sites/all/modules/cck/content.module on line 1207.

Then here's the corresponding error to go with this one

Duplicate entry '778-0' for key 1 query: INSERT INTO content_field_testimonials (vid, nid, delta) VALUES (778, 431, 0) in /sites/all/modules/cck/content.module on line 1207.

This is a new node so nothing is referencing this, and it wasn't set to be a reference to another node. 431 is the newly created nid. 778 is the vid & it is incremented by 2 on every new node creation. I have the rules module set up to save the node again because various tokens don't get set correctly, so this is a cheap trick that makes all my tokens work.

Login or register to post comments

Comments

#1

Posted by mikeytown2 on April 25, 2009 at 11:14pm

Related info
http://drupal.org/node/270777#comment-1519760

#2

Posted by yched on April 25, 2009 at 11:59pm
Status:active» closed (won't fix)

I've several reports about this, IIRC all were related to nodereferrer.module. Please see over there.

#3

Posted by mikeytown2 on April 26, 2009 at 12:56am
Project:Content Construction Kit (CCK)» NodeReferrer
Version:6.x-2.2» 6.x-1.x-dev
Component:content.module» Code
Status:closed (won't fix)» active

Moving to NodeReferrer Issue Queue

#4

Posted by kiamlaluno on April 28, 2009 at 3:49pm
Title:Duplicate entry '778-0' for key 1 query» Duplicate entry error when saving a node with rules.module

#5

Posted by andypost on April 29, 2009 at 2:49am

So where is a test case to find the bug? Is this really related to NodeReferrer module?

#6

Posted by mikeytown2 on April 29, 2009 at 2:53am

#445084: Adjust module weight from 0 is where the action is. I found this bug in 3 modules, should be fairly easy to duplicate if you follow http://drupal.org/node/445084#comment-1531066. For this case, enable all Node Referrer Dependencies as well as it's self.

#7

Posted by andypost on June 17, 2009 at 3:06pm

Suppose this bug fixed, try to upgrade to current Beta - Multiple fields is disabled for Node Referrer fields.

#8

Posted by mikeytown2 on June 18, 2009 at 8:16am

nope still get it with the latest dev

Duplicate entry '902-0' for key 1 query: INSERT INTO content_field_testimonials (vid, nid, delta) VALUES (902, 435, 0) in /home/content/m/c/a/mcarper/html/sites/all/modules/cck/content.module on line 1213.

Duplicate entry '902-0' for key 1 query: INSERT INTO content_field_referrers (vid, nid, delta) VALUES (902, 435, 0) in /home/content/m/c/a/mcarper/html/sites/all/modules/cck/content.module on line 1213.

#9

Posted by andypost on June 18, 2009 at 11:33am
Status:active» postponed (maintainer needs more info)

@mikeytown2 can you provide more info? NodeReferrer is never save any data to database so it looks very strange!!!

#10

Posted by hefox on October 1, 2009 at 1:29pm

I'm getting this error also and I'm not using Noderefferer, but I am using rules. Perhaps this is a rules bug instead?

nobody click here