Error Deleting Attribute with 5.8.1
Permalink Browser Info Environment
This is likely an issue because 5.8.1 has a lot of changes with the attributes system. However what's happening is that I'm getting an exception:
An exception occurred while executing 'DELETE FROM AttributeKeys WHERE akID = ?' with params [114]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`test_c5`.`atEmptySettings`, CONSTRAINT `FK_ED1BF189B6561A7E` FOREIGN KEY (`akID`) REFERENCES `AttributeKeys` (`akID`))
If I execute this SQL:
DELETE FROM `test_c5`.`atEmptySettings` WHERE `atEmptySettings`.`akID` = 114
prior to deleting the attribute, it is remove successfully. It looks like the delete is not being done by your code at all - but by different code entirely.
An exception occurred while executing 'DELETE FROM AttributeKeys WHERE akID = ?' with params [114]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`test_c5`.`atEmptySettings`, CONSTRAINT `FK_ED1BF189B6561A7E` FOREIGN KEY (`akID`) REFERENCES `AttributeKeys` (`akID`))
If I execute this SQL:
DELETE FROM `test_c5`.`atEmptySettings` WHERE `atEmptySettings`.`akID` = 114
prior to deleting the attribute, it is remove successfully. It looks like the delete is not being done by your code at all - but by different code entirely.
| Type: | Discussion |
|---|---|
| Status: | In Progress |
Thank you for letting us know. We have just uploaded version 1.1 which fixes this issue.
hey, I still have the problem with version 1.1 of the fileset attribute.
Here is a fix in the fileset/controller.php to avoid the constraint error.