Migrating OJS from MySQL PHP5 system to PHP7 system with MySQLi database

biomat · February 7, 2022, 10:15pm

Description of issue or problem I’m having:

The new installation uses MySQLi that does not work with the database backed up from MySQL dump.

Steps I took leading up to the issue:

I backed up OJS 2.4.8.2 with MySQL database on PHP5 system,
Made a new installation and database on new PHP7 system, which uses MySQLi,
Tried to restore the data from the dump

What I tried to resolve the issue:

I tried various ways of restoring the database and nothing worked. The installation does not work properly if I set MySQL as a database and the MySQLi database does not accept the dump backup data from MySQL.

Application Version - e.g., OJS 3.1.2:

Tried to make it work with 2.4.8-2 and 2.4.8-5.

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

The display is not correct and the data of journals are not replicated.

kerimsarigul · February 8, 2022, 2:52am

Which version of PHP did you try?
PHP 7.0, 7.1, 7.4… ?

Wouldn’t you consider updating OJS itself as well?

biomat · February 8, 2022, 3:11am

PHP Version 7.4.27
Apache Version 2.4.52
MySQL Version 10.3.32-MariaDB

OJS Version currently functional 2.4.8-2 with MySQL
I’m trying to upgrade to OJS 2.4.8-5 to further upgrade the system to 3…
but I cannot get past the MySQL to MySQLi upgrade.

The current installation is on VPS with PHP5, and I’m trying to move to a shared server with PHP7, and can’t get it working. The system installs works fine but I cannot get the data moved to it.

asmecher · February 15, 2022, 1:56am

Hi @biomat,

Can you provide a little more detail about what’s working and what’s not? A screenshot or two might help. Versions 2.4.8-2 and 2.4.8-5 should be database-compatible.

Regards,
Alec Smecher
Public Knowledge Project Team

biomat · February 24, 2022, 2:49am

The admin pages work. The journal pages don’t. Below are some screenshots:

I get the same blank screen for all the links below:

http://cjci.org/mcfns/2485/14Feb22a/index.php/Journal
http://cjci.org/mcfns/2485/14Feb22a/index.php/Blind
http://cjci.org/mcfns/2485/14Feb22a/index.php/Journal/editor/submissions/submissionsInReview
http://cjci.org/mcfns/2485/14Feb22a/index.php/Journal/manager
http://cjci.org/mcfns/2485/14Feb22a/index.php/Journal/editor

Furthermore, if I rename the “blocks” in “plugins” then the blank screens disappear, but I don’t have proper display of what I want. If the blocks directory is present, then the display does not work even if the blocks directory doesn’t contain anything useful.

On the server with PHP5 only the versions 2.4.8-* work.
On the server with PHP7 only the version 3.3.0 works correctly. All the earlier versions have some things or other not working, so upgrading from 2.4.8-5 database from the PHP5 server doesn’t seem to be doable.

asmecher · February 24, 2022, 2:45pm

Hi @biomat,

Check the PHP error log; those blank pages should coincide with an error message.

Thanks,
Alec Smecher
Public Knowledge Project Team

biomat · February 24, 2022, 8:26pm

Here are the errors produced when the screen is blank in the presence of “blocks”:

text/x-generic php5_error_log ( ASCII text )
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of GenericPlugin::manage($verb, $args, &$message, &$messageParams) should be compatible with PKPPlugin::manage($verb, $args, &$message, &$messageParams, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/lib/pkp/classes/plugins/GenericPlugin.inc.php
At line: 58
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of WebFeedPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/webFeed/WebFeedPlugin.inc.php
At line: 147
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of TranslatorPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/translator/TranslatorPlugin.inc.php
At line: 57
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of TinyMCEPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/tinymce/TinyMCEPlugin.inc.php
At line: 425
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of ReferralPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/referral/ReferralPlugin.inc.php
At line: 44
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of AnnouncementFeedPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/announcementFeed/AnnouncementFeedPlugin.inc.php
At line: 101
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of GoogleAnalyticsPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/googleAnalytics/GoogleAnalyticsPlugin.inc.php
At line: 121
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of PhpMyVisitesPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/phpMyVisites/PhpMyVisitesPlugin.inc.php
At line: 106
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of BrowsePlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/browse/BrowsePlugin.inc.php
At line: 142
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of DataversePlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/dataverse/DataversePlugin.inc.php
At line: 157
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of DataversePackager::addFile($filePath, $fileName) should be compatible with PackagerAtomTwoStep::addFile($sac_thefile)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/dataverse/classes/DataversePackager.inc.php
At line: 57
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of UsageStatsPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/usageStats/UsageStatsPlugin.inc.php
At line: 186
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of ReportPlugin::manage($verb, $args) should be compatible with PKPPlugin::manage($verb, $args, &$message, &$messageParams, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/plugins/ReportPlugin.inc.php
At line: 231
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of UsageEventPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/usageEvent/UsageEventPlugin.inc.php
At line: 79
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of AcronPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/acron/AcronPlugin.inc.php
At line: 87
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of AcronPlugin::manage($verb, $args, &$message) should be compatible with GenericPlugin::manage($verb, $args, &$message, &$messageParams)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/acron/AcronPlugin.inc.php
At line: 104
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of PLNPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/pln/PLNPlugin.inc.php
At line: 428
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of OAIDAO::getEarliestDatestamp($setIds = Array) should be compatible with PKPOAIDAO::getEarliestDatestamp($selectStatement, $setIds = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/oai/ojs/OAIDAO.inc.php
At line: 57
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of & OAIDAO::setOAIData(&$record, &$row, $isRecord = true) should be compatible with & PKPOAIDAO::setOAIData($record, &$row, $isRecord)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/oai/ojs/OAIDAO.inc.php
At line: 231
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of JournalFileManager::downloadFile($filePath, $fileType, $inline = false) should be compatible with FileManager::downloadFile($filePath, $mediaType = NULL, $inline = false, $fileName = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/file/JournalFileManager.inc.php
At line: 47
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of IndexHandler::index($args, &$request) should be compatible with PKPHandler::index()
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/pages/index/IndexHandler.inc.php
At line: 32
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Parameter 2 to IndexHandler::index() expected to be a reference, value given
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/lib/pkp/classes/core/PKPRouter.inc.php
At line: 362
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of ManualPaymentPlugin::displayPaymentForm($queuedPaymentId, &$queuedPayment, &$request) should be compatible with PaymethodPlugin::displayPaymentForm($queuedPaymentId, $key, &$queuedPayment, $request)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/paymethod/manual/ManualPaymentPlugin.inc.php
At line: 84
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of PayPalPlugin::displayPaymentForm($queuedPaymentId, &$queuedPayment, &$request) should be compatible with PaymethodPlugin::displayPaymentForm($queuedPaymentId, $key, &$queuedPayment, $request)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/paymethod/paypal/PayPalPlugin.inc.php
At line: 117
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of IssueHandler::index($args, $request) should be compatible with PKPHandler::index()
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/pages/issue/IssueHandler.inc.php
At line: 39
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of IssueHandler::validate($request, $issueId = NULL, $galleyId = NULL) should be compatible with PKPHandler::validate($requiredContexts = NULL, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/pages/issue/IssueHandler.inc.php
At line: 265
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:05 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of InstitutionalSubscription::isValid($domain, $IP, $check = SUBSCRIPTION_DATE_BOTH, $checkDate = NULL) should be compatible with Subscription::isValid($check = SUBSCRIPTION_DATE_BOTH, $checkDate = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/subscription/InstitutionalSubscription.inc.php
At line: 121
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:06 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of InformationBlockPlugin::getContents($templateMgr, $request = NULL) should be compatible with BlockPlugin::getContents(&$templateMgr, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/blocks/information/InformationBlockPlugin.inc.php
At line: 45
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:06 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of LanguageToggleBlockPlugin::getContents($templateMgr, $request = NULL) should be compatible with BlockPlugin::getContents(&$templateMgr, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/blocks/languageToggle/LanguageToggleBlockPlugin.inc.php
At line: 90
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:06 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of WebFeedBlockPlugin::getContents(&$templateMgr) should be compatible with BlockPlugin::getContents(&$templateMgr, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/webFeed/WebFeedBlockPlugin.inc.php
At line: 98
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:06 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of AnnouncementFeedBlockPlugin::getContents(&$templateMgr) should be compatible with BlockPlugin::getContents(&$templateMgr, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/announcementFeed/AnnouncementFeedBlockPlugin.inc.php
At line: 87
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:21:06 America/Denver] ojs2 has produced an error
Message: WARNING: count(): Parameter must be an array or an object that implements Countable
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/roundedCorners/RoundedCornersPlugin.inc.php
At line: 56
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB

biomat · February 24, 2022, 8:36pm

And here are the errors after deleting the blocks (the page shows up but other things do not work):

text/x-generic php5_error_log ( ASCII text )
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of GenericPlugin::manage($verb, $args, &$message, &$messageParams) should be compatible with PKPPlugin::manage($verb, $args, &$message, &$messageParams, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/lib/pkp/classes/plugins/GenericPlugin.inc.php
At line: 58

[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of WebFeedPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/webFeed/WebFeedPlugin.inc.php
At line: 147

[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of TranslatorPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/translator/TranslatorPlugin.inc.php
At line: 57

[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of TinyMCEPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/tinymce/TinyMCEPlugin.inc.php
At line: 425

[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of ReferralPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/referral/ReferralPlugin.inc.php
At line: 44

[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of AnnouncementFeedPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/announcementFeed/AnnouncementFeedPlugin.inc.php
At line: 101

[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of GoogleAnalyticsPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/googleAnalytics/GoogleAnalyticsPlugin.inc.php
At line: 121

[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of PhpMyVisitesPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/phpMyVisites/PhpMyVisitesPlugin.inc.php
At line: 106

[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of BrowsePlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/browse/BrowsePlugin.inc.php
At line: 142

[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of DataversePlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/dataverse/DataversePlugin.inc.php
At line: 157
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of DataversePackager::addFile($filePath, $fileName) should be compatible with PackagerAtomTwoStep::addFile($sac_thefile)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/dataverse/classes/DataversePackager.inc.php
At line: 57
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of UsageStatsPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/usageStats/UsageStatsPlugin.inc.php
At line: 186
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of ReportPlugin::manage($verb, $args) should be compatible with PKPPlugin::manage($verb, $args, &$message, &$messageParams, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/plugins/ReportPlugin.inc.php
At line: 231
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of UsageEventPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/usageEvent/UsageEventPlugin.inc.php
At line: 79
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of AcronPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/acron/AcronPlugin.inc.php
At line: 87
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of AcronPlugin::manage($verb, $args, &$message) should be compatible with GenericPlugin::manage($verb, $args, &$message, &$messageParams)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/acron/AcronPlugin.inc.php
At line: 104
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of PLNPlugin::getManagementVerbs() should be compatible with GenericPlugin::getManagementVerbs($verbs = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/pln/PLNPlugin.inc.php
At line: 428
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of OAIDAO::getEarliestDatestamp($setIds = Array) should be compatible with PKPOAIDAO::getEarliestDatestamp($selectStatement, $setIds = Array)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/oai/ojs/OAIDAO.inc.php
At line: 57
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of & OAIDAO::setOAIData(&$record, &$row, $isRecord = true) should be compatible with & PKPOAIDAO::setOAIData($record, &$row, $isRecord)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/oai/ojs/OAIDAO.inc.php
At line: 231
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of JournalFileManager::downloadFile($filePath, $fileType, $inline = false) should be compatible with FileManager::downloadFile($filePath, $mediaType = NULL, $inline = false, $fileName = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/file/JournalFileManager.inc.php
At line: 47
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of IndexHandler::index($args, &$request) should be compatible with PKPHandler::index()
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/pages/index/IndexHandler.inc.php
At line: 32
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Parameter 2 to IndexHandler::index() expected to be a reference, value given
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/lib/pkp/classes/core/PKPRouter.inc.php
At line: 362
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of ManualPaymentPlugin::displayPaymentForm($queuedPaymentId, &$queuedPayment, &$request) should be compatible with PaymethodPlugin::displayPaymentForm($queuedPaymentId, $key, &$queuedPayment, $request)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/paymethod/manual/ManualPaymentPlugin.inc.php
At line: 84
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of PayPalPlugin::displayPaymentForm($queuedPaymentId, &$queuedPayment, &$request) should be compatible with PaymethodPlugin::displayPaymentForm($queuedPaymentId, $key, &$queuedPayment, $request)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/paymethod/paypal/PayPalPlugin.inc.php
At line: 117
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of IssueHandler::index($args, $request) should be compatible with PKPHandler::index()
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/pages/issue/IssueHandler.inc.php
At line: 39
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of IssueHandler::validate($request, $issueId = NULL, $galleyId = NULL) should be compatible with PKPHandler::validate($requiredContexts = NULL, $request = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/pages/issue/IssueHandler.inc.php
At line: 265
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:36 America/Denver] ojs2 has produced an error
Message: WARNING: Declaration of InstitutionalSubscription::isValid($domain, $IP, $check = SUBSCRIPTION_DATE_BOTH, $checkDate = NULL) should be compatible with Subscription::isValid($check = SUBSCRIPTION_DATE_BOTH, $checkDate = NULL)
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/classes/subscription/InstitutionalSubscription.inc.php
At line: 121
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:38 America/Denver] ojs2 has produced an error
Message: WARNING: count(): Parameter must be an array or an object that implements Countable
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/roundedCorners/RoundedCornersPlugin.inc.php
At line: 56
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:38 America/Denver] ojs2 has produced an error
Message: WARNING: count(): Parameter must be an array or an object that implements Countable
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/roundedCorners/RoundedCornersPlugin.inc.php
At line: 56
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB
[24-Feb-2022 13:30:38 America/Denver] ojs2 has produced an error
Message: WARNING: count(): Parameter must be an array or an object that implements Countable
In file: /home/cjcicie8/public_html/mcfns/2485/2485-15Feb22a/plugins/generic/roundedCorners/RoundedCornersPlugin.inc.php
At line: 56
Stacktrace:
Server info:
OS: Linux
PHP Version: 7.4.27
Apache Version: N/A
DB Driver: mysqli
DB server version: 10.3.34-MariaDB

asmecher · February 24, 2022, 8:44pm

Hi @biomat,

All I can see there are warnings, which shouldn’t cause the system to stop working; you’ll be looking for messages containing the word “Fatal”. I suspect they’re in the log but may be buried in warnings.

Regards,
Alec Smecher
Public Knowledge Project Team

biomat · February 24, 2022, 9:33pm

I searched through 60 MB of error logs (1.7 million lines), and I didn’t find a single “fatal”. The screens just do not show up, and I have no way to know whether they have crashed or not. However, after deleting all the Generic Plugins all the screens show up, but are incomplete.

Below is another example. I have deleted from my setup all the generic plugins, and now I see the screens but not the side columns (blocks), except for the screen on Setup 5, which shows them, but it cuts off the form after the Journal thumbnail (all other show complete forms but not side columns (blocks):

The same for the home screen, which is supposed to have the side bars:

kerimsarigul · February 25, 2022, 12:26am

I don’t know what @asmecher thinks about this method.
I once solved a big problem with this method.
Install a new ojs 2.4.8-2.
Then connect its database to your own database.
If it works fine, put the files in their place.
Then try the update steps.

I am using the following versions during updates:
OJS 2.4.8.4 - PHP 5.6
OJS 3.0.2.0 - PHP 7.1.3.3
OJS 3.1.2.4 - PHP 7.1.3.3
OJS 3.3.0.8 - PHP 7.4

biomat · February 25, 2022, 4:31am

I always upgrade through new installations.

I have perfectly running installations on PHP5 2.4.8.2 and 2.4.8-5.

I’m trying to move the installations to PHP 7.4 server, and I’m having problems with everything. 2.4.8-2&5 have issues on the PHP 7.4 server with displays as above. They run crippled after removing generic plugins. 3+ installations have also issues with the plugins.

I might have managed to upgrade the OJS 2.4.8-5 database to OJS 3.2.1-4. I got 10 mislabeled manuscripts so far and am not sure how the rest will work, and the displays and original look doesn’t work, but the process completed “successfully”, so there is a hope I’ll be able to work with the data.

Now, I’m trying to make the final upgrade of OJS 3.2.1-4 to OJS 3.3.0.8 (PHP 7.4), and I cannot get the database upgrade to work. The system does not work with the data upgraded from OJS 2+ to OJS 3.2.1-4, which might indicate that the previous upgrade wasn’t working after all.

mohd_arshad · February 25, 2022, 9:25am

this is my ojs upgrade history
ojs

what i do before transition to 3.1.2.1 is i uninstall all custom plugin and leave only default plugin through the system in ojs 2.4.8.0. and make sure in the ojs 2.4.8.0 database, the plugin is uninstall

on 3.1.2.1 im using php 7.1 if you are using php 7.4 here, some function is deprecated
on 3.2.1.4 to 3.3.0.8 im using php 7.4

biomat · February 25, 2022, 3:00pm

I go strictly by the PHP DOCS documentation as below:

I’m dealing with only two upgrades: 2.4.8-5 to 3.2.1-4 and the last one to 3.3.0-8. The earlier seem to work; although, it had some confused data, but no errors in execution, which is uplifting. The last one doesn’t. The upgrade script doesn’t return anything.

Disabling the plugins might be what I need, even though that demolishes all the work I put into the journal interface. How the disabled/uninstalled plugins are identified in the database? (I can figure it out). I’ll try that and will try again to upgrade from 3.2.1-4 to 3.3.0-8.

This is the most painful upgrade ever, and in addition, I liked the former functionality and design much better, which leaves me frustrated and bittered. If anyone knows of someone intending to take over the 2.x version development, please let me know. I’d be willing to pay some kind of reasonable membership fees for its continuation.

mohd_arshad · February 25, 2022, 3:25pm

make sure you do this in a copy of clean database from working ojs.
in the plugin_setting
setting_value context_id is your journal id, setting_name enable, setting_value, 0 is disable, 1 is enable
disable

almost all custom plugin develop for 2.4.8 is not compatible for 3.x

biomat · February 25, 2022, 3:33pm

Thank you; that’s helpful.

What’s the best way to go about disabling the plugins? through the interface? or through direct editing them in the database?

asmecher · February 26, 2022, 12:57am

Hi @biomat,

I think it would help to get yourself on secure footing before you start down several rabbit-holes at once.

It sounds like you did successfully upgrade to 3.2.1-x; that’s good, that’s a huge step. If you haven’t already, grab a snapshot of your database and everything else so you can return to it if need be.

You mentioned mislabeled submissions and issues with plugins. Let’s start there – what issues did you find in the 3.2.1-x installation after the upgrade from 2.x? Have you removed any of the plugins that came with OJS 3.2.1-x, or otherwise altered it since the upgrade ran successfully?

Regards,
Alec Smecher
Public Knowledge Project Team