Erro de atualização versão 3.0.2.0 para a verão 3.3.0.15

tiagosiqueira1 · Outubro 20, 2023, 7:55pm

Ola boa tarde pessoal.

Estamos tentando atualizar a versão da nossa revista, porem estamos recebendo o seguinte erro ao rodar o upgrade.php

tiagosiqueira@tunisia:/var/www/html/tools$ sudo php upgrade.php upgrade
2023-10-20 14:56:03 [pre-install]
2023-10-20 14:56:03 [load: upgrade.xml]
2023-10-20 14:56:03 [version: 3.3.0.15]
2023-10-20 14:56:03 [code: Installer Installer::checkPhpVersion]
2023-10-20 14:56:03 [data: dbscripts/xml/upgrade/3.1.0_preupdate_review_assignments.xml]
2023-10-20 14:56:03 [data: dbscripts/xml/upgrade/3.1.0_preupdate_notes.xml (skipped)]
2023-10-20 14:56:03 [data: dbscripts/xml/upgrade/3.1.0_preupdate_payments.xml]
2023-10-20 14:56:03 [data: dbscripts/xml/upgrade/3.1.1_preupdate_citations.xml]
2023-10-20 14:56:03 [data: dbscripts/xml/upgrade/3.1.2_preupdate_user_author_names.xml]
2023-10-20 14:56:03 [data: dbscripts/xml/upgrade/3.2.0_preupdate_email_templates.xml]
2023-10-20 14:56:03 [data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning_articleGalleySettings.xml (skipped)]
2023-10-20 14:56:03 [data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning.xml]
2023-10-20 14:56:04 [data: dbscripts/xml/upgrade/3.2.0_preupdate_last_activity.xml]
2023-10-20 14:56:04 [schema: lib/pkp/xml/schema/common.xml]
2023-10-20 14:56:05 [schema: lib/pkp/xml/schema/log.xml]
2023-10-20 14:56:05 [schema: lib/pkp/xml/schema/announcements.xml]
2023-10-20 14:56:05 [schema: lib/pkp/xml/schema/scheduledTasks.xml]
2023-10-20 14:56:05 [schema: lib/pkp/xml/schema/temporaryFiles.xml]
2023-10-20 14:56:05 [schema: lib/pkp/xml/schema/metadata.xml]
2023-10-20 14:56:06 [schema: lib/pkp/xml/schema/reviews.xml]
2023-10-20 14:56:06 [schema: lib/pkp/xml/schema/reviewForms.xml]
2023-10-20 14:56:06 [schema: lib/pkp/xml/schema/controlledVocab.xml]
2023-10-20 14:56:06 [schema: lib/pkp/xml/schema/submissions.xml]
2023-10-20 14:56:07 [schema: lib/pkp/xml/schema/submissionFiles.xml]
2023-10-20 14:56:08 [schema: lib/pkp/xml/schema/categories.xml]
2023-10-20 14:56:08 [schema: lib/pkp/xml/schema/notes.xml]
2023-10-20 14:56:08 [schema: lib/pkp/xml/schema/genres.xml]
2023-10-20 14:56:08 [schema: lib/pkp/xml/schema/tombstone.xml]
2023-10-20 14:56:08 [schema: lib/pkp/xml/schema/rolesAndUserGroups.xml]
2023-10-20 14:56:08 [schema: lib/pkp/xml/schema/metrics.xml]
2023-10-20 14:56:10 [schema: lib/pkp/xml/schema/views.xml]
2023-10-20 14:56:10 [schema: lib/pkp/xml/schema/libraryFiles.xml]
2023-10-20 14:56:10 [schema: lib/pkp/xml/schema/navigationMenus.xml]
2023-10-20 14:56:10 [schema: dbscripts/xml/ojs_schema.xml]
2023-10-20 14:56:11 [code: Installer Installer::installDefaultNavigationMenus]
PHP Notice: unserialize(): Error at offset 225 of 1207 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 254
2023-10-20 14:56:11 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
PHP Notice: unserialize(): Error at offset 225 of 1207 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 254
2023-10-20 14:56:11 [code: Installer Installer::migrateSRLocale]
2023-10-20 14:56:11 [code: Installer Installer::migrateUserAndAuthorNames]
PHP Notice: unserialize(): Error at offset 225 of 1207 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 254
2023-10-20 14:56:11 [code: Installer Installer::migrateSubmissionCoverImages]
2023-10-20 14:56:11 [code: Installer Installer::installEmailTemplate]
2023-10-20 14:56:11 [data: dbscripts/xml/upgrade/3.1.0_update_a.xml]
2023-10-20 14:56:11 [code: Installer Installer::fixGenreIdInFileNames]
PHP Notice: unserialize(): Error at offset 225 of 1207 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 254
PHP Fatal error: Uncaught League\Flysystem\FileNotFoundException: File not found at path: journals/1/articles/20/submission/review/20-1-38-1-4-20160404.docx in /var/www/html/lib/pkp/lib/vendor/league/flysystem/src/Filesystem.php:389
Stack trace:
#0 /var/www/html/lib/pkp/lib/vendor/league/flysystem/src/Filesystem.php(210): League\Flysystem\Filesystem->assertPresent()
#1 /var/www/html/classes/install/Upgrade.inc.php(664): League\Flysystem\Filesystem->rename()
#2 /var/www/html/lib/pkp/classes/install/Installer.inc.php(445): Upgrade->fixGenreIdInFileNames()
#3 /var/www/html/lib/pkp/classes/install/Installer.inc.php(252): Installer->executeAction()
#4 /var/www/html/lib/pkp/classes/install/Installer.inc.php(175): Installer->executeInstaller()
#5 /var/www/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#6 /var/www/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#7 /var/www/html/tools/upgrade.php(22): UpgradeTool->execute()
#8 {main}
thrown in /var/www/html/lib/pkp/lib/vendor/league/flysystem/src/Filesystem.php on line 389

voces sabem a causa desse problema?

desde ja muito obrigado.

Diego_Abadan · Outubro 20, 2023, 9:57pm

O OJS não está achando este arquivo journals/1/articles/20/submission/review/20-1-38-1-4-20160404.docx

Esse problema foi reportado para PKP mas ainda não corrigido:

github.com/pkp/pkp-lib

Upgrade from 3.0.2 to 3.3 can fail if submission files are missing

opened 08:18PM - 21 Jan 22 UTC

jnugent

Bug:1:Low

**Describe the bug** During the upgrade from 3.0.2 to 3.3, `Installer Installer…::fixGenreIdInFileNames` runs and this can fail with: `PHP Fatal error: Uncaught League\Flysystem\FileNotFoundException: File not found at path: journals/1/...... in /var/www/html/www-33/lib/pkp/lib/vendor/league/flysystem/src/Filesystem.php:390` This may or may not be a bug, but I know that there's been work done to make the upgrade process to 3.3 more robust and during original OJS 3.3 testing there was an bug filed when an issue's table of contents would error out if a file was missing. In a similar vein, ould this method skip files entirely if they are no longer present? Steps to reproduce: 1. Remove a valid file on disk from a 3.0.2 installation while keeping it in the database 2. Attempt an upgrade to 3.3

Você pode criar um arquivo neste local onde o OJS espera encontrá-lo, por exemplo, para contornar o problema dele ser esperado, mas não existir.

tiagosiqueira1 · Outubro 23, 2023, 1:53pm

Bom dia Diego,

Criei o arquivo porem agora esta dando outro erro.

tiagosiqueira@tunisia:/var/www/html/tools$ sudo php upgrade.php upgrade
2023-10-23 13:48:54 [pre-install]
2023-10-23 13:48:54 [load: upgrade.xml]
2023-10-23 13:48:54 [version: 3.3.0.15]
2023-10-23 13:48:54 [code: Installer Installer::checkPhpVersion]
2023-10-23 13:48:54 [data: dbscripts/xml/upgrade/3.1.0_preupdate_review_assignments.xml]
2023-10-23 13:48:54 [data: dbscripts/xml/upgrade/3.1.0_preupdate_notes.xml (skipped)]
2023-10-23 13:48:54 [data: dbscripts/xml/upgrade/3.1.0_preupdate_payments.xml]
2023-10-23 13:48:54 [data: dbscripts/xml/upgrade/3.1.1_preupdate_citations.xml]
2023-10-23 13:48:54 [data: dbscripts/xml/upgrade/3.1.2_preupdate_user_author_names.xml]
2023-10-23 13:48:54 [data: dbscripts/xml/upgrade/3.2.0_preupdate_email_templates.xml]
2023-10-23 13:48:54 [data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning_articleGalleySettings.xml (skipped)]
2023-10-23 13:48:54 [data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning.xml]
2023-10-23 13:48:55 [data: dbscripts/xml/upgrade/3.2.0_preupdate_last_activity.xml]
2023-10-23 13:48:55 [schema: lib/pkp/xml/schema/common.xml]
2023-10-23 13:48:56 [schema: lib/pkp/xml/schema/log.xml]
2023-10-23 13:48:56 [schema: lib/pkp/xml/schema/announcements.xml]
2023-10-23 13:48:56 [schema: lib/pkp/xml/schema/scheduledTasks.xml]
2023-10-23 13:48:56 [schema: lib/pkp/xml/schema/temporaryFiles.xml]
2023-10-23 13:48:56 [schema: lib/pkp/xml/schema/metadata.xml]
2023-10-23 13:48:57 [schema: lib/pkp/xml/schema/reviews.xml]
2023-10-23 13:48:57 [schema: lib/pkp/xml/schema/reviewForms.xml]
2023-10-23 13:48:57 [schema: lib/pkp/xml/schema/controlledVocab.xml]
2023-10-23 13:48:57 [schema: lib/pkp/xml/schema/submissions.xml]
2023-10-23 13:48:58 [schema: lib/pkp/xml/schema/submissionFiles.xml]
2023-10-23 13:48:59 [schema: lib/pkp/xml/schema/categories.xml]
2023-10-23 13:48:59 [schema: lib/pkp/xml/schema/notes.xml]
2023-10-23 13:48:59 [schema: lib/pkp/xml/schema/genres.xml]
2023-10-23 13:48:59 [schema: lib/pkp/xml/schema/tombstone.xml]
2023-10-23 13:48:59 [schema: lib/pkp/xml/schema/rolesAndUserGroups.xml]
2023-10-23 13:48:59 [schema: lib/pkp/xml/schema/metrics.xml]
2023-10-23 13:49:01 [schema: lib/pkp/xml/schema/views.xml]
2023-10-23 13:49:01 [schema: lib/pkp/xml/schema/libraryFiles.xml]
2023-10-23 13:49:01 [schema: lib/pkp/xml/schema/navigationMenus.xml]
2023-10-23 13:49:01 [schema: dbscripts/xml/ojs_schema.xml]
2023-10-23 13:49:02 [code: Installer Installer::installDefaultNavigationMenus]
PHP Notice: unserialize(): Error at offset 225 of 1207 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 254
2023-10-23 13:49:02 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
PHP Notice: unserialize(): Error at offset 225 of 1207 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 254
2023-10-23 13:49:02 [code: Installer Installer::migrateSRLocale]
2023-10-23 13:49:02 [code: Installer Installer::migrateUserAndAuthorNames]
PHP Notice: unserialize(): Error at offset 225 of 1207 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 254
2023-10-23 13:49:02 [code: Installer Installer::migrateSubmissionCoverImages]
2023-10-23 13:49:02 [code: Installer Installer::installEmailTemplate]
2023-10-23 13:49:02 [data: dbscripts/xml/upgrade/3.1.0_update_a.xml]
2023-10-23 13:49:02 [code: Installer Installer::fixGenreIdInFileNames]
PHP Notice: unserialize(): Error at offset 225 of 1207 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 254
PHP Fatal error: Uncaught Exception: A file assigned to the file stage 8 could not be migrated. in /var/www/html/classes/install/Upgrade.inc.php:1209
Stack trace:
#0 /var/www/html/classes/install/Upgrade.inc.php(657): Upgrade->_fileStageToPath()
#1 /var/www/html/lib/pkp/classes/install/Installer.inc.php(445): Upgrade->fixGenreIdInFileNames()
#2 /var/www/html/lib/pkp/classes/install/Installer.inc.php(252): Installer->executeAction()
#3 /var/www/html/lib/pkp/classes/install/Installer.inc.php(175): Installer->executeInstaller()
#4 /var/www/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#5 /var/www/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#6 /var/www/html/tools/upgrade.php(22): UpgradeTool->execute()
#7 {main}
thrown in /var/www/html/classes/install/Upgrade.inc.php on line 1209

Sabe alguma forma de contornar esse erro?

Diego_Abadan · Outubro 23, 2023, 2:38pm

Este não sei. Por ser algo muito técnico, sugiro perguntar no fórum da PKP, caso não encontre um tópico com a solução.

tiagosiqueira1 · Outubro 23, 2023, 2:51pm

Estou tentando me cadastrar no fórum da pkp, porem só possível se cadastrar via convite. Você tem acesso ao fórum?

att

Desde já muito obrigado pelo apoio

OpenJournalSolutions · Outubro 23, 2023, 6:39pm

@tiagosiqueira1 Tente atualizar o OJS primeiro para a versão 3.2.1.4, antes da 3.3.0.15. Acredito que pode resolver o problema.