New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
purge-deleted Only Deletes Some Records and Not Others #1524
Comments
We've seen this before where there are foreign keys preventing this deletion. Take a look in the database to see if there's anywhere those representations are being used (either a parent representation or maybe one of the ca_{tablename}_x_object_representations). Do a query to find out what the id's of the deleted representations are. ( |
@kehh Does that imply my object representations can't be deleted unless the object is also deleted? That would be... highly inconvenient. Foreign key constraints are a likely issue. I've traced the silent failure as far as providence/app/lib/BaseModel.php Line 3493 in d06f5b1
And I was going to try to pull the codes next. |
|
Here's the same query sent straight to the mysql client:
|
Good lord. So now I can't delete anything that has ever been downloaded? Is there no code to handle this? |
Purge the download log and delete whatever you want. Please keep in mind this is software for archival usage. For most users permanently deleting things is not desirable, especially if those things been interacted with (eg. downloaded). |
Got it but gee whiz. I'm trying to replace some representations and occasionally things get uploaded in error. Is this not a bug where I have to truncate a table to get the caUtils purge command to work as expected? |
I'm getting this same output everytime I run caUtils purge-deleted:
Those 52 representations and their associated media files aren't going away.
The text was updated successfully, but these errors were encountered: