It looks to me as though a recommendation has been recorded by Reviewer A, although for some reason that field is showing blank in the screenshot. Have you made any changes to the system regarding reviewer recommendation options?
Regards,
Alec Smecher
Public Knowledge Project Team
SELECT DISTINCT recommendation FROM review_assignments WHERE date_completed IS NOT NULL;
This should list all unique recommendations – they should be numeric. If you see an empty row, then that’s likely your problem review – it would suggest that a review was recorded with an empty recommendation, which (IIRC) shouldn’t be possible.
Regards,
Alec Smecher
Public Knowledge Project Team
OTOH it might also be the 1. You can get a list of affected reviews by calling…
SELECT review_id, submission_id FROM review_assignments WHERE recommendation = 0 AND date_completed IS NOT NULL;
SELECT review_id, submission_id FROM review_assignments WHERE recommendation IS NULL AND date_completed IS NOT NULL;
Then the best approach might be to reset the date_completed – returning the reviews to an active state the reviewers can work with. You’d do that for a given review_id like this:
UPDATE review_assignments SET date_completed = NULL WHERE review_id = 123;
…replacing 123 with the review ID you want to affect.
Please back up the database before working directly with it, in case I’ve made a mistake in the above!
Regards,
Alec Smecher
Public Knowledge Project Team
Ah, that 0 in the recommendation column is the problem, I’ll bet. There is no valid 0 recommendation – it should be 1-6, corresponding to the constants defined in lib/pkp/classes/submission/reviewAssignment/PKPReviewAssignment.inc.php.
Regards,
Alec Smecher
Public Knowledge Project Team
UPDATE review_assignments SET recommendation = NULL WHERE review_id = 4105;
Fixed the problem, then i decided to check if there’s any other remaining zeroed entries and:
select * from review_assignments where recommendation = 0;
194 rows in set (0.01 sec)
So…
UPDATE review_assignments SET recommendation = NULL WHERE recommendation = 0;
Should deal with everything.
@asmecher Is there any use case where recommendation would be set to 0 instead of NULL and not be some kind of bug?
I’m asking this because i will then change all the 194 records and i don’t wanna break anything.
I can’t think of any reason this would happen – it’s not valid data. I suspect it’s connected to the plugin you mentioned earlier – it might be worth checking in with that developer.
Regards,
Alec Smecher
Public Knowledge Project Team