Atualização OJS3

OJS/SEER
#1

Olá!
Estamos tentando atualizar o OJS da versão 3.2.15 para 3.3.0.19, entrentanto, nos deparamos com alguns erros no banco de dados, aonde ele tenta mudar o tipo de uma coluna que já está populada. O que fazer nessas situações?

[pre-install]
2025-02-21 17:08:15 [load: upgrade.xml]
2025-02-21 17:08:15 [version: 3.3.0.19]
2025-02-21 17:08:15 [code: Installer Installer::checkPhpVersion]
2025-02-21 17:08:15 [code: Installer Installer::installDefaultNavigationMenus]
WARNING: The NavigationMenu (ContextId: 1, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 1, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
2025-02-21 17:08:15 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
2025-02-21 17:08:15 [migration: PKPv3_3_0UpgradeMigration]
ERROR: Upgrade failed: DB: PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘review_round_id’ at row 469 in /var/www/html/ppp/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
Stack trace:
#0 /var/www/html/ppp/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): PDOStatement->execute()
#1 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}()
#3 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run()
#5 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement()
#6 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build()
#8 /var/www/html/ppp/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(112): Illuminate\Database\Schema\Builder->table()
#9 /var/www/html/ppp/lib/pkp/classes/install/Installer.inc.php(406): PKPv3_3_0UpgradeMigration->up()
#10 /var/www/html/ppp/lib/pkp/classes/install/Installer.inc.php(252): Installer->executeAction()
#11 /var/www/html/ppp/lib/pkp/classes/install/Installer.inc.php(175): Installer->executeInstaller()
#12 /var/www/html/ppp/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#13 /var/www/html/ppp/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#14 /var/www/html/ppp/tools/upgrade.php(22): UpgradeTool->execute()
#15 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘review_round_id’ at row 469 in /var/www/html/ppp/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/html/ppp/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(121): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}()
#3 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run()
#5 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement()
#6 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build()
#8 /var/www/html/ppp/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(112): Illuminate\Database\Schema\Builder->table()
#9 /var/www/html/ppp/lib/pkp/classes/install/Installer.inc.php(406): PKPv3_3_0UpgradeMigration->up()
#10 /var/www/html/ppp/lib/pkp/classes/install/Installer.inc.php(252): Installer->executeAction()
#11 /var/www/html/ppp/lib/pkp/classes/install/Installer.inc.php(175): Installer->executeInstaller()
#12 /var/www/html/ppp/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#13 /var/www/html/ppp/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#14 /var/www/html/ppp/tools/upgrade.php(22): UpgradeTool->execute()
#15 {main}

Next Illuminate\Database\QueryException: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘review_round_id’ at row 469 (SQL: ALTER TABLE review_assignments CHANGE review_round_id review_round_id BIGINT NOT NULL) in /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run()
#2 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement()
#3 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/html/ppp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build()
#5 /var/www/html/ppp/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(112): Illuminate\Database\Schema\Builder->table()
#6 /var/www/html/ppp/lib/pkp/classes/install/Installer.inc.php(406): PKPv3_3_0UpgradeMigration->up()
#7 /var/www/html/ppp/lib/pkp/classes/install/Installer.inc.php(252): Installer->executeAction()
#8 /var/www/html/ppp/lib/pkp/classes/install/Installer.inc.php(175): Installer->executeInstaller()
#9 /var/www/html/ppp/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#10 /var/www/html/ppp/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#11 /var/www/html/ppp/tools/upgrade.php(22): UpgradeTool->execute()
#12 {main}

1 curtida
#2

Olá @FilipeCastro ,

acredito que existam valores nulos na tabela review_assignments, especificamente na coluna review_round_id. Sugiro que restaurem o backup do banco e atualizem a tabela review_assignments, definindo os valores NULL da coluna review_round_id como 0 e rode novamente o script de atualização. Outra possibilidade seria excluir esses registros nulos. No entanto, acredito que a atualização da coluna review_round_id seja suficiente para resolver o problema.

Segue, como referência, um post do fórum do PKP que trata de um erro semelhante:

1 curtida