Upgrade Error: OJS 3.2.1.4 to 3.3.0.14

Hi,

We successfully upgraded OJS 2.4.8.5 to OJS 3.0.2.
We successfully upgraded OJS 3.0.2 to OJS 3.1.2.4.
We successfully upgraded OJS 3.1.2.4 to OJS 3.2.1.4.

But when we upgrade OJS 3.2.1.4 to 3.3.0.14, 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?

Thanks…

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).

-Roger
PKP Team