When issuing grants to any role, I am unable to use the "with children" option. When I select a root, or any parent, in the hierarchy and click add I receive the following error:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-4' for key 'PRIMARY': INSERT INTO {taxonomy_access_term} (tid, rid, grant_view, grant_update, grant_delete, grant_create, grant_list) 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); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => 4 [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 0 ) in drupal_write_record() (line 6868 of /var/www/drupal-7.8/includes/common.inc).

When I go back to the grants page, the parent that was selected HAS been added but the children have not.

Files: 
CommentFileSizeAuthor
#4 1272242-fix-and-test.patch2.79 KBxjm
PASSED: [[SimpleTest]]: [MySQL] 1,865 pass(es).
[ View ]
#2 1272242-test-only.patch2.28 KBxjm
FAILED: [[SimpleTest]]: [MySQL] 1,865 pass(es), 0 fail(s), and 1 exception(es).
[ View ]

Comments

Priority:Normal» Major

Michelle confirmed this same bug.

Bumping to major.

Status:Active» Needs review
StatusFileSize
new2.28 KB
FAILED: [[SimpleTest]]: [MySQL] 1,865 pass(es), 0 fail(s), and 1 exception(es).
[ View ]

Here's a patch that adds a test that should fail without a fix.

Status:Needs review» Needs work

The last submitted patch, 1272242-test-only.patch, failed testing.

Status:Needs work» Needs review
StatusFileSize
new2.79 KB
PASSED: [[SimpleTest]]: [MySQL] 1,865 pass(es).
[ View ]

And, a patch with a fix.

Status:Fixed» Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.