Problem with upgrade OJS 2.4.8-5 to 3.1.2-1

Hi,

I have a problem with upgrading OJS from 2.4.8-5 to OJS 3.1.2-1.
First I have made a sandbox and first upgrade version 2.3.8 to 2.4.8-5.
Now I want to upgrade 2.4.8-5 to 3.1.2-1 and there is an error in php error logs that I didn’t find on PKP forum - can anyone help me with that? (php version is 7.2.25):

[05-Apr-2020 20:19:43 UTC] PHP Fatal error: Uncaught Exception: DB Error: Unknown database ‘fadmin2485’ Query: SHOW COLUMNS FROM plugin_settings LIKE ? in C:\wamp64V3\www\ojs-3.2.0-1\lib\pkp\classes\db\DAO.inc.php:703
Stack trace:
#0 C:\wamp64V3\www\ojs-3.2.0-1\lib\pkp\classes\db\DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), ‘SHOW COLUMNS FR…’)
#1 C:\wamp64V3\www\ojs-3.2.0-1\classes\core\Application.inc.php(200): DAO->retrieve(‘SHOW COLUMNS FR…’, Array)
#2 C:\wamp64V3\www\ojs-3.2.0-1\lib\pkp\classes\plugins\PluginSettingsDAO.inc.php(105): Application::getPluginSettingsContextColumnName()
#3 C:\wamp64V3\www\ojs-3.2.0-1\lib\pkp\classes\plugins\PluginSettingsDAO.inc.php(86): PluginSettingsDAO->getPluginSettings(‘0’, ‘announcementfee…’)
#4 C:\wamp64V3\www\ojs-3.2.0-1\lib\pkp\classes\cache\GenericCache.inc.php(63): PluginSettingsDAO->_cacheMiss(Object(FileCache), ‘enabled’)
#5 C:\wamp64V3\www\ojs-3.2.0-1\lib\pkp\classes\plugins\PluginSettingsDAO.inc.php(57): GenericCache->get(‘enabled’)
#6 C:\wamp64V3\www\ojs-3.2.0-1\lib\pkp\classes\plugins in C:\wamp64V3\www\ojs-3.2.0-1\lib\pkp\classes\db\DAO.inc.php on line 703

Thank you
Dorota

Hi @doridek,

I guess that happens right at the start of the upgrade, right?

From the error it looks like you forgot to configure the DB.

Regards, Primož

Hi @primozs,

Thank you for your answer. The problem was with database. It occured that the upgrade to 2.4.8-5 didn’t go well.

I’ve decided to upgrade 2.3.8 version first to 2.4.0 and then I will try to upgrade it to 2.4.8. But still I have some problems.

After choosing “upgrade” after about 1 min I recived that:
fo_upgrade_1

My error log:
[Sat Apr 25 08:31:17 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 71 bytes) in /home/fadmin/domains/forumoswiatowe.pl/public_html/ojs_kopia_do_testow/ojs2_4_0/lib/pkp/lib/adodb/adodb.inc.php on line 818, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade

So I have changed the memory_limit.

I have still the same statement on upgrade website but my error log has changed:

[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: ojs2 has produced an error, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: Message: WARNING: Cannot modify header information - headers already sent by (output started at /home/fadmin/domains/forumoswiatowe.pl/public_html/ojs_kopia_do_testow/ojs2_4_0/plugins/importexport/medra/classes/DOIExportPlugin.inc.php:1), referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: In file: /home/fadmin/domains/forumoswiatowe.pl/public_html/ojs_kopia_do_testow/ojs2_4_0/lib/pkp/classes/template/PKPTemplateManager.inc.php, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: At line: 337, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: Stacktrace: , referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: Server info:, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: OS: Linux, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: PHP Version: 5.3.29, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: Apache Version: N/A, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: DB Driver: mysql, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: ojs2 has produced an error, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: Message: WARNING: Cannot modify header information - headers already sent by (output started at /home/fadmin/domains/forumoswiatowe.pl/public_html/ojs_kopia_do_testow/ojs2_4_0/plugins/importexport/medra/classes/DOIExportPlugin.inc.php:1), referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: In file: /home/fadmin/domains/forumoswiatowe.pl/public_html/ojs_kopia_do_testow/ojs2_4_0/lib/pkp/classes/template/PKPTemplateManager.inc.php, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: At line: 340, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: Stacktrace: , referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: Server info:, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: OS: Linux, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: PHP Version: 5.3.29, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: Apache Version: N/A, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade
[Sun Apr 26 21:45:06 2020] [warn] [client 185.122.145.52] mod_fcgid: stderr: DB Driver: mysql, referer: https://forumoswiatowe.pl/ojs_kopia_do_testow/ojs2_4_0/index.php/index/install/upgrade

I don’t know what to do next. The database is now changed - it has 114 tables (in 2.3.8 there was 99 tables). And I didn’t receive the information about succesfull upgrade.

Can you help me?

Best regards
Dorota

OK,
I solved the problem. I have upgraded from 2.3.8 to 2.4.1, then to 2.4.8-5 and after that to 3.1.2-1.
The main problem was the PHP memory_limit that was to low and in 2.4.8-5 version I had to change the database driver form mysql to mysqli. Secondly I was trying to upgrade again with the same files. After downloading new installation files the upgrade went well.

Regards
Dorota