Upgrade ojs 3.1.2.1 to 3.3.0.7

Software Support
1

Description of issue or problem I’m having:
It is possible to upgrade directly from ojs version 3.1.2.1 to 3.3.0.7 without going through the previous ones
If not, what are the necessary steps and what upgrade must be done?

Steps I took leading up to the issue:

What I tried to resolve the issue:

Application Version - e.g., OJS 3.1.2:

Additional information, such as screenshots and error log messages if applicable:

2

Hi @cfrgzl,

Yes, this should be possible. You may wish to have a look at our upgrade guide, which provides comprehensive guidance on upgrades: How to Upgrade

-Roger
PKP Team

3

Hi @rcgillis

First of all, thanks for your help, sorry, but so far I haven’t put in the update. After doing the steps indicated, link

It gives me the following error PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002]

PHP 7.3.33 (cli) (built: Nov 16 2021 11:18:28) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.33, Copyright (c) 1998-2018 Zend Technologies

server version: 5.6.51 MySQL Community Server (GPL)qui

httpd.service - The Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
Active: active (running) since mié 2022-03-02 16:12:34 CET; 2 weeks 0 days ago
Docs: man:httpd(8)
man:apachectl(8)
Process: 99437 ExecReload=/usr/sbin/httpd $OPTIONS -k graceful (code=exited, status=0/SUCCESS)

Copyright (c) 2000, 2021, Oracle and/or its affiliates. All rights reserved

befor changes
[root@manojs tools]# php upgrade.php check
Code version: 3.1.2.1
Database version: 3.1.2.1
Latest version: 3.3.0.10
A newer version is available:
tag: 3_3_0-10
date: 2022-03-07
info: http://pkp.sfu.ca/ojs/
package: http://pkp.sfu.ca/ojs/download/ojs-3.3.0-10.tar.gz

after changes
php upgrade.php check
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No existe ninguna ruta hasta el `host’ in /var/www/html/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:38
Stack trace:
#0 /var/www/html/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(38): PDO->__construct(‘mysql:host=10.5…’, ‘admbdojs’, ‘*******’, Array)
#1 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct(‘mysql:host=10.5…’, ‘admbdojs’, ‘***’, Array)
#2 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection(‘mysql:host=10.5…’, ‘admbdojs’, '’, Array)
#3 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/

4

Hi @cfrgzl,

Thanks for sharing this additional info. Not entirely sure what might be causing this, but I’ll see if I can get one of my team members to assist when available.

-Roger
PKP Team

5

This error means your MySQL server is refusing connections (probably because it’s listening on another port, different from what you have on your config.inc.php). It’s not exactly an OJS error, but something lower level.

6

hi janiosarmento
I have decided not to upgrade, I am going to install the new version 3.3.0.10 from the beginning on a new machine. To have a clean configuration of config.inc.php and to have clear connections to the database.

7

Did you manage in the end?

I am in the same situation: I still have PHP 5.4 installed, and have been delaying my upgrades. Last time I tried, the site was not working afterwards so had to rollback.

If you reinstalled, how did you not lose any work in the databases?

thanks

8

OK managed to upgrade oon a sandboxed env.

I actually went thtough each major version, updating only the database each time.

Now I need to sort out my custom theme and plugins.

ssciberras