Upgrading 7.5.13 to 8.2.1
Permalink
`A foreign key constraint fails`
During upgrading, I am having an error given below, and the site is completelly fails. Only way to restore it again. Can one of you tell me what is wrong with this?
Please see screenshot.
An exception occurred while executing 'INSERT INTO CollectionAttributeValues (cID, cvID, akID, avID) VALUES (?, ?, ?, ?)' with params ["234", "1", 5, null]: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`batcom_4`.`CollectionAttributeValues`, CONSTRAINT `FK_BB9995FCB6561A7E` FOREIGN KEY (`akID`) REFERENCES `AttributeKeys` (`akID`))
During upgrading, I am having an error given below, and the site is completelly fails. Only way to restore it again. Can one of you tell me what is wrong with this?
Please see screenshot.
An exception occurred while executing 'INSERT INTO CollectionAttributeValues (cID, cvID, akID, avID) VALUES (?, ?, ?, ?)' with params ["234", "1", 5, null]: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`batcom_4`.`CollectionAttributeValues`, CONSTRAINT `FK_BB9995FCB6561A7E` FOREIGN KEY (`akID`) REFERENCES `AttributeKeys` (`akID`))
This I mangeded manually, because it was a 4 pages website with copy paste. The other one still is a nightmare because have around 200 pageshttp://kordil.com.tr and is not easy to do it manually.
I just checked your site. Looks like is up and running with version 8.5.2. Are you still getting that error?