Upgrade ojs from 3.1.2.4 to 3.3.0.4

Software Support
, ,
44

Hi,

I’m following this thread in doing a trial upgrade from OJS 3.2.12 to 3.3.0-5.
I successfully changed all the MyISAM tables into InnoDB before the upgrade (through web), and got this error message:

A database error has occurred: SQLSTATE[HY000]: General error: 1005 Can’t create table XXXX-db.submission_files (errno: 150 “Foreign key constraint is incorrectly formed”) (SQL: alter table submission_files add constraint submission_files_file_id_foreign foreign key (file_id) references files (file_id))

This is the error log.

[16-Apr-2021 12:33:25 ***] WARNING: The NavigationMenu (ContextId: 2, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
[16-Apr-2021 12:33:25 ***] WARNING: The NavigationMenu (ContextId: 2, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
[16-Apr-2021 12:33:25 ***] WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
[16-Apr-2021 12:33:28 ***] A submission file was expected but not found at journals/2/articles/21/submission/copyedit/21-1-61-1-9-20151124.pdf.
[16-Apr-2021 12:33:28 ***] A submission file was expected but not found at journals/2/articles/22/submission/copyedit/22-1-63-1-9-20151124.pdf.
[16-Apr-2021 12:33:28 ***] A submission file was expected but not found at journals/2/articles/23/submission/copyedit/23-1-65-1-9-20151126.pdf.
[16-Apr-2021 12:33:28 ***] A submission file was expected but not found at journals/2/articles/24/submission/copyedit/24-1-67-1-9-20151126.pdf.
[16-Apr-2021 12:33:28 ***] A submission file was expected but not found at journals/2/articles/25/submission/copyedit/25-1-69-1-9-20151126.pdf.
[16-Apr-2021 12:33:28 ***] A submission file was expected but not found at journals/2/articles/26/submission/copyedit/26-1-71-1-9-20151126.pdf.
[16-Apr-2021 12:33:29 ***] A submission file was expected but not found at journals/2/articles/71/submission/copyedit/71-1-159-1-9-20160330.pdf.
[16-Apr-2021 12:33:31 ***] A submission file was expected but not found at journals/2/articles/126/submission/review/126-1-277-1-4-20160725.doc.
[16-Apr-2021 12:33:35 ***] A submission file was expected but not found at journals/2/articles/335/submission/335-1-684-1-2-20160824.doc.
[16-Apr-2021 12:33:50 ***] A submission file was expected but not found at journals/2/articles/965/submission/965-1-2006-1-2-20161018.rar.
[16-Apr-2021 12:33:50 ***] A submission file was expected but not found at journals/2/articles/965/submission/review/965-1-2008-1-4-20161018.rar.
[16-Apr-2021 12:33:51 ***] A submission file was expected but not found at journals/2/articles/987/submission/query/987-1-2078-1-18-20161025.doc.
[16-Apr-2021 12:33:51 ***] A submission file was expected but not found at journals/2/articles/995/submission/995-1-2104-1-2-20161031.pdf.
[16-Apr-2021 12:34:20 ***] A submission file was expected but not found at journals/2/articles/1751/submission/query/1751-13-4956-2-18-20180417.jpg.
[16-Apr-2021 12:34:20 ***] A submission file was expected but not found at journals/2/articles/1751/submission/query/1751-13-4956-3-18-20180417.jpg.
[16-Apr-2021 12:34:20 ***] A submission file was expected but not found at journals/2/articles/1751/submission/1751-13-4974-2-2-20180419.jpg.
[16-Apr-2021 12:34:20 ***] A submission file was expected but not found at journals/2/articles/1750/submission/1750-13-4976-2-2-20180419.jpg.
[16-Apr-2021 12:34:57 ***] SQLSTATE[HY000]: General error: 1005 Can’t create table XXXX-db.submission_files (errno: 150 “Foreign key constraint is incorrectly formed”) (SQL: alter table submission_files add constraint submission_files_file_id_foreign foreign key (file_id) references files (file_id))

I did random check on path that reportedly missing file above e.g. journals/2/articles/21/submission/copyedit/21-1-61-1-9-20151124.pdf. and found no such path in the data folder, only journals/2/articles/21/submission NO copyedit subfolder. Same thing with this path: journals/2/articles/22/submission/copyedit/22-1-63-1-9-20151124.pdf.

Any ideas on what’s causing this and how to fix it?

Thanks.