Hello, I have followed video on upgrading as well as the site but the process has failed due to database incompatibility. Another difference on our end is that I can only work in a cPanel’s terminal so I could only follow the steps to some extent. It appears that while the upgrade did succeed partially (3.3.9.9), the site will not open because the base URL that I am still using for an existing installation of 3.3.0.13 is on PHP 8.0 (I am reading warnings about trying newer PHP versions like 8.2. So, I was trying to install 3.5.0.4 in a designated subdomain with PHP set to 8.2 (I know it would work with 8.4 also), but the base URL in the config file has the domain which runs on 8.0. The other source of the failure is the database version, and I am copying the lines from the cPanel terminal (below the message). Am I missing a step or an installation component? Thank you in advance for any pointers!
Arjun @asabhar
pressuto@d14208.usc1.stableserver.net [dev.openjournals.utoledo.edu]# php tools/upgrade.php upgrade
2026-05-14 14:22:10 [pre-install]
2026-05-14 14:22:10 [load: upgrade.xml]
2026-05-14 14:22:10 [version: 3.5.0.4]
2026-05-14 14:22:10 [code: Installer Installer::checkPhpVersion]
2026-05-14 14:22:10 [code: Installer Installer::installDefaultNavigationMenus]
2026-05-14 14:22:10 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
2026-05-14 14:22:10 [migration: APP\migration\upgrade\v3_4_0\PreflightCheckMigration]
2026-05-14 14:22:10 [A pre-flight check failed. The software was successfully upgraded to 3.3.9.9 but could not be upgraded further (to 3.5.0.4). Check and correct the error, then try again.]
ERROR: Upgrade failed: DB: The base_url in config.inc.php should be the same as in URLs in the usage stats log file.
pressuto@d14208.usc1.stableserver.net [dev.openjournals.utoledo.edu]# php tools/upgrade.php upgrade
2026-05-14 14:24:15 [pre-install]
2026-05-14 14:24:15 [load: upgrade.xml]
2026-05-14 14:24:15 [version: 3.5.0.4]
2026-05-14 14:24:15 [code: Installer Installer::checkPhpVersion]
2026-05-14 14:24:15 [code: Installer Installer::installDefaultNavigationMenus]
2026-05-14 14:24:15 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
2026-05-14 14:24:15 [migration: PKP\migration\upgrade\v3_4_0\I10249_FixProfileImageDataLoss]
2026-05-14 14:24:15 [migration: APP\migration\upgrade\v3_4_0\PreflightCheckMigration]
2026-05-14 14:24:18 [A pre-flight check failed. The software was successfully upgraded to 3.3.9.9 but could not be upgraded further (to 3.5.0.4). Check and correct the error, then try again.]
2026-05-14 14:24:18 [revert migration: PKP\migration\upgrade\v3_4_0\I10249_FixProfileImageDataLoss]
2026-05-14 14:24:18 [downgrade for “PKP\migration\upgrade\v3_4_0\I10249_FixProfileImageDataLoss” unsupported: Downgrade not supported]
ERROR: Upgrade failed: DB: Storage engine that doesn’t support foreign key constraints detected in one or more tables: submission_file_settings, category_settings, submission_artwork_files, user_group_stage, genres, submission_tombstones, submission_supplementary_files, library_file_settings, user_groups, publication_settings, review_files, user_user_groups, stage_assignments, publications, review_round_files, genre_settings, publication_galleys, publication_galley_settings, item_views, queries, navigation_menu_item_assignment_settings, publication_categories, email_templates_settings, user_group_settings, library_files, navigation_menus, navigation_menu_item_settings, navigation_menu_items, categories, navigation_menu_item_assignments, query_participants. Change to InnoDB before running the upgrade.