Error in upgrading OJS

Software Support
1

Hi, we have been using OJS 3.2.1.4. and tried to upgrade to the most recent version OJS 3.3.0.11.

Followed the below mentioned steps.

  1. Uploaded upgrade files and saw blank page

  2. error as below :
    [26-Aug-2022 18:57:00 UTC] PHP Fatal error: Cannot override final method Plugin::getInstallSchemaFile() in /home/ecinorg/public_html/journal/ojs/plugins/generic/pln/PLNPlugin.inc.php on line 683

  3. deleted pln

[26-Aug-2022 18:59:09 UTC] PHP Fatal error: Cannot override final method Plugin::getInstallSchemaFile() in /home/ecinorg/public_html/journal/ojs/plugins/generic/sword/SwordPlugin.inc.php on line 330

deleted sword

Then upgrade started again however it failed with database errors .

OJS-SS

Kindly suggest ways to successfully upgrade the OJS.

Best,
EES office

2

Hi @INSEE-EES

Have you restored the database after deleting the plugins? It seems you are running into an error of a previous upgrade attempt. You need run the upgrade against an original state DB. Otherwise, it may remain changes from previous attempts that prevent from the upgrade script to run properly.

Best,
Israel

3

fresh attempt , did not delete the plugins . working ojs and started upgrades

# php tools/upgrade.php check
Code version:      3.2.1.4
Database version:  3.2.1.4
Latest version:    3.3.0.11
A newer version is available:
         tag:     3_3_0-11
         date:    2022-06-07
         info:    http://pkp.sfu.ca/ojs/
         package: http://pkp.sfu.ca/ojs/download/ojs-3.3.0-11.tar.gz
#


# php tools/upgrade.php check
Code version:      3.3.0.11
Database version:  3.2.1.4
Latest version:    3.3.0.11
Database version is older than code version
Run "tools/upgrade.php upgrade" to update


# php tools/upgrade.php upgrade
2022-09-19 17:10:59 [pre-install]
2022-09-19 17:10:59 [load: upgrade.xml]
2022-09-19 17:10:59 [version: 3.3.0.11]
2022-09-19 17:10:59 [code: Installer Installer::checkPhpVersion]
2022-09-19 17:10:59 [code: Installer Installer::installDefaultNavigationMenus]
2022-09-19 17:10:59 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
2022-09-19 17:10:59 [migration: PKPv3_3_0UpgradeMigration]
ERROR: Upgrade failed: DB: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'files' already exists (SQL: create table `files` (`file_id` bigint unsigned not null auto_increment primary key, `path` varchar(255) not null, `mimetype` varchar(255) not null) default character set utf8 collate 'utf8_general_ci')

same error.