I used the migrate_d2d to import content from a drupal6 to 7. Not sure if that has anything to do with it or not. After enabling forum access and acl I get this error when trying to create a new forum topic. I am using Advanced Forums. MySql server

[code]PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-40976' for key 'PRIMARY': INSERT INTO {acl_node} (nid, acl_id, grant_view, grant_update, grant_delete, priority) SELECT n.nid AS nid, 1 AS acl_id, 1 AS grant_view, 1 AS grant_update, 1 AS grant_delete, 0 AS priority FROM {taxonomy_index} n WHERE (n.tid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 2913 ) in acl_add_nodes() (line 115 of /srv/www/olecootscorner.com/public_html/sites/all/modules/acl/acl.module).[/code]

Comments

alforddm’s picture

alforddm commented

I managed to fix this by editing the container the forum was in. SEE THIS CONTAINER IN THE FORUMS SELECTION LIST was un-selected for anonymous users so I selected and saved and that fixed the error.

It was also giving me this same error when I tried to edit the forum (not the container) before I did the above edit.

salvis’s picture

salvis
he/his
commented
Title: PDOException: SQLSTATE[23000]: » PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ...: INSERT INTO {acl_node}
Status: Active » Closed (works as designed)

Sorry for the long delay and thank you for the follow-up.

It's strange that your container was not available, that you were able to select the forum when the container was not available, and even stranger that this would cause an error in ACL, but making the container available is certainly the way to go. Glad you were able to fix it.

At this point I don't see how this can be / would need to be fixed, marking WAD.

alforddm’s picture

alforddm commented

No, the container was available. The error only appeared when trying to create a new forum post. It wasnt just one container either it was several of them. I should add that when I imported with migrated2d the old containers didn't import as containers so I deleted them and readded. That may have had something to do with it as I had to move the sub forums.