Update from 3.1.4 to 3.3.0.6 error

Hello @rcgillis
After update version- 3.1.1.4 to 3.3.0-4 facing error

Article missing in archive pages. Dashboard submission page getting HTTP ERROR 500 .

when update ojs in Command-line showing [code: Installer Installer::migrateUserAndAuthorNames (skipped)]

Attached Archive page screenshot

ojsupdateerror

See the below Command-line process
[XXXXX@XXXXXX XXXXXXXX.com]$ php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 3.3.0.4]

[code: Installer Installer::checkPhpVersion]

[code: Installer Installer::migrateSubmissionCoverImages]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_email_templates.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_versioning_articleGalleySettings.xml (skipped)]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_versioning.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_last_activity.xml]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
[schema: lib/pkp/xml/schema/metadata.xml]
[schema: lib/pkp/xml/schema/reviews.xml]
[schema: lib/pkp/xml/schema/reviewForms.xml]
[schema: lib/pkp/xml/schema/controlledVocab.xml]
[schema: lib/pkp/xml/schema/submissions.xml]
[schema: lib/pkp/xml/schema/submissionFiles.xml]
[schema: lib/pkp/xml/schema/categories.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/genres.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: lib/pkp/xml/schema/rolesAndUserGroups.xml]
[schema: lib/pkp/xml/schema/metrics.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/libraryFiles.xml]
[schema: lib/pkp/xml/schema/navigationMenus.xml]
[schema: dbscripts/xml/ojs_schema.xml]

[code: Installer Installer::installDefaultNavigationMenus]

[code: Installer Installer::migrateStaticPagesToNavigationMenuItems]

[code: Installer Installer::migrateUserAndAuthorNames (skipped)]
[data: dbscripts/xml/upgrade/3.2.0_stylesheet.xml]
[data: dbscripts/xml/upgrade/3.2.0_archiving_settings.xml]
[data: dbscripts/xml/upgrade/3.2.0_update.xml]
[data: dbscripts/xml/upgrade/3.2.0_navigation_menu_items_locale_change.xml]

[code: Installer Installer::migrateSiteLocales]

[code: Installer Installer::migrateSidebarBlocks]
[XXXXXXX@XXXXXXXXXXXX XXXXXXXX.com]$

Hi @Surojit_Bera,

I’ve moved your topic from the other post in a new one as it deals with a separate issue, and we like to keep issues distinct from one another in order to keep the forum organized. I’m not sure exactly what’s occurring here, but hopefully others may be able to assist. If you have access to them you might want to post anything relevant from your PHP error logs. If you’re able to resolve this issue, and get your instance upgraded as well as the Crossref plugin, that might be a more appropriate time to go back to addressing the issue with your DOIs.

-Roger
PKP Staff

Thank you @rcgillis

Please see the PHP error logs

text/x-generic error_log ( ASCII text, with very long lines )

[16-Jun-2021 10:36:37 UTC] PHP Warning: Use of undefined constant SCHEMA_GALLEY - assumed ‘SCHEMA_GALLEY’ (this will throw an Error in a future version of PHP) in /home/journalsarticle/public_html/e4journal/lib/pkp/includes/functions.inc.php on line 224

[16-Jun-2021 10:36:37 UTC] PHP Warning: Use of undefined constant SCHEMA_AUTHOR - assumed ‘SCHEMA_AUTHOR’ (this will throw an Error in a future version of PHP) in /home/journalsarticle/public_html/e4journal/lib/pkp/includes/functions.inc.php on line 224

[16-Jun-2021 10:36:37 UTC] PHP Warning: Use of undefined constant SCHEMA_AUTHOR - assumed ‘SCHEMA_AUTHOR’ (this will throw an Error in a future version of PHP) in /home/journalsarticle/public_html/e4journal/lib/pkp/includes/functions.inc.php on line 224

[16-Jun-2021 10:38:36 UTC] WARNING: The NavigationMenu (ContextId: 115, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.

[16-Jun-2021 10:38:36 UTC] WARNING: The NavigationMenu (ContextId: 115, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.

[16-Jun-2021 10:38:36 UTC] WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.

[16-Jun-2021 10:38:40 UTC] PHP Fatal error: Uncaught Error: Call to a member function setData() on null in /home/journalsarticle/public_html/e4journal/lib/pkp/classes/install/Installer.inc.php:868

Stack trace:

#0 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/install/Installer.inc.php(444): Installer->migrateSidebarBlocks(Object(Upgrade), Array)

#1 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction(Array)

#2 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()

#3 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()

#4 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()

#5 /home/journalsarticle/public_html/e4journal/tools/upgrade.php(22): UpgradeTool->execute()

#6 {main}

thrown in /home/journalsarticle/public_html/e4journal/lib/pkp/classes/install/Installer.inc.php on line 868

[16-Jun-2021 10:40:08 UTC] PHP Fatal error: Uncaught Error: Call to a member function getConnection() on null in /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php:74

Stack trace:

#0 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Capsule\Manager::connection()

#1 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/db/DAO.inc.php(65): Illuminate\Database\Capsule\Manager::__callStatic(‘raw’, Array)

#2 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/context/ContextDAO.inc.php(63): DAO->retrieve(‘SELECT * FROM j…’, Array)

#3 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath(‘ACRI’)

#4 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext(Object(Request), 1)

#5 /home/journalsarticle/public_html/e4journal/classes/core/Request.inc.php(64): PKPRequest->_delegateToRoute in /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php on line 74

[16-Jun-2021 10:40:11 UTC] PHP Fatal error: Uncaught Error: Call to a member function getConnection() on null in /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php:74

Stack trace:

#0 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Capsule\Manager::connection()

#1 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/db/DAO.inc.php(65): Illuminate\Database\Capsule\Manager::__callStatic(‘raw’, Array)

#2 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/context/ContextDAO.inc.php(63): DAO->retrieve(‘SELECT * FROM j…’, Array)

#3 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath(‘ACRI’)

#4 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext(Object(Request), 1)

#5 /home/journalsarticle/public_html/e4journal/classes/core/Request.inc.php(64): PKPRequest->_delegateToRoute in /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php on line 74

[16-Jun-2021 10:40:12 UTC] PHP Fatal error: Uncaught Error: Call to a member function getConnection() on null in /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php:74

Stack trace:

#0 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Capsule\Manager::connection()

#1 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/db/DAO.inc.php(65): Illuminate\Database\Capsule\Manager::__callStatic(‘raw’, Array)

#2 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/context/ContextDAO.inc.php(63): DAO->retrieve(‘SELECT * FROM j…’, Array)

#3 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath(‘ACRI’)

#4 /home/journalsarticle/public_html/e4journal/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext(Object(Request), 1)

#5 /home/journalsarticle/public_html/e4journal/classes/core/Request.inc.php(64): PKPRequest->_delegateToRoute in /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php on line 74

[16-Jun-2021 10:40:46 UTC] PHP Fatal error: Uncaught Error: Call to a member function getOption() on null in /home/journalsarticle/public_html/e4journal/cache/t_compile/3053e64f77f7316724b89aaf850d0e2afbc864f5^e64e579388e5615e11e939b12134d6ae8679eba6_0.app.frontendpagesindexJournal.php:37

Stack trace:

#0 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_60c9d52e71e136_38038734(Object(Smarty_Internal_Template))

#1 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template))

#2 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(216): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template))

#3 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(232): Smarty_Internal_Template- in /home/journalsarticle/public_html/e4journal/cache/t_compile/3053e64f77f7316724b89aaf850d0e2afbc864f5^e64e579388e5615e11e939b12134d6ae8679eba6_0.app.frontendpagesindexJournal.php on line 37

[16-Jun-2021 10:41:00 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘sf.submission_file_id’ in ‘field list’ in /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78

Stack trace:

#0 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare(‘select sf.`su…’, Array)

#1 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(331): Doctrine\DBAL\Driver\PDOConnection->prepare(‘select sf.`su…’)

#2 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘select sf.`su…’, Array)

#3 /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('select sf.`su… in /home/journalsarticle/public_html/e4journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671

For Crossref: In the username field The correct way: email followed by forward slash then role of the depositor.

example: abc@gmail.com/dep