Error on installing add-ons - ForeignKeyConstraintViolationException
An exception occurred while executing 'ALTER TABLE atFile ADD CONSTRAINT FK_73D17D61A2A82A5D FOREIGN KEY (avID) REFERENCES AttributeValues (avID) ON DELETE CASCADE': SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`exrx_concreteTest0101`.`#sql-636c_2c9a8`, CONSTRAINT `FK_73D17D61A2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE)
Obviously it's something related to the database, but I'm not sure what is it, anyone has experienced this before?
I have found this answer on Stackoverflowhttps://stackoverflow.com/questions/1253459/mysql-error-1452-cannot-...
But I can't follow the first answer to do the same thing to my database. Can someone help me with this?
Was your site developed on Windows and then moved to linux?
I contacted the "Website optimizer" add-on developer and gave him access to my website to test the add-on on my server, he also faced the same problem. Could it be a compatibility issue and he doesn't know about it?
I'm not sure about the Windows and Linux but I'm using the same host for years and nothing has changed lately.
Here's a long-shot: take new backups of your database and files (being careful NOT to overwrite your previous backups), and then try this:
I tried this add-on before but it couldn't handle the amount of images I have on the website, (4500 images), it was very slow, so I did rescan all images manually multiple times when I upgraded C5, last time was 3 weeks ago.