Reviewer unable to accept review

Software Support
1

Hi,

I’m using OJS version 3.2.1-1 with postgres.
I have a issue, a reviewer is unable to accept a review.
Browser console:

POST http://www.revistas.usp.br/gis/reviewer/saveStep/174364?step=1 500 (Internal Server Error)

error.log:

PHP Fatal error: Uncaught Error: Call to a member function getEmail() on null in /var/www/revistas3/html/lib/pkp/classes/submission/reviewer/ReviewerAction.inc.php:109\nStack trace:\n#0 /var/www/revistas3/html/lib/pkp/classes/submission/reviewer/ReviewerAction.inc.php(49): ReviewerAction->getResponseEmail(Object(ReviewerSubmission), Object(ReviewAssignment), Object(Request), false)\n#1 /var/www/revistas3/html/lib/pkp/classes/submission/reviewer/form/PKPReviewerReviewStep1Form.inc.php(140): ReviewerAction->confirmReview(Object(Request), Object(ReviewAssignment), Object(ReviewerSubmission), false)\n#2 /var/www/revistas3/html/lib/pkp/pages/reviewer/PKPReviewerHandler.inc.php(115): PKPReviewerReviewStep1Form->execute()\n#3 /var/www/revistas3/html/lib/pkp/classes/core/PKPRouter.inc.php(391): PKPReviewerHandler->saveStep(Array, Object(Request))\n#4 /var/www/revistas3/html/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)\n#5 /var/www/revistas3/html/lib/pkp/ in /var/www/revistas3/html/lib/pkp/classes/submission/reviewer/ReviewerAction.inc.php on line 109, referer: http://www.revistas.usp.br/gis/reviewer/submission/174364

Regards,
Tarcisio Pereira.

2

Hi @Tarcisio_Pereira,

It looks like that submission has a stage assignment to a non-existent user. What do you see for the following database query?

SELECT sa.* FROM stage_assignments sa LEFT JOIN users u ON (sa.user_id = u.user_id) WHERE u.user_id IS NULL;

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi @asmecher

I have 637 records in this situation…

stage_assignment_id submission_id user_group_id user_id date_assigned recommend_only can_change_metadata
223379 174799 686 36512 2020-09-15 14:26:57 0 1
223380 174799 685 36512 2020-09-15 14:26:57 0 1
223250 174741 685 36512 2020-09-13 18:37:08 0 1
223249 174741 686 36512 2020-09-13 18:37:08 0 1
222480 174386 685 36512 2020-09-01 15:52:33 0 1
222479 174386 686 36512 2020-09-01 15:52:33 0 1
222423 174370 685 36512 2020-09-01 02:09:07 0 1
222422 174370 686 36512 2020-09-01 02:09:07 0 1
222518 174364 685 36512 2020-09-01 20:55:55 0 1
222517 174364 686 36512 2020-09-01 20:55:55 0 1
…

What can be done?
This is wird…

Regards,
Tarcisio

4

Hi @Tarcisio_Pereira,

It looks like user ID 36512 is missing from the users table. You’ll either need to re-create that user, or remove references to it from the stage_assignments table.

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like