CiviCRM Community Forums (archive)

I have a bunch of ACL Role assignments where the Role now longer exists, but it still shows up on the assignment page, and probably adversely affecting my performance.

I tried running

DELETE FROM `civicrm_acl_entity_role` where `acl_role_id` NOT IN (SELECT id FROM civicrm_acl);

But the entries still show on the assignment page.

Any ideas?

1. Ah, that explains it. I wondered why there was no _acl_role table.

2. Most orphans were ACLs created by og_sync module. The only others were a few of the every first ACLs I created back in CiviCRM 1.7, and I likely manipulated the database manually for those.

In any case, I'd rather err on the side of leaving an unused record in the database than being over aggressive with FK constraints and cascading deletes, so I'm not worried about it. Now that I know roles are stored as option_values, I'm all set.