Removing references to files that no longer exist


Some years ago the server that hosts our OJS (now version 2.4.7) had a disk crash and files were lost. Altought most of them were recovered, there are in the database hundreds of references to files and supplementary files that no longer exist. This thing annoys me every time I have to run the upgrade process, giving me hundreds of useless error messages. Is there a way to remove the references to those files?



Hi @Oberdan,

Your best bet is to compare the database (particularly article_files in OJS 2.x) against the contents of the filesystem – we don’t have any tools in particular to accomplish this. But note that only the 2.x to 3.x upgrade makes any changes to the file storage area, so you won’t be pestered about missing files on all upgrades, just that one.

Alec Smecher
Public Knowledge Project Team