Hi I have a weird case with an OJS instance v3.3.0.15, which has the scheduled tasks enabled and the plugin Acron enabled too; however the automatic review reminders are not being sent.
I have verified that the journal’s editor had modified the email templates, so I tried to reset them; however I noticed this action no set the right content; I noticed that comparing with another clean OJS instance and the templates are not the same.
The templates which the editor modified were:
REVIEW_REMIND_AUTO
REVIEW_REMIND_AUTO_ONECLICK
REVIEW_REMIND_ONECLICK
REVIEW_REQUEST_REMIND_AUTO_ONECLICK
I have tested in other OJS v3.3.0.15 and noticed that the email template used for the automatic review reminder was “REVIEW_REQUEST_REMIND_AUTO_ONECLICK”, so I copy the template from the working review reminders OJS, however I didn’t get success.
I have read in other posts and I found the database’s tables where is storing the data of review assignments. I left below that information that I’ve found:
SELECT review_id, reviewer_id, date_assigned, date_notified, date_response_due, date_due,
date_reminded, reminder_was_automatic, review_form_id
FROM review_assignments
WHERE submission_id = 61357;
+-----------+-------------+---------------------+---------------------+---------------------+---------------------+---------------------+------------------------+----------------+
| review_id | reviewer_id | date_assigned | date_notified | date_response_due | date_due | date_reminded | reminder_was_automatic | review_form_id |
+-----------+-------------+---------------------+---------------------+---------------------+---------------------+---------------------+------------------------+----------------+
| 9494 | 47865 | 2024-11-28 19:11:57 | 2024-11-28 19:11:57 | 2024-11-29 00:00:00 | 2024-11-29 00:00:00 | 2024-12-02 12:27:39 | 0 | NULL |
| 9495 | 47869 | 2024-12-03 13:30:07 | 2024-12-03 13:30:07 | 2024-12-04 00:00:00 | 2024-12-05 00:00:00 | 2024-12-07 15:36:32 | 0 | 126 |
| 9501 | 47878 | 2024-12-07 16:24:41 | 2024-12-07 16:24:41 | 2024-12-09 00:00:00 | 2024-12-10 00:00:00 | NULL | 0 | 126 |
+-----------+-------------+---------------------+---------------------+---------------------+---------------------+---------------------+------------------------+----------------+
In the previous resultset there are 3 review assignments, the third row is about the last assignment, as it could be seen, the date_assigned was 2024-12-07, the date_response_due was 2024-12-09, and the date_due was 2024-12.10, I’m writing this topic the 2024-12-11, it’s time the review reminder is not being sent.
Reviewing the scheduled_tasks table:
SELECT * FROM scheduled_tasks
WHERE class_name = 'lib.pkp.classes.task.ReviewReminder'
ORDER by last_run DESC;
+-------------------------------------+---------------------+
| class_name | last_run |
+-------------------------------------+---------------------+
| lib.pkp.classes.task.ReviewReminder | 2024-12-11 12:10:55 |
+-------------------------------------+---------------------+
I understood that Acron plugin executes the task ReviewReminder today 2024-12-11; however reviewing the file Recordatorioderevisión-6759d5af64265-20241211.log I found:
So for a weird reason the task is not finished. Some of the PKP team or in thie awesome community can help me to resolve this trouble?
Thanks in advance:
The enviroment of my server is:
PHP 7.4.33
Apache 2.4.6
Centos 7
MariaDB 10.6.17