Closed (duplicate)
Project:
Rules
Version:
7.x-2.x-dev
Component:
Rules Engine
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
17 Jul 2010 at 00:49 UTC
Updated:
24 Feb 2011 at 08:54 UTC
Hey fago and klausi,
It was great to meet both of you and chat at DrupalCon San Francisco. I've begun active testing of the Rules 7.x-2.x-dev branch using the code from Github and I'm planning on adding issues to the Issue Queue as I find them.
Here's an error message I noticed when trying to take an action on the "After saving new content" event:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4' for key 'PRIMARY': INSERT INTO {node} (nid, vid, type, language, title, uid, status, created, changed, comment, promote, sticky, tnid, translate) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13); Array ( [:db_insert_placeholder_0] => 4 [:db_insert_placeholder_1] => 4 [:db_insert_placeholder_2] => article [:db_insert_placeholder_3] => und [:db_insert_placeholder_4] => New Article with Rule [:db_insert_placeholder_5] => 2 [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => 1279327117 [:db_insert_placeholder_8] => 1279327117 [:db_insert_placeholder_9] => 2 [:db_insert_placeholder_10] => 1 [:db_insert_placeholder_11] => 1 [:db_insert_placeholder_12] => 0 [:db_insert_placeholder_13] => 0 ) in drupal_write_record() (line 6017 of /Users/benkaplan/git/drupal/includes/common.inc).
The error message seems to occur regardless of the specific action. I tried both with the "Make content sticky" and "Unpublish content" actions. The new content is not being saved.
Are these types of bug reports helpful or are you still in too heavy development? What else needs to be actively tested?
Cheers,
Ben Kaplan
Comments
Comment #1
klausiI can confirm this bug. Yes, bug reports are helpful as Rules is now in a matured alpha phase.
Comment #2
fagoIs that still relevant? If so, I guess we should add test-coverage for that + fix it of course.
Comment #3
jarush commentedAny update to this bug?
I met the same bug when upgrade to Drupal Core RC2 and the newest Rules(From 7.x-2.x-dev (2010-Dec-06) To 7.x-2.x-dev (2010-Dec-22).
Thanks for developed such a useful module that I like it very much. :)
I will keep testing it.
Comment #4
hgurol commentedThis bug is still "very" active.
"After saving content" event --unsuccessfully-- tries to "insert" a node, which is already inserted(saved). I guess it should "update" the node.
Im running rules alpha5 and can provide more info or tests if needed.
Comment #5
klausiAh, I have completely forgotten about this issue and created accidentally a new one: #1068168: Auto saving of a new node after the event node_insert is broken. Marking this one as duplicate as we have a patch over there.