The issue or problem
Getting Multiple Endless Errors Dusing Upgrade from 3.3.11 to 3.4
Steps I took leading up to the issue
- Download the latest OJS 3.4 from website
- transfer the public directory and update the config
- Try to update the Journal
What application are you using?
OJS 3.3.11
Additional information
Errors occurred during installation:
getting the error
Errors occurred during installation:
- A database error has occurred: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘PKP\task\ReviewReminder’ for key ‘scheduled_tasks_unique’ in C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php:545 Stack trace: #0 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(545): PDOStatement->execute() #1 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(753): Illuminate\Database\Connection->Illuminate\Database{closure}(‘UPDATE schedule…’, Array) #2 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback(‘UPDATE schedule…’, Array, Object(Closure)) #3 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(534): Illuminate\Database\Connection->run(‘UPDATE schedule…’, Array, Object(Closure)) #4 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(469): Illuminate\Database\Connection->statement(‘UPDATE schedule…’, Array) #5 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(338): Illuminate\Database\DatabaseManager->__call(‘statement’, Array) #6 C:\xampp\htdocs\nahje9\classes\migration\upgrade\v3_4_0\I6091_AddFilterNamespaces.php(73): Illuminate\Support\Facades\Facade::__callStatic(‘statement’, Array) #7 C:\xampp\htdocs\nahje9\lib\pkp\classes\install\Installer.php(463): APP\migration\upgrade\v3_4_0\I6091_AddFilterNamespaces->up() #8 C:\xampp\htdocs\nahje9\lib\pkp\classes\install\Installer.php(294): PKP\install\Installer->executeAction(Array) #9 C:\xampp\htdocs\nahje9\lib\pkp\classes\install\Installer.php(209): PKP\install\Installer->executeInstaller() #10 C:\xampp\htdocs\nahje9\lib\pkp\classes\install\form\UpgradeForm.php(49): PKP\install\Installer->execute() #11 C:\xampp\htdocs\nahje9\lib\pkp\pages\install\InstallHandler.php(148): PKP\install\form\UpgradeForm->execute() #12 [internal function]: PKP\pages\install\InstallHandler->installUpgrade(Array, Object(APP\core\Request)) #13 C:\xampp\htdocs\nahje9\lib\pkp\classes\core\PKPRouter.php(334): call_user_func(Array, Array, Object(APP\core\Request)) #14 C:\xampp\htdocs\nahje9\lib\pkp\classes\core\PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array, false) #15 C:\xampp\htdocs\nahje9\lib\pkp\classes\core\Dispatcher.php(165): PKP\core\PKPPageRouter->route(Object(APP\core\Request)) #16 C:\xampp\htdocs\nahje9\lib\pkp\classes\core\PKPApplication.php(388): PKP\core\Dispatcher->dispatch(Object(APP\core\Request)) #17 C:\xampp\htdocs\nahje9\index.php(21): PKP\core\PKPApplication->execute() #18 {main} Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘PKP\task\ReviewReminder’ for key ‘scheduled_tasks_unique’ (SQL: UPDATE scheduled_tasks SET class_name = PKP\task\ReviewReminder WHERE class_name = lib.pkp.classes.task.ReviewReminder) in C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php:760 Stack trace: #0 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback(‘UPDATE schedule…’, Array, Object(Closure)) #1 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(534): Illuminate\Database\Connection->run(‘UPDATE schedule…’, Array, Object(Closure)) #2 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(469): Illuminate\Database\Connection->statement(‘UPDATE schedule…’, Array) #3 C:\xampp\htdocs\nahje9\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(338): Illuminate\Database\DatabaseManager->__call(‘statement’, Array) #4 C:\xampp\htdocs\nahje9\classes\migration\upgrade\v3_4_0\I6091_AddFilterNamespaces.php(73): Illuminate\Support\Facades\Facade::__callStatic(‘statement’, Array) #5 C:\xampp\htdocs\nahje9\lib\pkp\classes\install\Installer.php(463): APP\migration\upgrade\v3_4_0\I6091_AddFilterNamespaces->up() #6 C:\xampp\htdocs\nahje9\lib\pkp\classes\install\Installer.php(294): PKP\install\Installer->executeAction(Array) #7 C:\xampp\htdocs\nahje9\lib\pkp\classes\install\Installer.php(209): PKP\install\Installer->executeInstaller() #8 C:\xampp\htdocs\nahje9\lib\pkp\classes\install\form\UpgradeForm.php(49): PKP\install\Installer->execute() #9 C:\xampp\htdocs\nahje9\lib\pkp\pages\install\InstallHandler.php(148): PKP\install\form\UpgradeForm->execute() #10 [internal function]: PKP\pages\install\InstallHandler->installUpgrade(Array, Object(APP\core\Request)) #11 C:\xampp\htdocs\nahje9\lib\pkp\classes\core\PKPRouter.php(334): call_user_func(Array, Array, Object(APP\core\Request)) #12 C:\xampp\htdocs\nahje9\lib\pkp\classes\core\PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array, false) #13 C:\xampp\htdocs\nahje9\lib\pkp\classes\core\Dispatcher.php(165): PKP\core\PKPPageRouter->route(Object(APP\core\Request)) #14 C:\xampp\htdocs\nahje9\lib\pkp\classes\core\PKPApplication.php(388): PKP\core\Dispatcher->dispatch(Object(APP\core\Request)) #15 C:\xampp\htdocs\nahje9\index.php(21): PKP\core\PKPApplication->execute() #16 {main}