PDFs of some articles in a published issue keeps getting deleted/removed. This seems to happen randomly, in current and past issues. Even after editing the affected submissions and reuploading the removed PDFs, some still get removed after some time.
When an affected submission is viewed from the dashboard, the galley created is still there but without the PDF file.
Website running OJS 3.4.0.3 with Manuscript child theme.
This has been happening for a year now. How can this be fixed please?
See the attached screenshots below.
That’s very odd behaviour and hard to guess what’s happening from here – but as a start, I’d recommend upgrading to the latest 3.4.0-x release. A lot of bugs have been fixed since 3.4.0-3.
Regards,
Alec Smecher
Public Knowledge Project Team
I dont know if this is still a problem (About 80 results here):
SELECT *
FROM publication_galleys as pg1
WHERE pg1.submission_file_id
IN ( SELECT pg.submission_file_id
FROM publication_galleys as pg
LEFT JOIN submission_files as sf ON (pg.submission_file_id = sf.file_id)
WHERE pg.submission_file_id IS NOT NULL
AND sf.file_id IS NULL );
There are no errors in the log file and no detected pattern. At this moment we have uploaded again all the files but it just a matter of time before they disapear again.
This is still too vague for me to do much investigation, but just on a whim, do you use the XML import export tools? Can you check the access log for NativeImportExportPlugin to see if it appears with a POST request?
Regards,
Alec Smecher
Public Knowledge Project Team
@ugp2 and @PaideiaStudio, I think @ugp2 is right – the join on submission_files should use submission_file_id, notfile_id.
Unfortunately I can’t replicate this behaviour, so I’ll need someone who is experiencing it to investigate further and see if they can determine more about the causes and conditions.
Regards,
Alec Smecher
Public Knowledge Project Team