Error on Salix 'clean' installation - C5 Version 8.0.3Browser Info Environment
An exception occurred while executing 'delete from Files where fID = ?' with params : SQLSTATE: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`omnicomd_dev`.`atFile`, CONSTRAINT `FK_73D17D61E3111F45` FOREIGN KEY (`fID`) REFERENCES `Files` (`fID`))
uninstalled Salix and tried again with the same result.
We have tested this using concrete5 v 8.0.3 and Salix v 1.1.0, first using Elemental theme without sample content and then with Elemental theme sample content. We have not been able to replicate this error. Possibly it is something to do with your development content in version 8?
Version 8 is still fairly new, possibly there could be a bug to do with this issue. For example:
I'm not sure if this is related or not to your error.
In any case, if you don't need your development content, and are going to overwrite it with Salix sample content, I would suggest that you try again with a clean install of concrete5 without the development content (delete the files and database and start from scratch). Before you do this, you should save your files and database in case you want to use them again.
If you want to keep your development content, you may need to look at your SQL and manually delete what it is complaining about. Make sure you save your original site's database and files first before you attempt to delete anything in SQL.
Love the Salix theme thus far.
I also removed any custom entities before I tried any of this, and it made no difference.
This was specifically tied to the Attributes structure - possibly the items are being removed in the wrong order by the installation of the theme. I had a lot of Attributes and values in my dev site.
Hope this helps.
Thank you for describing how you solved the problem. It may help other people if they encounter the same issue.