/
Saving changes to permissions in the sales order form errors 'Cannot insert duplicate key row ...SY_UserGroupPermissions...'
Saving changes to permissions in the sales order form errors 'Cannot insert duplicate key row ...SY_UserGroupPermissions...'
Problem
Setting permissions in the Utilities tab of sales orders and saving the changes errors with the issue
Solution
The problem is caused by the Sales Order Customer Panel being enabled.
To allow changes to sales order permissions to be saved, do he following
System Settings > Plugins > Plugin Maintenance
Load the Sales Order Customer Panel plugin and disable it
Save changes and log out
Log back in and set the permissions needed in the sales order form and save changed
Load the Sales Order Customer Panel plugin and enable it
Save change, log out and log back in again
Related articles
, multiple selections available,
Related content
Saving a new record reports a duplicate key error
Saving a new record reports a duplicate key error
More like this
Archiving sales order data error - 'CREATE TABLE permission denied in database ...'
Archiving sales order data error - 'CREATE TABLE permission denied in database ...'
More like this
Cannot insert duplicate key row in object ....
Cannot insert duplicate key row in object ....
More like this
Error when printing from a sales order to the screen - 'You do not have permissions ..'
Error when printing from a sales order to the screen - 'You do not have permissions ..'
More like this
Error logging in to a newly upgraded database - duplicate key value supplied
Error logging in to a newly upgraded database - duplicate key value supplied
More like this
'Key already exists' error is reported opening a form e.g. EFT / Cheque Payments
'Key already exists' error is reported opening a form e.g. EFT / Cheque Payments
More like this