I am trying to upgrade OJS from 3.1.1.4 to 3.3.0.5. While upgrading, it is showing this database error, as I have dropped the dataset and re-created it. Then uploaded the database from the backup (before 1st upgrade), but still facing the issue. This time it is showing the following error.
A database error has occurred: SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `submission_file_revisions` add constraint `submission_file_revisions_submission_file_id_foreign` foreign key (`submission_file_id`) references `submission_files` (`submission_file_id`))
Please Guide.