I have an old site that was on 5.7.5.13 and needs to go on to a box with php7.2 or higher.
I upgraded it to 8.1 and then if I go any further I get this error
An unexpected error occurred.
An exception occurred while executing ‘INSERT INTO CollectionAttributeValues (cID, cvID, akID, avID) VALUES (?, ?, ?, ?)’ with params [“494”, “1”, 5, null]: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (database_name
.CollectionAttributeValues
, CONSTRAINT FK_BB9995FCA2A82A5D
FOREIGN KEY (avID
) REFERENCES AttributeValues
(avID
))
Can anyone help?