Serious issue with Database upgrade (failed from 3.2.1.3 to 3.3.0.2)

Hi @Carlo_Manuali,

The error means that in the database, review_round_files table during upgrade has values in submission_file_id that don’t correspond to the values in submission_files table, submission_file_id column.

This should be fixed as part of this issue: Foreign key constraint error during upgrade in review_round_files.submission_file_id · Issue #6337 · pkp/pkp-lib · GitHub, so I’m not sure why the error occurs in your case. Can you follow the debugging procedure there and look at the partially updated database for those values:

SELECT submission_file_id FROM review_round_files LEFT JOIN submission_files USING (submission_file_id) WHERE submission_files.submission_file_id IS NULL