error in upgrading 3.2.1.5 to 3.4.0.9
Errors occurred during installation:
- A database error has occurred: SQLSTATE[HY000]: General error: 1005 Can’t create table
ojs.submission_file_revisions (errno: 150 “Foreign key constraint is incorrectly formed”) (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))
Hi @samanalmufti,
See e.g. Upgrade to 3.3: default database engine doesn't support foreign key constraint · Issue #6732 · pkp/pkp-lib · GitHub and other threads on this forum; the likely problem is that your MySQL database is not fully using the InnoDB storage engine. You’ll need to make sure everything uses InnoDB before you can upgrade to 3.4.0-x or newer.
(This is more of a MySQL question than an OJS question, so you might find good guidance on e.g. StackOverflow.)
Regards,
Alec Smecher
Public Knowledge Project Team
1 Like
