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

klausi’s picture

Component: Rules Core » Rules Engine

I can confirm this bug. Yes, bug reports are helpful as Rules is now in a matured alpha phase.

fago’s picture

Status: Active » Postponed (maintainer needs more info)

Is that still relevant? If so, I guess we should add test-coverage for that + fix it of course.

jarush’s picture

Any 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.

hgurol’s picture

Status: Postponed (maintainer needs more info) » Active

This 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.

klausi’s picture

Status: Active » Closed (duplicate)

Ah, 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.