[OJS] - Published issues not showing individual articles


Thank you to all who assisted with my problem previously.

Currently, we successfully restored our OJS installation to with all of the data intact in the SQL tables, files stored locally on our server, and are able to proceed as per usual with our publications without any major problems. However, we are noticing an odd issue that I’m not sure how to proceed with.

When we attempt to create a new issue of one of our journals and attach the submissions we created within that journal, the submission then shows up with the name and information from another one of the journals that is completely unrelated to the journal we’re working with.

Additionally, the previous issues that were published are showing the full Galley image for the full journal issue but not the individual articles, table of contents, or other information. I’m not sure if that’s a setting that needs to be adjusted, fixed in the administration menu, or an SQL value fix that I’m not familiar with (as evidenced by my previous topics).

Any assistance from the community on this, or a point in the right direction, would be much appreciated.

Thank you.


Found the issue - the ‘submission_file’ SQL table is wrong. The values that I copied over were incorrect and I need to update them in order to get things working again. The files are all there but I’m missing columns, columns are identified incorrectly, and a few other things that need to be fixed.

@asmecher is there a script that the system runs against the database that I might be able to run separately in order to update ONLY key sections of the database in order to get it to work? There’s two tables that need to be updated and I’m wary of absolutely messing everything up.

Thank you.