[3.3.0-7 com Postgres] Artigos somem da edição ao ser publicado

OJS/SEER
#1

Oi pessoal,
atualizei o OJS do 3.2.1-4 para o 3.3.0-7 numa atualização que não foi fácil, por conta de alguns erros. Após a atualização, estou encontrando vários erros no log. Vou colocar abaixo.

PHP Fatal error:  Uncaught PDOException: SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into "cu...', Array)\n#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into "cu...', Array, Object(Closure))\n#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('insert into "cu...', Array, Object(Closure))\n#5 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/staudenmeir/laravel-upsert/src/Query/Builder.php(92): Illuminate\\Database\\Connection->affectingStatement('insert into "cu...', Array)\n#6 /var/www/ojs-3.3.0-7/lib/pkp/classes/db/DAO.inc.php(150): Staudenmeir\\LaravelUpsert\\Query\\Builder->upsert(Array, Array)\n#7 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(699): DAO->replace('custom_issue_or...', Array, Array)\n#8 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(464): IssueDAO->resequenceCustomIssueOrders(105)\n#9 /var/www/ojs-3.3.0-7/controllers/grid/issues/form/IssueForm.inc.php(268): IssueDAO->updateObject(Object(Issue))\n#10 /var/www/ojs-3.3.0-7/classes/controllers/grid/issues/IssueGridHandler.inc.php(244): IssueForm->execute()\n#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): IssueGridHandler->updateIssue(Array, Object(Request))\n#12 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#13 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route(Object(Request))\n#14 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#15 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#16 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDO\\Exception: SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): Doctrine\\DBAL\\Driver\\PDO\\Exception::new(Object(PDOException))\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into "cu...', Array)\n#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into "cu...', Array, Object(Closure))\n#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('insert into "cu...', Array, Object(Closure))\n#5 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/staudenmeir/laravel-upsert/src/Query/Builder.php(92): Illuminate\\Database\\Connection->affectingStatement('insert into "cu...', Array)\n#6 /var/www/ojs-3.3.0-7/lib/pkp/classes/db/DAO.inc.php(150): Staudenmeir\\LaravelUpsert\\Query\\Builder->upsert(Array, Array)\n#7 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(699): DAO->replace('custom_issue_or...', Array, Array)\n#8 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(464): IssueDAO->resequenceCustomIssueOrders(105)\n#9 /var/www/ojs-3.3.0-7/controllers/grid/issues/form/IssueForm.inc.php(268): IssueDAO->updateObject(Object(Issue))\n#10 /var/www/ojs-3.3.0-7/classes/controllers/grid/issues/IssueGridHandler.inc.php(244): IssueForm->execute()\n#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): IssueGridHandler->updateIssue(Array, Object(Request))\n#12 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#13 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route(Object(Request))\n#14 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#15 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#16 {main}\n\nNext Illuminate\\Database\\QueryException: SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification (SQL: insert into "custom_issue_orders" ("issue_id", "journal_id", "seq") values (1216, 105, 1) on conflict ("issue_id", "journal_id") do update set "issue_id" = "excluded"."issue_id", "journal_id" = "excluded"."journal_id", "seq" = "excluded"."seq") in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into "cu...', Array, Object(Closure))\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('insert into "cu...', Array, Object(Closure))\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/staudenmeir/laravel-upsert/src/Query/Builder.php(92): Illuminate\\Database\\Connection->affectingStatement('insert into "cu...', Array)\n#3 /var/www/ojs-3.3.0-7/lib/pkp/classes/db/DAO.inc.php(150): Staudenmeir\\LaravelUpsert\\Query\\Builder->upsert(Array, Array)\n#4 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(699): DAO->replace('custom_issue_or...', Array, Array)\n#5 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(464): IssueDAO->resequenceCustomIssueOrders(105)\n#6 /var/www/ojs-3.3.0-7/controllers/grid/issues/form/IssueForm.inc.php(268): IssueDAO->updateObject(Object(Issue))\n#7 /var/www/ojs-3.3.0-7/classes/controllers/grid/issues/IssueGridHandler.inc.php(244): IssueForm->execute()\n#8 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): IssueGridHandler->updateIssue(Array, Object(Request))\n#9 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#10 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route(Object(Request))\n#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#12 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#13 {main}\n  thrown in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671, referer: https://periodicos.ufes.br/healthandbiosciences/manageIssues

[Mon Aug 23 16:41:38.164493 2021] [php7:error] [pid 32060] [client 172.20.7.116:51777] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into "cu...', Array)\n#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into "cu...', Array, Object(Closure))\n#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('insert into "cu...', Array, Object(Closure))\n#5 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/staudenmeir/laravel-upsert/src/Query/Builder.php(92): Illuminate\\Database\\Connection->affectingStatement('insert into "cu...', Array)\n#6 /var/www/ojs-3.3.0-7/lib/pkp/classes/db/DAO.inc.php(150): Staudenmeir\\LaravelUpsert\\Query\\Builder->upsert(Array, Array)\n#7 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(699): DAO->replace('custom_issue_or...', Array, Array)\n#8 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(464): IssueDAO->resequenceCustomIssueOrders(17)\n#9 /var/www/ojs-3.3.0-7/classes/controllers/grid/issues/IssueGridHandler.inc.php(545): IssueDAO->updateObject(Object(Issue))\n#10 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): IssueGridHandler->unpublishIssue(Array, Object(Request))\n#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#12 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route(Object(Request))\n#13 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#14 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#15 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDO\\Exception: SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): Doctrine\\DBAL\\Driver\\PDO\\Exception::new(Object(PDOException))\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into "cu...', Array)\n#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into "cu...', Array, Object(Closure))\n#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('insert into "cu...', Array, Object(Closure))\n#5 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/staudenmeir/laravel-upsert/src/Query/Builder.php(92): Illuminate\\Database\\Connection->affectingStatement('insert into "cu...', Array)\n#6 /var/www/ojs-3.3.0-7/lib/pkp/classes/db/DAO.inc.php(150): Staudenmeir\\LaravelUpsert\\Query\\Builder->upsert(Array, Array)\n#7 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(699): DAO->replace('custom_issue_or...', Array, Array)\n#8 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(464): IssueDAO->resequenceCustomIssueOrders(17)\n#9 /var/www/ojs-3.3.0-7/classes/controllers/grid/issues/IssueGridHandler.inc.php(545): IssueDAO->updateObject(Object(Issue))\n#10 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): IssueGridHandler->unpublishIssue(Array, Object(Request))\n#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#12 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route(Object(Request))\n#13 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#14 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#15 {main}\n\nNext Illuminate\\Database\\QueryException: SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification (SQL: insert into "custom_issue_orders" ("issue_id", "journal_id", "seq") values (1329, 17, 1) on conflict ("issue_id", "journal_id") do update set "issue_id" = "excluded"."issue_id", "journal_id" = "excluded"."journal_id", "seq" = "excluded"."seq") in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into "cu...', Array, Object(Closure))\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('insert into "cu...', Array, Object(Closure))\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/staudenmeir/laravel-upsert/src/Query/Builder.php(92): Illuminate\\Database\\Connection->affectingStatement('insert into "cu...', Array)\n#3 /var/www/ojs-3.3.0-7/lib/pkp/classes/db/DAO.inc.php(150): Staudenmeir\\LaravelUpsert\\Query\\Builder->upsert(Array, Array)\n#4 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(699): DAO->replace('custom_issue_or...', Array, Array)\n#5 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(464): IssueDAO->resequenceCustomIssueOrders(17)\n#6 /var/www/ojs-3.3.0-7/classes/controllers/grid/issues/IssueGridHandler.inc.php(545): IssueDAO->updateObject(Object(Issue))\n#7 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): IssueGridHandler->unpublishIssue(Array, Object(Request))\n#8 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#9 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route(Object(Request))\n#10 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#11 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#12 {main}\n  thrown in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671, referer: https://periodicos.ufes.br/simbiotica/manageIssues
[Mon Aug 23 16:41:55.636933 2021] [php7:error] [pid 31725] [client 172.20.7.116:56960] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into "cu...', Array)\n#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into "cu...', Array, Object(Closure))\n#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('insert into "cu...', Array, Object(Closure))\n#5 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/staudenmeir/laravel-upsert/src/Query/Builder.php(92): Illuminate\\Database\\Connection->affectingStatement('insert into "cu...', Array)\n#6 /var/www/ojs-3.3.0-7/lib/pkp/classes/db/DAO.inc.php(150): Staudenmeir\\LaravelUpsert\\Query\\Builder->upsert(Array, Array)\n#7 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(699): DAO->replace('custom_issue_or...', Array, Array)\n#8 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(464): IssueDAO->resequenceCustomIssueOrders(17)\n#9 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(270): IssueDAO->updateObject(Object(Issue))\n#10 /var/www/ojs-3.3.0-7/classes/controllers/grid/issues/IssueGridHandler.inc.php(481): IssueDAO->updateCurrent(17, Object(Issue))\n#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): IssueGridHandler->publishIssue(Array, Object(Request))\n#12 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#13 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route(Object(Request))\n#14 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#15 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#16 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDO\\Exception: SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): Doctrine\\DBAL\\Driver\\PDO\\Exception::new(Object(PDOException))\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into "cu...', Array)\n#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into "cu...', Array, Object(Closure))\n#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('insert into "cu...', Array, Object(Closure))\n#5 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/staudenmeir/laravel-upsert/src/Query/Builder.php(92): Illuminate\\Database\\Connection->affectingStatement('insert into "cu...', Array)\n#6 /var/www/ojs-3.3.0-7/lib/pkp/classes/db/DAO.inc.php(150): Staudenmeir\\LaravelUpsert\\Query\\Builder->upsert(Array, Array)\n#7 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(699): DAO->replace('custom_issue_or...', Array, Array)\n#8 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(464): IssueDAO->resequenceCustomIssueOrders(17)\n#9 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(270): IssueDAO->updateObject(Object(Issue))\n#10 /var/www/ojs-3.3.0-7/classes/controllers/grid/issues/IssueGridHandler.inc.php(481): IssueDAO->updateCurrent(17, Object(Issue))\n#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): IssueGridHandler->publishIssue(Array, Object(Request))\n#12 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#13 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route(Object(Request))\n#14 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#15 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#16 {main}\n\nNext Illuminate\\Database\\QueryException: SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification (SQL: insert into "custom_issue_orders" ("issue_id", "journal_id", "seq") values (1329, 17, 1) on conflict ("issue_id", "journal_id") do update set "issue_id" = "excluded"."issue_id", "journal_id" = "excluded"."journal_id", "seq" = "excluded"."seq") in /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into "cu...', Array, Object(Closure))\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('insert into "cu...', Array, Object(Closure))\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/staudenmeir/laravel-upsert/src/Query/Builder.php(92): Illuminate\\Database\\Connection->affectingStatement('insert into "cu...', Array)\n#3 /var/www/ojs-3.3.0-7/lib/pkp/classes/db/DAO.inc.php(150): Staudenmeir\\LaravelUpsert\\Query\\Builder->upsert(Array, Array)\n#4 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(699): DAO->replace('custom_issue_or...', Array, Array)\n#5 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(464): IssueDAO->resequenceCustomIssueOrders(17)\n#6 /var/www/ojs-3.3.0-7/classes/issue/IssueDAO.inc.php(270): IssueDAO->updateObject(Object(Issue))\n#7 /var/www/ojs-3.3.0-7/classes/controllers/grid/issues/IssueGridHandler.inc.php(481): IssueDAO->updateCurrent(17, Object(Issue))\n#8 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): IssueGridHandler->publishIssue(Array, Object(Request))\n#9 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#10 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route(Object(Request))\n#11 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.i

PHP Fatal error:  Uncaught Error: Call to a member function getId() on string in /var/www/ojs-3.3.0-7/pages/article/ArticleHandler.inc.php:373\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): ArticleHandler->downloadSuppFile(Array, Object(Request))\n#1 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)\n#2 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route(Object(Request))\n#3 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#4 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#5 {main}\n  thrown in /var/www/ojs-3.3.0-7/pages/article/ArticleHandler.inc.php on line 373

 PHP Fatal error:  Uncaught Error: Call to a member function getPublished() on null in /var/www/ojs-3.3.0-7/cache/t_compile/16a771d26dda746108b2d26b8c49c8bfbea663f8^acf1fc671fe3149386beb488bd42d95154e9d6f3_0.app.frontendpagessearchAuthor.php:49\nStack trace:\n#0 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_61141ca07e0a55_92121638(Object(Smarty_Internal_Template))\n#1 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template))\n#2 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(216): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template))\n#3 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(232): Smarty_Internal_Template->render(false, 1)\n#4 /var/www/ojs-3.3.0-7/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(134): Smarty_Internal_TemplateBase->_execute(Object(Smarty_Internal_Template), NULL, '16a771d26dda746...', NULL, 1)\n#5 /var/www/ojs-3.3.0-7/lib/pkp/classes/template/PKPTemplateManager.inc.php(1187): Smarty_Internal_TemplateBase->display('frontend/pages/...', NULL, '16a771d26dda746...', NULL)\n#6 /var/www/ojs-3.3.0-7/pages/search/SearchHandler.inc.php(275): PKPTemplateManager->display('frontend/pages/...')\n#7 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPRouter.inc.php(395): SearchHandler->authors(Array, Object(Request))\n#8 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)\n#9 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route(Object(Request))\n#10 /var/www/ojs-3.3.0-7/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))\n#11 /var/www/ojs-3.3.0-7/index.php(68): PKPApplication->execute()\n#12 {main}\n  thrown in /var/www/ojs-3.3.0-7/cache/t_compile/16a771d26dda746108b2d26b8c49c8bfbea663f8^acf1fc671fe3149386beb488bd42d95154e9d6f3_0.app.frontendpagessearchAuthor.php on line 49

Um erro grave, é que uma revista tem um volume para publicar. Na pré visualização, aparecem os artigos todos, mas ao publicar, fica em branco a publicação, conforme imagem abaixo.
Pré visualização:

image.png1080×607 108 KB

Publicação sem os artigos:

image.png1002×563 124 KB

Eu não sei se tem relação, mas eu só consegui fazer a atualização, após seguir os passos desse tópico:

Alguém sabe como me orientar em algum desses erros, por favor?

att
Adriano Moreno

1 curtida
[3.3.0-10 com Postgres] Artigos somem da edição ao ser publicado
#2

Olá amigo, este erro ocorre devido a ausência de uma constraint unique na tabela custom_issue_orders. Tive o mesmo problema no postgre SQL com OJS 3.3X e a correção depende apenas da criação desta constraint com o comando abaixo.

alter table custom_issue_orders add constraint uq_issue unique(issue_id,journal_id);

1 curtida
#3

Oi @ojsbr,
fiz essa alteração que você sugeriu e resolveu o problema da publicação.

Agora estou recebendo muito esse erro no log:

 PHP Fatal error:  Uncaught PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "sessions_pkey"
DETAIL:  Key (session_id)=(rttsmiudi6keesu14tu18aiom1) already exists. in /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)
#1 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()
#2 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('INSERT INTO ses...', Array)
#3 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('INSERT INTO ses...', Array, Object(Closure))
#4 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('INSERT INTO ses...', Array, Object(Closure))
#5 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\\Database\\Connection->affectingStatement('INSERT INTO ses...', Array)
#6 /var/www/ojs-3.3.0-10/lib/pkp/classes/db/DAO.inc.php(138): Illuminate\\Database\\Capsule\\Manager::__callStatic('affectingStatem...', Array)
#7 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionDAO.inc.php(72): DAO->update('INSERT INTO ses...', Array)
#8 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(89): SessionDAO->insertObject(Object(Session))
#9 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(129): SessionManager->__construct(Object(SessionDAO), Object(Request))
#10 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(131): SessionManager::getManager()
#11 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(290): PKPLocale::getLocale()
#12 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/Dispatcher.inc.php(116): PKPLocale::initialize(Object(Request))
#13 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#14 /var/www/ojs-3.3.0-10/index.php(68): PKPApplication->execute()
#15 {main}

Next Doctrine\\DBAL\\Driver\\PDO\\Exception: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "sessions_pkey"
DETAIL:  Key (session_id)=(rttsmiudi6keesu14tu18aiom1) already exists. in /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): Doctrine\\DBAL\\Driver\\PDO\\Exception::new(Object(PDOException))
#1 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()
#2 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('INSERT INTO ses...', Array)
#3 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('INSERT INTO ses...', Array, Object(Closure))
#4 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('INSERT INTO ses...', Array, Object(Closure))
#5 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\\Database\\Connection->affectingStatement('INSERT INTO ses...', Array)
#6 /var/www/ojs-3.3.0-10/lib/pkp/classes/db/DAO.inc.php(138): Illuminate\\Database\\Capsule\\Manager::__callStatic('affectingStatem...', Array)
#7 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionDAO.inc.php(72): DAO->update('INSERT INTO ses...', Array)
#8 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(89): SessionDAO->insertObject(Object(Session))
#9 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(129): SessionManager->__construct(Object(SessionDAO), Object(Request))
#10 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(131): SessionManager::getManager()
#11 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(290): PKPLocale::getLocale()
#12 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/Dispatcher.inc.php(116): PKPLocale::initialize(Object(Request))
#13 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#14 /var/www/ojs-3.3.0-10/index.php(68): PKPApplication->execute()
#15 {main}

Next Illuminate\\Database\\QueryException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "sessions_pkey"
DETAIL:  Key (session_id)=(rttsmiudi6keesu14tu18aiom1) already exists. (SQL: INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(rttsmiudi6keesu14tu18aiom1, 168.119.65.115, Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/), 1647386413, 1647386413, 0, , periodicos.ufes.br)) in /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('INSERT INTO ses...', Array, Object(Closure))
#1 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('INSERT INTO ses...', Array, Object(Closure))
#2 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\\Database\\Connection->affectingStatement('INSERT INTO ses...', Array)
#3 /var/www/ojs-3.3.0-10/lib/pkp/classes/db/DAO.inc.php(138): Illuminate\\Database\\Capsule\\Manager::__callStatic('affectingStatem...', Array)
#4 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionDAO.inc.php(72): DAO->update('INSERT INTO ses...', Array)
#5 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(89): SessionDAO->insertObject(Object(Session))
#6 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(129): SessionManager->__construct(Object(SessionDAO), Object(Request))
#7 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(131): SessionManager::getManager()
#8 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(290): PKPLocale::getLocale()
#9 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/Dispatcher.inc.php(116): PKPLocale::initialize(Object(Request))
#10 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#11 /var/www/ojs-3.3.0-10/index.php(68): PKPApplication->execute()
#12 {main}
  thrown in /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671, referer: https://periodicos.ufes.br/index.php/argumentum/article/view/10517

Você saberia dizer o que pode estar acontecendo?

1 curtida
#4

@Adriano_Jose,

Acredito que esse problema não interfira no funcionamento do sistema, pois esse erro

ERROR:  duplicate key value violates unique constraint "sessions_pkey"

acontece quando o sistema tenta criar um novo registro na tabela sessions que contem essas informações de sessões do usuário. Portanto, esses dados só ficam ativos quando existe sessões ativas.

Uma forma de contornar esse problema, é Expirar as sessões de usuários na área de Funções Administrativas com o perfil de administrador.
Realiza esse procedimento na manutenção diária do sistema, por exemplo antes de realizar o backup do banco de dados, pois esse procedimento irá expirar todas as sessões de usuários.

Acredito que feito isso uma vez o problema desaparecerá.

2 curtidas
[OJS 3.3.0-10] 7 ERROR: duplicate key value violates unique constraint "sessions_pkey"
#5

Estou com esse mesmo problema, minha versão é a 3.3.0-10, executei o comando da constraint → alter table custom_issue_orders add constraint uq_issue unique(issue_id,journal_id);

porém a aplicação envia a query assim → insert into “custom_issue_orders” (“issue_id”, “journal_id”, “seq”) values (92, 2, 1) on conflict (“issue_id”) do update set “issue_id” = “excluded”.“issue_id”, “journal_id” = “excluded”.“journal_id”, “seq” = “excluded”.“seq”;

O on conflict (“issue_id”) vem apenas um campo onde deveria ser 2. Alguma solução para isso? Atualizar algum pugin?