I’m trying to upgrade my OMP version but I’m stuck on database upgrade bacause the upgrade tool is returning an error, as follows:
Version check output:
Code version: 3.3.0.4
Database version: 3.2.1.2
Latest version: 3.3.0.4
Database version is older than code version
Run “omp-3.3.0-4/tools/upgrade.php upgrade” to update
Upgrade log output:
[pre-install]
[load: upgrade.xml]
[version: 3.3.0.4]
[code: Installer Installer::checkPhpVersion]
[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.
[code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
[migration: PKPv3_3_0UpgradeMigration]
ERROR: Upgrade failed: DB: PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘context_id’ at row 1 in /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute()
#1 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}()
#3 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run()
#5 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement()
#6 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build()
#8 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(95): Illuminate\Database\Schema\Builder->table()
#9 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/install/Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#10 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction()
#11 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()
#12 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#13 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#14 /var/www/omp/omp-3.3.0-4/tools/upgrade.php(22): UpgradeTool->execute()
#15 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘context_id’ at row 1 in /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}()
#3 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run()
#5 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement()
#6 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build()
#8 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(95): Illuminate\Database\Schema\Builder->table()
#9 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/install/Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#10 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction()
#11 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()
#12 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#13 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#14 /var/www/omp/omp-3.3.0-4/tools/upgrade.php(22): UpgradeTool->execute()
#15 {main}
Next Illuminate\Database\QueryException: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘context_id’ at row 1 (SQL: ALTER TABLE email_templates CHANGE context_id context_id BIGINT DEFAULT 0 NOT NULL) in /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run()
#2 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(102): Illuminate\Database\Connection->statement()
#3 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/omp/omp-3.3.0-4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build()
#5 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/migration/upgrade/PKPv3_3_0UpgradeMigration.inc.php(95): Illuminate\Database\Schema\Builder->table()
#6 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/install/Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#7 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/install/Installer.inc.php(251): Installer->executeAction()
#8 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/install/Installer.inc.php(174): Installer->executeInstaller()
#9 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/cliTool/UpgradeTool.inc.php(89): Installer->execute()
#10 /var/www/omp/omp-3.3.0-4/lib/pkp/classes/cliTool/UpgradeTool.inc.php(65): UpgradeTool->upgrade()
#11 /var/www/omp/omp-3.3.0-4/tools/upgrade.php(22): UpgradeTool->execute()
#12 {main}
Any ideas to help me out?