8.5.1 - Integrity Constraint Violation Error
Permalink
Hi all,
I'm having some issues with duplicate entries when using Express. I've developed an interface which some users have access to where they can add create, update and delete permissions and users (apart from admin users).
Using the C5 Docs code for handling Express User Attributes I am getting the following error when removing all of a users selected options for an express attribute and then trying to re-add them.
An exception occurred while executing
I'm a little confused as I found a related post (https://www.concrete5.org/developers/bugs/8-5-0/uograde-to-8.5.1-exp... ) which aembler responded saying it was possibly the database charset, I can confirm the functionality is working on 8.4.* but not 8.5.*
Can anyone help with this?
I'm having some issues with duplicate entries when using Express. I've developed an interface which some users have access to where they can add create, update and delete permissions and users (apart from admin users).
Using the C5 Docs code for handling Express User Attributes I am getting the following error when removing all of a users selected options for an express attribute and then trying to re-add them.
An exception occurred while executing
'INSERT INTO atExpressSelectedEntries (avID, exEntryID) VALUES (?, ?)' with params [47199, 540]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '47199-540' for key 'PRIMARY
I'm a little confused as I found a related post (https://www.concrete5.org/developers/bugs/8-5-0/uograde-to-8.5.1-exp... ) which aembler responded saying it was possibly the database charset, I can confirm the functionality is working on 8.4.* but not 8.5.*
Can anyone help with this?
