Staff Groups SQLSTATE error

[Joseph H]

Hello, Whenever I try to edit a staff group I end up with this error. Any Ideas, I have tried to go through "acl_acl" table but no luck

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '9-56-*' for key 'PRIMARY' on line 196 in /home/domain.com/public_html/vendors/minphp/db/src/PdoConnection.php 

Printing Stack Trace: 
#0 /home/domain.com/public_html/vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute(Array)
#1 /home/domain.com/public_html/vendors/minphp/record/src/Record.php(275): Minphp\Db\PdoConnection->query('INSERT INTO `ac...', Array)
#2 /home/domain.com/public_html/vendors/minphp/acl/src/Acl.php(407): Minphp\Record\Record->insert('acl_acl')
#3 /home/domain.com/public_html/vendors/minphp/acl/src/Acl.php(220): Minphp\Acl\Acl->addAcl('9', '56', '*', 'allow')
#4 /home/domain.com/public_html/app/models/staff_groups.php(532): Minphp\Acl\Acl->allow('staff_group_9', 'stats.admin_mai...', '*')
#5 /home/domain.com/public_html/app/models/staff_groups.php(110): StaffGroups->setPermissions('staff_group_9', Array, '1')
#6 /home/domain.com/public_html/app/controllers/admin_system_staff.php(375): StaffGroups->edit('9', Array)
#7 /home/domain.com/public_html/vendors/minphp/bridge/src/Lib/Dispatcher.php(142): AdminSystemStaff->editGroup()
#8 /home/domain.com/public_html/index.php(21): Dispatcher::dispatch('/admin/settings...')
#9 {main}

[Tyson]

You mentioned in a ticket with us that you were able to resolve this issue by deleting extraneous ACL permissions set from the stats plugin by @Blesta Addons, so I'm just posting that here in case anyone else has a similar issue.

[Blesta Addons]

11 hours ago, Tyson said:

You mentioned in a ticket with us that you were able to resolve this issue by deleting extraneous ACL permissions set from the stats plugin by @Blesta Addons, so I'm just posting that here in case anyone else has a similar issue.

we have the plugin installed and running in two production server from our side + 2 other testing servers, we have tested the edit staff group permissions in 4 servers without any issue . we will very happy to get more info from the OP to reproduce the issue and issue a fix if a issue was identified.

can you reinstall the plugin and try again, make sur you have the latest plugin version from our website .

[Joseph H]

4 hours ago, Blesta Addons said:

we have the plugin installed and running in two production server from our side + 2 other testing servers, we have tested the edit staff group permissions in 4 servers without any issue . we will very happy to get more info from the OP to reproduce the issue and issue a fix if a issue was identified.

can you reinstall the plugin and try again, make sur you have the latest plugin version from our website .

The issue we had is, when we unistalled the plugin, still some items were left in in acl_aco and in permissions table. It was solved soon as deleting these.

[Blesta Addons]

20 hours ago, Joseph H said:

The issue we had is, when we unistalled the plugin, still some items were left in in acl_aco and in permissions table. It was solved soon as deleting these.

We will replicate the issue and a fix will be released soon.