I attempted to update the www.ncl.ecu.edu site to OJS 3.3.0-3. The site started at OJS 2.4.8-5 and was successfully upgraded to OJS 3.2.1-4.
I tried following the suggestions ojs-tools/fix-database-encoding.md at master · kaitlinnewson/ojs-tools · GitHub and Merge pull request #6744 from Vitaliy-1/i6743_review_files · pkp/pkp-lib@6dd9e2a · GitHub without success.
[pre-install]
[load: upgrade.xml]
[version: 3.3.0.3]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::installDefaultNavigationMenus]
WARNING: The NavigationMenu (ContextId: 1, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 1, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
[code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
[migration: PKPv3_3_0UpgradeMigration]
ERROR: Upgrade failed: DB: SQLSTATE[HY000]: General error: 1005 Can’t create table NCL
.#sql-4d6_2a07
(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
))