I upload a new file, save the discussion and delete it again. If I then open “Editorial History”, the data cannot be loaded.
Error message:
PHP Fatal error: Call to a member function getStageId() on null in …lib/pkp/classes/submission/PKPSubmissionFileDAO.inc.php on line 762, referer:…/index.php/journal2/workflow/index/88/3
The item in table “notes” is deleted, but the file is still listed in “submission_files” with assoc type 520 and assoc id pointing to the deleted note.
best,
Carola
P.S. Is it save to delete the line in table submission_files?
I had a look through the 3.1.2 code and no, query deletion does not remove files that may have been associated with a review discussion. Review discussion can include files from other areas of the workflow so there’s probably good reason for that.