We successfully upgraded OJS 184.108.40.206 to OJS 3.0.2.
We successfully upgraded OJS 3.0.2 to OJS 220.127.116.11.
We successfully upgraded OJS 18.104.22.168 to OJS 22.214.171.124.
But when we upgrade OJS 126.96.36.199 to 188.8.131.52, We get error message as
Errors occurred during installation:
• A database error has occurred: SQLSTATE[HY000]: General error: 1005 Can’t create table
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 (
How can we solve this problem?
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).