OJS upgrade from 2.4.2.0 to 2.4.8.5

[ischolar]

Hello,

We would like to upgrade the OJS from 2.4.2.0 to highest version so before we upgrade would like to follow step by step to upgrade process with the following requirements.

Step by Step process to upgrade:
From To Description
< 2.4.8 2.4.8-x Before upgrading to 3.x, make sure you are upgraded to the latest 2.4.8-x build.
2.4.8-x 3.2.1-x You can not upgrade to 3.3.x or later from 2.x
3.2.1-x 3.3 >= Upgrade from 3.2.1-x to any version 3.3 or later.

System Requirement for installing OJS 2.4.8.5

• PHP 5.X highest build
  *MySql 5.X highest build
  *OS platform Linux

Please confirm I’m going with the correct process?

[marc]

Yes, you are.

You will also need to take in consideration this:

Issue with supplementary files in upgrading from OJS 2.4.8-1 to OJS 3.2.1-1

Hi @juanf.csic When you say the supplementary files do not appear on the submissions do you mean they are not even in galleys? We have previous posts where some users had to manage a few issues with supplementary files. Would you happen to have a look? There is also a patch that prevents supp files from being migrated as galleys and migrates them as submission files. Please see it here: pkp/pkp-lib#3016 patch not to migrate supp files as galleys but as su… by bozana · Pull Request #2021 · pk…

TL;DR;

Supplementary files will be visible or invisible to readers depending on the destination version:

• If you want to make them visible, make a pit-stop at 3.1.2-4 (and then jump to 3.3 LTS or whatever).
• If you want to keep hide them, upgrade to version 3.2.1-6 (or stable-3.2).

Cheers,
m.

[ischolar]

Hello,

While upgrading from 2.4.2.0 to 2.4.8.5 we are facing following error.

[jattjournal@node6480 tools]$ php upgrade.php check
Code version: 2.4.8.5
Database version: 2.4.2.0
Latest version: 3.4.0.1
Database version is older than code version
Run “upgrade.php upgrade” to update
[jattjournal@node6480 tools]$ php upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 2.4.8.5]
[schema: lib/pkp/xml/schema/signoff.xml]
[data: dbscripts/xml/upgrade/2.4.3_preupdate_usageStatistics.xml]
ERROR: Upgrade failed: DB: Table ‘article_galleys_stats_migration’ already exists

screenshot for reference.
https://prnt.sc/MkoU298apmoM

[abadan]

Hi @ischolar

This table only exists during the upgrade, it shouldn’t exist when you start a new one.

If there was a previous failed upgrade attempt, first replace with a healthy base, with no additional tables or tables modified by an upgrade process.

[ischolar]

Hello Abadan,

while upgrading the OJS version from 3.2.1.4 to 3.3.0.15 but we are facing the following error.

ERROR: Upgrade failed: DB: SQLSTATE[HY000]: General error: 1824 Failed to open the referenced table ‘submission_files’ (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))

[ischolar]

we have rectified the above trail error and found the other following error.

ERROR: Upgrade failed: DB: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘url’ in ‘field list’ (SQL: select url, navigation_menu_item_id from navigation_menu_items where context_id = 289)

[ischolar]

we are facing issue ordering, not able to order the issue, below is the error

[11-Aug-2023 08:20:03 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘9756’ for key ‘custom_issue_orders.custom_issue_orders_pkey’ in /home/installationname/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119

[ischolar]

@asmecher

Hello ,

We have upgraded the OJS version successfully but administration page is not opening with admin login. Its getting error : DNS_PROBE_FINISHED_NXDOMAIN

error log: PHP Warning: ini_set(): A session is active. You cannot change the session module’s ini settings at this time in /lib/pkp/classes/session/SessionManager.inc.php on line 71