Upgrade Error: OJS to


We successfully upgraded OJS to OJS 3.0.2.
We successfully upgraded OJS 3.0.2 to OJS
We successfully upgraded OJS to OJS

But when we upgrade OJS to, We get error message as

Errors occurred during installation:
• A database error has occurred: SQLSTATE[HY000]: General error: 1005 Can’t create table eurjchem_ojs3214-2.review_round_files (errno: 150 “Foreign key constraint is incorrectly formed”) (SQL: alter table review_round_files add constraint review_round_files_submission_file_id_foreign foreign key (submission_file_id) references submission_files (submission_file_id)).

How can we solve this problem?


Hi @eurjchem,

Some users reported similar errors here: Upgrade from OJS 3.2.1-4 to OJS 3.3.0-3 fails. PDOException ... Can't create table ... Foreign key constraint is incorrectly formed - #3 by yfktn

You may want to try what is suggested there (with having backups in place).

PKP Team