Describe the issue or problem
OJS upgrade fails
What application are you using?
Upgrading from OJS 3.3.0-20 to OJS 3.4.0-5
Hi all,
with reference to this topic (topic is closed, so I have to open another one), we started with a clean installation and tried again to upgrade.
We didn’t get anymore problems with indices but this time we had problems with primary keys, as follows:
ERROR: Upgrade failed: DB: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined in /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:545
Stack trace:
#0 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(545): PDOStatement->execute()
#1 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database{closure}()
#2 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#4 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#5 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(439): Illuminate\Database\Schema\Blueprint->build()
#6 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(269): Illuminate\Database\Schema\Builder->build()
#7 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Illuminate\Database\Schema\Builder->table()
#8 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/migration/upgrade/v3_4_0/I3573_AddPrimaryKeys.php(67): Illuminate\Support\Facades\Facade::__callStatic()
#9 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/install/Installer.php(463): PKP\migration\upgrade\v3_4_0\I3573_AddPrimaryKeys->up()
#10 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/install/Installer.php(294): PKP\install\Installer->executeAction()
#11 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/install/Installer.php(209): PKP\install\Installer->executeInstaller()
#12 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/cliTool/UpgradeTool.php(96): PKP\install\Installer->execute()
#13 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/cliTool/UpgradeTool.php(69): PKP\cliTool\UpgradeTool->upgrade()
#14 /var/www/html/ojs-3.4.0-5/tools/upgrade.php(22): PKP\cliTool\UpgradeTool->execute()
#15 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined (SQL: alter table user_interests add user_interest_id bigint unsigned not null auto_increment primary key first) in /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#2 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(439): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(269): Illuminate\Database\Schema\Builder->build()
#5 /var/www/html/ojs-3.4.0-5/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Illuminate\Database\Schema\Builder->table()
#6 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/migration/upgrade/v3_4_0/I3573_AddPrimaryKeys.php(67): Illuminate\Support\Facades\Facade::__callStatic()
#7 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/install/Installer.php(463): PKP\migration\upgrade\v3_4_0\I3573_AddPrimaryKeys->up()
#8 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/install/Installer.php(294): PKP\install\Installer->executeAction()
#9 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/install/Installer.php(209): PKP\install\Installer->executeInstaller()
#10 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/cliTool/UpgradeTool.php(96): PKP\install\Installer->execute()
#11 /var/www/html/ojs-3.4.0-5/lib/pkp/classes/cliTool/UpgradeTool.php(69): PKP\cliTool\UpgradeTool->upgrade()
#12 /var/www/html/ojs-3.4.0-5/tools/upgrade.php(22): PKP\cliTool\UpgradeTool->execute()
#13 {main}
Does anybody have an idea why this happens?
Thank you.