Hi,
I just upgraded to the current version 3.2.0-1 and then, upgraded to 3.2.0.2.
The Crossref XML Export Plugin is not showing any articles. It keeps running and shows nothing…
Chrome Inspect console:
jquery.min.js?v=3.2.0.2:2 GET http://periodicos.ufes.br/geografares/$$$call$$$/grid/pub-ids/pub-id-export-submissions-list-grid/fetch-grid?plugin=crossref&category=importexport&_=1586727566538 500 (Internal Server Error)
send @ jquery.min.js?v=3.2.0.2:2
ajax @ jquery.min.js?v=3.2.0.2:2
w. @ jquery.min.js?v=3.2.0.2:2
a.pkp.controllers.UrlInDivHandler.reload @ pkp.min.js?v=3.2.0.2:202
a.pkp.controllers.UrlInDivHandler @ pkp.min.js?v=3.2.0.2:202
a.pkp.classes.ObjectProxy.parent @ pkp.min.js?v=3.2.0.2:124
b @ pkp.min.js?v=3.2.0.2:122
a.pkp.classes.Helper.objectFactory @ pkp.min.js?v=3.2.0.2:120
(anonymous) @ pkp.min.js?v=3.2.0.2:429
each @ jquery.min.js?v=3.2.0.2:2
each @ jquery.min.js?v=3.2.0.2:2
a.fn.pkpHandler @ pkp.min.js?v=3.2.0.2:429
(anonymous) @ CrossRefExportPlugin:196
l @ jquery.min.js?v=3.2.0.2:2
c @ jquery.min.js?v=3.2.0.2:2
setTimeout (async)
(anonymous) @ jquery.min.js?v=3.2.0.2:2
u @ jquery.min.js?v=3.2.0.2:2
fireWith @ jquery.min.js?v=3.2.0.2:2
fire @ jquery.min.js?v=3.2.0.2:2
u @ jquery.min.js?v=3.2.0.2:2
fireWith @ jquery.min.js?v=3.2.0.2:2
ready @ jquery.min.js?v=3.2.0.2:2
_ @ jquery.min.js?v=3.2.0.2:clock1230:
In httpd error_log file:
Uncaught Error: Call to a member function getData() on null in /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php:215\nStack trace:\n#0 [internal function]: SearchHandler->{closure}(NULL)\n#1 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(216): array_map(Object(Closure), Array)\n#2 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPRouter.inc.php(391): SearchHandler->authors(Array, Object(Request))\n#3 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)\n#4 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/Dispatcher.inc.php(143): PKPPageRouter->route(Object(Request))\n#5 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPApplication.inc.php(278): Dispatcher->dispatch(Object(Request))\n#6 /var/www/ojs-3.2.0-2/index.php(68): PKPApplication->execute()\n#7 {main}\n thrown in /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php on line 215
PHP Fatal error: Uncaught Exception: DB Error: ERROR: column “p.version” must appear in the GROUP BY clause or be used in an aggregate function\nLINHA 1: …sion_id" where “s”.“context_id” in ( $1) order by “p”.“versi…\n ^ Query: select MIN(p.date_published), MAX(p.date_published) from “publications” as “p” left join “submissions” as “s” on “s”.“submission_id” = “p”.“submission_id” where “s”.“context_id” in (?) order by “p”.“version” asc in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_postgres8), ‘select MIN(p.da…’)\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/services/PKPPublicationService.inc.php(256): DAO->retrieve(‘select MIN(p.da…’, Array)\n#2 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(93): PKP\Services\PKPPublicationService->getDateBoundaries(Array)\n#3 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(146): SearchHandler->_assign in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703
Uncaught Error: Call to a member function getData() on null in /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php:215\nStack trace:\n#0 [internal function]: SearchHandler->{closure}(NULL)\n#1 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(216): array_map(Object(Closure), Array)\n#2 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPRouter.inc.php(391): SearchHandler->authors(Array, Object(Request))\n#3 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)\n#4 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/Dispatcher.inc.php(143): PKPPageRouter->route(Object(Request))\n#5 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPApplication.inc.php(278): Dispatcher->dispatch(Object(Request))\n#6 /var/www/ojs-3.2.0-2/index.php(68): PKPApplication->execute()\n#7 {main}\n thrown in /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php on line 215
PHP Fatal error: Uncaught Exception: DB Error: ERROR: null value in column “submission_id” violates not-null constraint\nDETALHE: Failing row contains (51367, null, 0, marceloaugusti@bol.com.br, 1119, 1, 24779). Query: INSERT INTO authors (email, include_in_browse, publication_id, user_group_id) VALUES (?, ?, ?, ?) in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_postgres8), ‘INSERT INTO aut…’)\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/SchemaDAO.inc.php(79): DAO->update(‘INSERT INTO aut…’, Array)\n#2 /var/www/ojs-3.2.0-2/lib/pkp/classes/submission/form/PKPSubmissionSubmitStep1Form.inc.php(382): SchemaDAO->insertObject(Object(Author))\n#3 /var/www/ojs-3.2.0-2/lib/pkp/pages/submission/PKPSubmissionHandler.inc.php(171): PKPSubmissionSubmitStep1Form->execute()\n#4 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPRouter.inc.php(391): PKPSubmissionHandler->saveStep(Array, Object(Request))\n#5 /var/www/ojs-3.2.0-2/lib/pkp/ in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703, referer: http://periodicos.ufes.br/dimensoes/submission/wizard
PHP Fatal error: Uncaught Exception: DB Error: ERROR: column “p.version” must appear in the GROUP BY clause or be used in an aggregate function\nLINHA 1: …sion_id” where “s”.“context_id” in ( $1) order by “p”.“versi…\n ^ Query: select MIN(p.date_published), MAX(p.date_published) from “publications” as “p” left join “submissions” as “s” on “s”.“submission_id” = “p”.“submission_id” where “s”.“context_id” in (?) order by “p”.“version” asc in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_postgres8), ‘select MIN(p.da…’)\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/services/PKPPublicationService.inc.php(256): DAO->retrieve(‘select MIN(p.da…’, Array)\n#2 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(93): PKP\Services\PKPPublicationService->getDateBoundaries(Array)\n#3 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(146): SearchHandler->_assign in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703
PHP Fatal error: Uncaught Exception: DB Error: ERROR: column “p.date_published” must appear in the GROUP BY clause or be used in an aggregate function\nLINHA 6: ORDER BY p.date_published DESC, s.submission_id DESC LIMI…\n ^ Query: SELECT\ts.\n\t\t\tFROM\tsubmissions s\n\t\t\t\tLEFT JOIN publications p ON s.current_publication_id = p.publication_id\n\t\t\t\tLEFT JOIN publication_settings ps ON p.publication_id = ps.publication_id LEFT JOIN publication_settings pspidt ON (p.publication_id = pspidt.publication_id) WHERE\ts.status = ?\n\t\t\t\tAND s.context_id = ? AND pspidt.setting_name = ? AND pspidt.setting_value IS NOT NULL GROUP BY s.submission_id\n\t\t\tORDER BY p.date_published DESC, s.submission_id DESC in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(197): DAO->handleError(Object(ADODB_postgres8), 'SELECT\ts.\n\t\t\tF…')\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/submission/PKPSubmissionDAO.inc.php(388): DAO->retrieveRange('SELECT\ts.\n\t\t\tF. in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703, referer: http://periodicos.ufes.br/geografares/management/importexport/plugin/CrossRefExportPlugin
ojs3: Sem objetos selecionados., referer: http://periodicos.ufes.br/geografares/management/importexport/plugin/CrossRefExportPlugin
PHP Fatal error: Uncaught Exception: DB Error: ERROR: column “p.date_published” must appear in the GROUP BY clause or be used in an aggregate function\nLINHA 6: ORDER BY p.date_published DESC, s.submission_id DESC LIMI…\n ^ Query: SELECT\ts.\n\t\t\tFROM\tsubmissions s\n\t\t\t\tLEFT JOIN publications p ON s.current_publication_id = p.publication_id\n\t\t\t\tLEFT JOIN publication_settings ps ON p.publication_id = ps.publication_id LEFT JOIN publication_settings pspidt ON (p.publication_id = pspidt.publication_id) WHERE\ts.status = ?\n\t\t\t\tAND s.context_id = ? AND pspidt.setting_name = ? AND pspidt.setting_value IS NOT NULL GROUP BY s.submission_id\n\t\t\tORDER BY p.date_published DESC, s.submission_id DESC in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(197): DAO->handleError(Object(ADODB_postgres8), 'SELECT\ts.\n\t\t\tF…')\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/submission/PKPSubmissionDAO.inc.php(388): DAO->retrieveRange('SELECT\ts.\n\t\t\tF. in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703, referer: http://periodicos.ufes.br/geografares/management/importexport/plugin/CrossRefExportPlugin
ojs3: 404 Not Found, referer: http://publicacoes.ufes.br/
PHP Fatal error: Uncaught Exception: DB Error: ERROR: column “p.version” must appear in the GROUP BY clause or be used in an aggregate function\nLINHA 1: …sion_id” where “s”.“context_id” in ( $1) order by “p”.“versi…\n ^ Query: select MIN(p.date_published), MAX(p.date_published) from “publications” as “p” left join “submissions” as “s” on “s”.“submission_id” = “p”.“submission_id” where “s”.“context_id” in (?) order by “p”.“version” asc in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_postgres8), ‘select MIN(p.da…’)\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/services/PKPPublicationService.inc.php(256): DAO->retrieve(‘select MIN(p.da…’, Array)\n#2 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(93): PKP\Services\PKPPublicationService->getDateBoundaries(Array)\n#3 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(146): SearchHandler->_assign in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703
ojs3: 404 Not Found
PHP Fatal error: Uncaught Error: Call to a member function getData() on null in /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php:215\nStack trace:\n#0 [internal function]: SearchHandler->{closure}(NULL)\n#1 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(216): array_map(Object(Closure), Array)\n#2 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPRouter.inc.php(391): SearchHandler->authors(Array, Object(Request))\n#3 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)\n#4 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/Dispatcher.inc.php(143): PKPPageRouter->route(Object(Request))\n#5 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPApplication.inc.php(278): Dispatcher->dispatch(Object(Request))\n#6 /var/www/ojs-3.2.0-2/index.php(68): PKPApplication->execute()\n#7 {main}\n thrown in /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php on line 215
PHP Fatal error: Uncaught Exception: DB Error: ERROR: column “p.date_published” must appear in the GROUP BY clause or be used in an aggregate function\nLINE 6: ORDER BY p.date_published DESC, s.submission_id DESC LIMI…\n ^ Query: SELECT\ts.\n\t\t\tFROM\tsubmissions s\n\t\t\t\tLEFT JOIN publications p ON s.current_publication_id = p.publication_id\n\t\t\t\tLEFT JOIN publication_settings ps ON p.publication_id = ps.publication_id LEFT JOIN publication_settings pspidt ON (p.publication_id = pspidt.publication_id) WHERE\ts.status = ?\n\t\t\t\tAND s.context_id = ? AND pspidt.setting_name = ? AND pspidt.setting_value IS NOT NULL GROUP BY s.submission_id\n\t\t\tORDER BY p.date_published DESC, s.submission_id DESC in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(197): DAO->handleError(Object(ADODB_postgres8), 'SELECT\ts.\n\t\t\tF…')\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/submission/PKPSubmissionDAO.inc.php(388): DAO->retrieveRange('SELECT\ts.*\n\t\t\tF… in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703, referer: http://periodicos.ufes.br/geografares/management/importexport/plugin/CrossRefExportPlugin
HP Fatal error: Uncaught Error: Call to a member function getData() on null in /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php:215\nStack trace:\n#0 [internal function]: SearchHandler->{closure}(NULL)\n#1 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(216): array_map(Object(Closure), Array)\n#2 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPRouter.inc.php(391): SearchHandler->authors(Array, Object(Request))\n#3 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)\n#4 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/Dispatcher.inc.php(143): PKPPageRouter->route(Object(Request))\n#5 /var/www/ojs-3.2.0-2/lib/pkp/classes/core/PKPApplication.inc.php(278): Dispatcher->dispatch(Object(Request))\n#6 /var/www/ojs-3.2.0-2/index.php(68): PKPApplication->execute()\n#7 {main}\n thrown in /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php on line 215
PHP Warning: Division by zero in /var/www/ojs-3.2.0-2/lib/pkp/classes/core/ArrayItemIterator.inc.php on line 134, referer: https://periodicos.ufes.br/argumentum/submissions
PHP Warning: Division by zero in /var/www/ojs-3.2.0-2/lib/pkp/classes/core/ArrayItemIterator.inc.php on line 134, referer: https://periodicos.ufes.br/argumentum/submissions
PHP Warning: Division by zero in /var/www/ojs-3.2.0-2/lib/pkp/classes/core/ArrayItemIterator.inc.php on line 134, referer: https://periodicos.ufes.br/argumentum/workflow/index/27927/3
PHP Warning: Division by zero in /var/www/ojs-3.2.0-2/lib/pkp/classes/core/ArrayItemIterator.inc.php on line 134, referer: https://periodicos.ufes.br/argumentum/workflow/index/27927/3
HP Fatal error: Uncaught Exception: DB Error: ERROR: column “p.version” must appear in the GROUP BY clause or be used in an aggregate function\nLINHA 1: …sion_id” where “s”.“context_id” in ( $1) order by “p”.“versi…\n ^ Query: select MIN(p.date_published), MAX(p.date_published) from “publications” as “p” left join “submissions” as “s” on “s”.“submission_id” = “p”.“submission_id” where “s”.“context_id” in (?) order by “p”.“version” asc in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_postgres8), ‘select MIN(p.da…’)\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/services/PKPPublicationService.inc.php(256): DAO->retrieve(‘select MIN(p.da…’, Array)\n#2 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(93): PKP\Services\PKPPublicationService->getDateBoundaries(Array)\n#3 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(146): SearchHandler->_assign in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703
HP Fatal error: Uncaught Exception: DB Error: ERROR: column “p.version” must appear in the GROUP BY clause or be used in an aggregate function\nLINHA 1: …sion_id” where “s”.“context_id” in ( $1) order by “p”.“versi…\n ^ Query: select MIN(p.date_published), MAX(p.date_published) from “publications” as “p” left join “submissions” as “s” on “s”.“submission_id” = “p”.“submission_id” where “s”.“context_id” in (?) order by “p”.“version” asc in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_postgres8), ‘select MIN(p.da…’)\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/services/PKPPublicationService.inc.php(256): DAO->retrieve(‘select MIN(p.da…’, Array)\n#2 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(93): PKP\Services\PKPPublicationService->getDateBoundaries(Array)\n#3 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(146): SearchHandler->_assign in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703
ojs3: 404 Not Found, referer: http://periodicos.ufes.br/machadiana/help/view/editorial/topic/000015
PHP Fatal error: Uncaught Exception: DB Error: ERROR: column “p.version” must appear in the GROUP BY clause or be used in an aggregate function\nLINHA 1: …sion_id” where “s”.“context_id” in ( $1) order by “p”."versi…\n ^ Query: select MIN(p.date_published), MAX(p.date_published) from “publications” as “p” left join “submissions” as “s” on “s”.“submission_id” = “p”.“submission_id” where “s”.“context_id” in (?) order by “p”.“version” asc in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_postgres8), ‘select MIN(p.da…’)\n#1 /var/www/ojs-3.2.0-2/lib/pkp/classes/services/PKPPublicationService.inc.php(256): DAO->retrieve(‘select MIN(p.da…’, Array)\n#2 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(93): PKP\Services\PKPPublicationService->getDateBoundaries(Array)\n#3 /var/www/ojs-3.2.0-2/pages/search/SearchHandler.inc.php(146): SearchHandler->_assign in /var/www/ojs-3.2.0-2/lib/pkp/classes/db/DAO.inc.php on line 703
My system information:
OS platform: Linux
PHP version: 7.2.22
Apache version: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.2.22
Database driver: postgres
Database server version: PostgreSQL 9.2.24 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit|
could you help me?