Hello everyone,
we are trying to update our installation from version 3.3.0-20 to the latest 3.4.0-8 but when we launch the upgrade script, it exits with the following error and the update process aborts:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'review_form_responses_unique' in /var/www/html/ojs-3.4.0-8/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:545 Stack trace: #0 /var/www/html/ojs-3.4.0-8/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(545): PDOStatement->execute() #1 /var/www/html/ojs-3.4.0-8/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-8/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #3 /var/www/html/ojs-3.4.0-8/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run() #4 /var/www/html/ojs-3.4.0-8/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-8/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-8/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-8/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-8/lib/pkp/classes/migration/upgrade/v3_4_0/I3573_AddPrimaryKeys.php(49): Illuminate\Support\Facades\Facade::__callStatic() #9 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/install/Installer.php(463): PKP\migration\upgrade\v3_4_0\I3573_AddPrimaryKeys->up() #10 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/install/Installer.php(294): PKP\install\Installer->executeAction() #11 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/install/Installer.php(209): PKP\install\Installer->executeInstaller() #12 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/install/form/UpgradeForm.php(49): PKP\install\Installer->execute() #13 /var/www/html/ojs-3.4.0-8/lib/pkp/pages/install/InstallHandler.php(148): PKP\install\form\UpgradeForm->execute() #14 [internal function]: PKP\pages\install\InstallHandler->installUpgrade() #15 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #16 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #17 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #18 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/core/PKPApplication.php(388): PKP\core\Dispatcher->dispatch() #19 /var/www/html/ojs-3.4.0-8/index.php(21): PKP\core\PKPApplication->execute() #20 {main} Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'review_form_responses_unique' (SQL: alter table review_form_responsesadd indexreview_form_responses_unique(review_form_element_id, review_id)) in /var/www/html/ojs-3.4.0-8/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 Stack trace: #0 /var/www/html/ojs-3.4.0-8/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/html/ojs-3.4.0-8/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run() #2 /var/www/html/ojs-3.4.0-8/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-8/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-8/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-8/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-8/lib/pkp/classes/migration/upgrade/v3_4_0/I3573_AddPrimaryKeys.php(49): Illuminate\Support\Facades\Facade::__callStatic() #7 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/install/Installer.php(463): PKP\migration\upgrade\v3_4_0\I3573_AddPrimaryKeys->up() #8 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/install/Installer.php(294): PKP\install\Installer->executeAction() #9 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/install/Installer.php(209): PKP\install\Installer->executeInstaller() #10 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/install/form/UpgradeForm.php(49): PKP\install\Installer->execute() #11 /var/www/html/ojs-3.4.0-8/lib/pkp/pages/install/InstallHandler.php(148): PKP\install\form\UpgradeForm->execute() #12 [internal function]: PKP\pages\install\InstallHandler->installUpgrade() #13 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #14 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #15 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #16 /var/www/html/ojs-3.4.0-8/lib/pkp/classes/core/PKPApplication.php(388): PKP\core\Dispatcher->dispatch() #17 /var/www/html/ojs-3.4.0-8/index.php(21): PKP\core\PKPApplication->execute() #18 {main}
Does anybody have any hints about how to overcome this problem?
Thank you.