File Manager
Permalink
Hi,
when we wont delete some files we have the following Error:
An exception occurred while executing 'delete from Files where fID = ?' with params [18]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`dbc5_herrischried_de`.`atFile`, CONSTRAINT `FK_73D17D61E3111F45` FOREIGN KEY (`fID`) REFERENCES `Files` (`fID`))
It seams that the files are used somewhere. We delete all Albums and so on, but still not able to delete the files.
Whitch possibility we have to delete the files?
Martin
when we wont delete some files we have the following Error:
An exception occurred while executing 'delete from Files where fID = ?' with params [18]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`dbc5_herrischried_de`.`atFile`, CONSTRAINT `FK_73D17D61E3111F45` FOREIGN KEY (`fID`) REFERENCES `Files` (`fID`))
It seams that the files are used somewhere. We delete all Albums and so on, but still not able to delete the files.
Whitch possibility we have to delete the files?
Martin
It looks like this file was set to be a page's attribute at one time. Unfortunately unless you know on which page and delete all old page versions I don't know how you can fix this.
Thx hutman,
we delete all pages where we use the files. Didn't help.
The file was used before in an Express Data Object. All this is deleted.
Now only 4 files left from 16ten. 3 of them have no name noting and file type no name. One still have all file name etc.
Still the question, how to delet the files.
we delete all pages where we use the files. Didn't help.
The file was used before in an Express Data Object. All this is deleted.
Now only 4 files left from 16ten. 3 of them have no name noting and file type no name. One still have all file name etc.
Still the question, how to delet the files.
Have you deleted all the pages from the Trash as well? I thought that in 5.7+ the attribute rows were removed when pages were deleted, but it's possible that's still an issue.
If that's the case there is no easy way to delete those files, unless somebody else in the community knows a clever way to clean up attribute abandoned records.
If that's the case there is no easy way to delete those files, unless somebody else in the community knows a clever way to clean up attribute abandoned records.
We delete trash as well before.
