Upgrade from 2.4.8.5

Hi, four years back, I tried to upgrade my OJS 2.4.8.5 installation and a detailed comments on the issue are available in the closed ticket;

I have learned MySQL structure of OJS 2.4.8.5 in detail and dropped the mix tables. Now, I assume that my database is cleaned and I tried to upgrade to OJS 3.1.2.4 however, my upgrade stopped at the following point with no error log;

[code: Installer Installer::provideSupplementaryFilesForReview]

When I change to

installed = on

The website, I believe, loads fine. However, the next upgrade to OJS 3.2.1.5 stopped at the following point;

Code version: 3.2.1.5
Database version: 2.4.8.5
Latest version: 3.4.0.8
Database version is older than code version
Run “tools/upgrade.php upgrade” to update
[user@server [installation folder]$ php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 3.2.1.5]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::syncSeriesAssocType]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics2.xml (skipped)]
[code: Installer Installer::removeReviewEntries]
[user@server

DB Error: Duplicate entry '3-0-4' for key 'user_group_stage_pkey'

[user@host installation_directory]

Hi @esciencepress,

You may want to have a look at this post here: OJS 2.4.7 to 3.0.0 upgrade problems - #4 by knjigor

It seems like a similar issue.

-Roger
PKP Team

Hi @rcgillis and @asmecher

Thank you. Since, I compared database tables of my OJS2.4.8.5 with a fresh installation and deleted unnecessary tables which were mixed during a failed upgrade. Now, I changed lib/pkp/classes/security/UserGroupDAO.inc.php line 88 from…

return $this->getInsertId();

…to…

return $userGroup->getId();

and tried upgrading from OJS 2.4.8.5 to OJS 3.0.0. Thank you so much, Successfully upgraded to version 3.0.0.0 I am so happy as the database cleanup took years. I will further try to upgrade to the latest versions step by step.

1 Like

Hi, I have been able to successfully upgrade to OJS 3.3.0.20 however, special characters on the text are not displaying correctly. I have gone through the post;

But no luck, please.

I reverted back and upgraded 2.8.5.0 to 3.0.0 = Successfull (with the following)
connection_charset = utf-8

Upgraded 3.0.0 to 3.1.2.4 = Successful (with the following changes:)

Upgraded 3.1.2.4 to 3.2.1.4 = Successful (with the following modifications)

SET default_storage_engine = ‘InnoDB’;

Tried to upgrade from 3.2.1.4 to 3.3.0.19 with the following;

‘engine’ => ‘InnoDB’,

The upgrade doesn’t proceed with

connection_charset = utf-8

It proceeds succussfully with

connection_charset = utf8

but characters show error for example (Côte d’Ivoire) appears (Côte d’Ivoire)

I tried to upgrade with connection_charset = utf8 and later changed connection_charset = utf-8 but website doesn’t load.

This topic was automatically closed after 7 days. New replies are no longer allowed.