Upgrade problem OJS 3.1.1.4 to OJS 3.1.2

After click on button to upgrade to OJS 3.1.2 nothing happened. In browser received HTTP ERROR 500. Tested on PHP 7 to 7.3 and nothing. In Error log received>

[24-May-2019 17:58:18 Europe/Belgrade] PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/ijcadsee/public_html/lib/pkp/lib/adodb/drivers/adodb-mysql.inc.php:456
Stack trace:
#0 /home/ijcadsee/public_html/lib/pkp/lib/adodb/adodb.inc.php(558): ADODB_mysql->_connect(‘localhost’, ‘(removed)’, ‘(removed)’, ‘(removed)’)
#1 /home/ijcadsee/public_html/lib/pkp/classes/db/DBConnection.inc.php(151): ADOConnection->Connect(‘localhost’, ‘(removed)’, ‘(removed)’, ‘(removed)’, false)
#2 /home/ijcadsee/public_html/lib/pkp/classes/db/DBConnection.inc.php(126): DBConnection->connect()
#3 /home/ijcadsee/public_html/lib/pkp/classes/db/DBConnection.inc.php(83): DBConnection->initConn()
#4 /home/ijcadsee/public_html/lib/pkp/classes/db/DBConnection.inc.php(52): DBConnection->initDefaultDBConnection()
#5 /home/ijcadsee/public_html/lib/pkp/classes/db/DBConnection.inc.php(227): DBConnection->__construct()
#6 /home/ijcadsee/public_html/lib/pkp/classes/db/DBConnection.inc.php(238): DBConnection::getInstance()
#7 /home/ijcadsee/publi in /home/ijcadsee/public_html/lib/pkp/lib/adodb/drivers/adodb-mysql.inc.php on line 456

Any idea how to upgrade to OJS 3.1.2?

Hi @Lazar_Stosic,

I’ve modified your post to remove the database credentials – please be careful when posting stack traces! I’d recommend changing your database credentials immediately (along with anything else that shares those credentials).

Use the mysqli driver instead of mysql to resolve this. (PHP7 removes support for the older mysql driver.)

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher ,

Thank you for advice. Now everything working with upgrade and I solve the problem with upgrade.
After upgrade, I checked the control and find some field missing. For example, in review stage when want to send discussion there is not field for writing message.
Message
Some plugins doesn`t work> Keyword Cloud, Forthcoming… I tired to upload new plugin but the web page is empty.
For now, how to solve problem with empty field? Cannot communicate with authors or reviewers.

In Error log received>

[25-May-2019 08:43:57 Europe/Belgrade] PHP Warning: Declaration of DRIVERDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/driver/DRIVERDAO.inc.php on line 19
[25-May-2019 08:43:57 Europe/Belgrade] PHP Warning: Declaration of CustomBlockPlugin::getBlockContext() should be compatible with BlockPlugin::getBlockContext($contextId = NULL) in /home/ijcadsee/public_html/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 134
[25-May-2019 08:43:57 Europe/Belgrade] PHP Warning: Declaration of OpenAIREDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/openAIRE/OpenAIREDAO.inc.php on line 100
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of DRIVERDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/driver/DRIVERDAO.inc.php on line 19
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of CustomBlockPlugin::getBlockContext() should be compatible with BlockPlugin::getBlockContext($contextId = NULL) in /home/ijcadsee/public_html/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 134
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of OpenAIREDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/openAIRE/OpenAIREDAO.inc.php on line 100
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of DRIVERDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/driver/DRIVERDAO.inc.php on line 19
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of CustomBlockPlugin::getBlockContext() should be compatible with BlockPlugin::getBlockContext($contextId = NULL) in /home/ijcadsee/public_html/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 134
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of OpenAIREDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/openAIRE/OpenAIREDAO.inc.php on line 100
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of DRIVERDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/driver/DRIVERDAO.inc.php on line 19
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of CustomBlockPlugin::getBlockContext() should be compatible with BlockPlugin::getBlockContext($contextId = NULL) in /home/ijcadsee/public_html/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 134
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of OpenAIREDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/openAIRE/OpenAIREDAO.inc.php on line 100
[25-May-2019 08:43:59 Europe/Belgrade] PHP Warning: Declaration of QueryNoteFilesGridHandler::authorize($request, $args, $roleAssignments) should be compatible with SubmissionFilesGridHandler::authorize($request, &$args, $roleAssignments) in /home/ijcadsee/public_html/lib/pkp/controllers/grid/files/query/QueryNoteFilesGridHandler.inc.php on line 19
[25-May-2019 08:44:01 Europe/Belgrade] PHP Warning: Declaration of DRIVERDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/driver/DRIVERDAO.inc.php on line 19
[25-May-2019 08:44:01 Europe/Belgrade] PHP Warning: Declaration of CustomBlockPlugin::getBlockContext() should be compatible with BlockPlugin::getBlockContext($contextId = NULL) in /home/ijcadsee/public_html/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 134
[25-May-2019 08:44:01 Europe/Belgrade] PHP Warning: Declaration of OpenAIREDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /home/ijcadsee/public_html/plugins/generic/openAIRE/OpenAIREDAO.inc.php on line 100

Also a lot of missed fields in other section>
image

Missing Static pages…
image

Regards,
Lazar

Hi @Lazar_Stosic,

Try a hard refresh on your web browser; this may just be outdated cached Javascript.

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher ,

As always you are right. Thank you. The message box appeared after clearing cash in the browser. I only clear cash in OJS.
How can restore my static pages in the tab Static pages? The static pages exists and working but in the list are not presented.

Regards,
Lazar

1 Like

I think they are moved to Navigation menus after upgrade

Yes. I see it there but is that OK after upgrade or not? If it is OK, no problem. Just to solve this problem for next users who will have the same problem.

I think no problem with them. I do not know is it intentionally placed in the Navigation menus after the upgrade. @asmecher may have the explanation.

Hi all,

The static pages plugin is deprecated, and the upgrade should move content into the navigation menus toolset, which offers the same functionality but also tools to customize the menus to link to the pages.

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like

Hi @asmecher ,

Thanks for explanation. Now is more clear and can be closed this topic for future communications.

Regards,
Lazar

1 Like

We also lost some static pages during the upgrade. Moving the pages to navigation menus is fine, however, the database should be updated too. Currently the navigation menu content is “text” while the static pages content is “longtext”. Thus only the page title was migrated but the content was fully wiped. I think the upgrade script should be fixed to take care of this issue.

Hi @shubhash!

Thanks for the notice. This issue [Custom NMI content field should be compatible with Static Pages Field · Issue #4836 · pkp/pkp-lib · GitHub] is filed.

Regards,
@Dimitris_Efstathiou

I Have Some Problem when Upgrade OJS 3.1.4 to OJS 3.1.4
When install appearance blank white screen

I looking for logs

some error like this

Stack trace:
#0 /home/ejurnalbkkbn/public_html/lib/pkp/lib/adodb/adodb.inc.php(558): ADODB_mysql->_connect(‘localhost’, ‘admin’, ‘admin’, ‘password…’, ‘’)
#1 /home/ejurnalbkkbn/public_html/lib/pkp/classes/db/DBConnection.inc.php(151): ADOConnection->Connect(‘localhost’, ‘admin’, ‘admin’, ‘password…’, NULL, false)
#2 /home/ejurnalbkkbn/public_html/lib/pkp/classes/db/DBConnection.inc.php(126): DBConnection->connect()
#3 /home/ejurnalbkkbn/public_html/lib/pkp/classes/db/DBConnection.inc.php(113): DBConnection->initConn()
#4 /home/ejurnalbkkbn/public_html/lib/pkp/classes/db/DBConnection.inc.php(55): DBConnection->initCustomDBConnection(‘mysql’, ‘localhost’, ‘admin’, ‘password…’, NULL, false, false)
#5 /home/ejurnalbkkbn/public_html/lib/pkp/classes/install/PKPInstall.inc.php(76): DBConnection->__construct(‘mysql’, ‘localhost’, ‘admin’, ‘password’, NULL, f in /home/ejurnalbkkbn/public_html/lib/pkp/lib/adodb/drivers/adodb-mysql.inc.php on line 456

any solution Please…

Hi @Rashida_Lara,

You’ve posted the stack trace, but not the error message… Can you include the error message as well? It should appear just above the lines you posted.

Regards,
Alec Smecher
Public Knowledge Project Team

this is error message above

[05-Sep-2019 21:49:32 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically in /home/ejurnalbkkbn/public_html/lib/pkp/classes/form/Form.inc.php on line 377
[05-Sep-2019 21:49:32 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically in /home/ejurnalbkkbn/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 594
[05-Sep-2019 21:49:32 UTC] PHP Deprecated: Non-static method PKPRequest::isPost() should not be called statically in /home/ejurnalbkkbn/public_html/lib/pkp/classes/form/validation/FormValidatorPost.inc.php on line 38
[05-Sep-2019 21:49:32 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically in /home/ejurnalbkkbn/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 396
[05-Sep-2019 21:49:32 UTC] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; CounterReport has a deprecated constructor in /home/ejurnalbkkbn/public_html/plugins/reports/counter/classes/CounterReport.inc.php on line 33
[05-Sep-2019 21:49:32 UTC] PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/ejurnalbkkbn/public_html/lib/pkp/lib/adodb/drivers/adodb-mysql.inc.php:456

Hi @Rashida_Lara,

Have you tried the solution recommended in the second post?

Regards,
Alec Smecher
Public Knowledge Project Team

I Have Try… recomendation second post, but still blank white for instalation

Hi @Rashida_Lara,

The error message you quote will only happen with the mysql driver. Use the mysqli driver and check your error logs for a different message.

Regards,
Alec Smecher
Public Knowledge Project Team

Ok thanks for your support and Problem Solved when instalation I change database type form MySQL to MySQi

Thanks

Problem Solved

Very Nice

Dear @asmecher

This is what I was after (just looking in the wrong place). Having read into this thread, I finally found Navigation under Website settings > Setup > Navigation menu items > Instruction for Authors. So, would you recommend adding new pages here as opposed to static pages?

Thanks!
@asabhar