I am trying to upgrade OJS 3.2 to OJS 3.3.0-7, kindly
help to solve this error
PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘publication_id’ at row 52909 in D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:115
Stack trace:
#0 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(115): PDOStatement->execute(NULL)
#1 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘ALTER TABLE aut…’, Array)
#3 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘ALTER TABLE aut…’, Array, Object(Closure))
#4 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(465): Illuminate\Database\Connection->run(‘ALTER TABLE aut…’, Array, Object(Closure))
#5 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Blueprint.php(102): Illuminate\Database\Connection->statement(‘ALTER TABLE aut…’)
#6 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#7 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#8 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\migration\upgrade\PKPv3_3_0UpgradeMigration.inc.php(119): Illuminate\Database\Schema\Builder->table(‘authors’, Object(Closure))
#9 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#10 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\Installer.inc.php(251): Installer->executeAction(Array)
#11 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\Installer.inc.php(174): Installer->executeInstaller()
#12 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\form\UpgradeForm.inc.php(43): Installer->execute()
#13 D:\wamp64\www\Ojs32Ojs337\lib\pkp\pages\install\InstallHandler.inc.php(130): UpgradeForm->execute()
#14 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\PKPRouter.inc.php(395): InstallHandler->installUpgrade(Array, Object(Request))
#15 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)
#16 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\Dispatcher.inc.php(144): PKPPageRouter->route(Object(Request))
#17 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#18 D:\wamp64\www\Ojs32Ojs337\index.php(68): PKPApplication->execute()
#19 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘publication_id’ at row 52909 in D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDO\Exception.php:18
Stack trace:
#0 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(117): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘ALTER TABLE aut…’, Array)
#3 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘ALTER TABLE aut…’, Array, Object(Closure))
#4 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(465): Illuminate\Database\Connection->run(‘ALTER TABLE aut…’, Array, Object(Closure))
#5 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Blueprint.php(102): Illuminate\Database\Connection->statement(‘ALTER TABLE aut…’)
#6 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#7 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#8 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\migration\upgrade\PKPv3_3_0UpgradeMigration.inc.php(119): Illuminate\Database\Schema\Builder->table(‘authors’, Object(Closure))
#9 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#10 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\Installer.inc.php(251): Installer->executeAction(Array)
#11 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\Installer.inc.php(174): Installer->executeInstaller()
#12 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\form\UpgradeForm.inc.php(43): Installer->execute()
#13 D:\wamp64\www\Ojs32Ojs337\lib\pkp\pages\install\InstallHandler.inc.php(130): UpgradeForm->execute()
#14 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\PKPRouter.inc.php(395): InstallHandler->installUpgrade(Array, Object(Request))
#15 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)
#16 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\Dispatcher.inc.php(144): PKPPageRouter->route(Object(Request))
#17 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#18 D:\wamp64\www\Ojs32Ojs337\index.php(68): PKPApplication->execute()
#19 {main}
Next Illuminate\Database\QueryException: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘publication_id’ at row 52909 (SQL: ALTER TABLE authors CHANGE publication_id publication_id BIGINT NOT NULL) in D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
Stack trace:
#0 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘ALTER TABLE aut…’, Array, Object(Closure))
#1 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(465): Illuminate\Database\Connection->run(‘ALTER TABLE aut…’, Array, Object(Closure))
#2 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Blueprint.php(102): Illuminate\Database\Connection->statement(‘ALTER TABLE aut…’)
#3 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 D:\wamp64\www\Ojs32Ojs337\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\migration\upgrade\PKPv3_3_0UpgradeMigration.inc.php(119): Illuminate\Database\Schema\Builder->table(‘authors’, Object(Closure))
#6 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\Installer.inc.php(405): PKPv3_3_0UpgradeMigration->up()
#7 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\Installer.inc.php(251): Installer->executeAction(Array)
#8 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\Installer.inc.php(174): Installer->executeInstaller()
#9 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\install\form\UpgradeForm.inc.php(43): Installer->execute()
#10 D:\wamp64\www\Ojs32Ojs337\lib\pkp\pages\install\InstallHandler.inc.php(130): UpgradeForm->execute()
#11 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\PKPRouter.inc.php(395): InstallHandler->installUpgrade(Array, Object(Request))
#12 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)
#13 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\Dispatcher.inc.php(144): PKPPageRouter->route(Object(Request))
#14 D:\wamp64\www\Ojs32Ojs337\lib\pkp\classes\core\PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#15 D:\wamp64\www\Ojs32Ojs337\index.php(68): PKPApplication->execute()
#16 {main}