Hi @asmecher,
We have found three rows with file_stage 0. We tried to delete them, but
delete from submission_files WHERE file_stage=0; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (absojs.submission_file_revisions, CONSTRAINT submission_file_revisions_submission_file_id_foreign FOREIGN KEY (submission_file_id) REFERENCES submission_files (submission_file_id))
so we followed this: Upgrade to 3.3.0.8 An unexpected error has occurred - #3 by eddoff
and we changed the value 0 to 1 with no result, then to 10, which really helped.
But these very early 3 files become available too on the unassigned list. We could not deleted them.
So finally we assigned them to a technical support user to ending the disturbance in the Force.
What do you suggest, which file_stage would be the best to not to show these unnecessary files?
After your suggestion this thread coud be closed. Thank you!