PDOException when creating new content with a new path alias. [#999372]

Event: After saving new content and after updating new content.
No conditions.
Actions:
Show a message on the site.
Create or delete a content's URL alias.

After creating a new node the message is set correctly above the following error message. The content is not saved.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7' 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] => 7 [:db_insert_placeholder_1] => 7 [:db_insert_placeholder_2] => page [:db_insert_placeholder_3] => und [:db_insert_placeholder_4] => path test 5 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => 1292444884 [:db_insert_placeholder_8] => 1292444884 [:db_insert_placeholder_9] => 1 [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => 0 [:db_insert_placeholder_13] => 0 ) in drupal_write_record() (line 6744 of /home/david/dev/drupal/includes/common.inc).

Updating a content works fine. The message is set, the old alias is changed to match the new title.

I did find this issue when I was searching: http://drupal.org/node/856840 I made a new one since other actions work fine for me, unlike in that issue.

I am testing things on a local install of D7 RC2 with the latest dev versions of Token and Rule. I did add the patch in comment 60 to Token from this page: http://drupal.org/node/691078

Comments

Comment #1

WhiplashInfo commented 27 January 2011 at 15:28

Component:

Rules Core

» Rules Engine

I stumbled into the same problem using BitNami Stack with Drupal:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'DateAPITestCase-class' for key 'PRIMARY': INSERT INTO {registry} (name, type, filename, module, weight) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => DateAPITestCase [:db_insert_placeholder_1] => class [:db_insert_placeholder_2] => sites/all/modules/date/date/tests/date_api.test [:db_insert_placeholder_3] => date [:db_insert_placeholder_4] => 0 ) i _registry_parse_file() (rad 179 av C:\Program Files\BitNami WAMPStack\apps\drupal\htdocs\includes\registry.inc).

Thanks / Tomas