500 Internal Server Error on a Particular OJS User Login

Hi there!

I am facing a strange issue since 2 days, one of our Journal Editor(s) is having problem signing in to the OJS site. Whenever, he logs in, 500 Internal Server Error screen popsup. On Investigating the Server Log, I have found some of such lines there:
[Wed Mar 27 10:25:15.727631 2024] [fcgid:warn] [pid 138927:tid 138960] [client 182.184.66.75:8679] mod_fcgid: stderr: PHP Warning: Undefined array key “zh_TW” in /var/www/clients/client0/web4/web/journal/lib/pkp/classes/site/Site.inc.php on line 39, referer: https://www.annalskemu.org/journal/index.php/annals/management/settings/access
[Wed Mar 27 10:25:27.204852 2024] [fcgid:warn] [pid 138927:tid 138968] [client 182.184.66.75:8679] mod_fcgid: stderr: PHP Fatal error: Uncaught Error: Call to a member function getFullName() on null in /var/www/clients/client0/web4/web/journal/lib/pkp/classes/submission/reviewAssignment/ReviewAssignmentDAO.inc.php:453, referer: https://www.annalskemu.org/journal/index.php/annals/management/settings/access
[Wed Mar 27 10:25:27.204898 2024] [fcgid:warn] [pid 138927:tid 138968] [client 182.184.66.75:8679] mod_fcgid: stderr: Stack trace:, referer: https://www.annalskemu.org/journal/index.php/annals/management/settings/access
[Wed Mar 27 10:25:27.204902 2024] [fcgid:warn] [pid 138927:tid 138968] [client 182.184.66.75:8679] mod_fcgid: stderr: #0 /var/www/clients/client0/web4/web/journal/lib/pkp/classes/submission/reviewAssignment/ReviewAssignmentDAO.inc.php(68): ReviewAssignmentDAO->_fromRow(), referer: https://www.annalskemu.org/journal/index.php/annals/management/settings/access
[Wed Mar 27 10:25:27.204906 2024] [fcgid:warn] [pid 138927:tid 138968] [client 182.184.66.75:8679] mod_fcgid: stderr: #1 /var/www/clients/client0/web4/web/journal/lib/pkp/classes/submission/reviewAssignment/ReviewAssignmentDAO.inc.php(187): ReviewAssignmentDAO->_getReviewAssignmentsArray(), referer: https://www.annalskemu.org/journal/index.php/annals/management/settings/access
[Wed Mar 27 10:25:27.204910 2024] [fcgid:warn] [pid 138927:tid 138968] [client 182.184.66.75:8679] mod_fcgid: stderr: #2 /var/www/clients/client0/web4/web/journal/lib/pkp/classes/services/PKPSubmissionService.inc.php(692): ReviewAssignmentDAO->getBySubmissionId(), referer: https://www.annalskemu.org/journal/index.php/annals/management/settings/access
[Wed Mar 27 10:25:27.204914 2024] [fcgid:warn] [pid 138927:tid 138968] [client 182.184.66.75:8679] mod_fcgid: stderr: #3 /var/www/clients/client0/web4/web/journal/lib/pkp/classes/services/PKPSubmissionService.inc.php(310): PKP\Services\PKPSubmissionService->getReviewAssignments(), referer: https://www.annalskemu.org/journal/index.php/annals/management/settings/access
[Wed Mar 27 10:25:27.204918 2024] [fcgid:warn] [pid 138927:tid 138968] [client 182.184.66.75:8679] mod_fcgid: stderr: #4 /var/www/clients/client0/web4/web/journal/lib/pkp/classes/services/PKPSubmissionService.inc.php(214): PKP\Services\PKPSubmissionService->getPropertyReviewAssignments(), referer: https://www.annalskemu.org/journal/index.php/annals/management/settings/access
[Wed Mar 27 10:25:27.204922 2024] [fcgid:warn] [pid 138927:tid 138968] [client 182.184.66.75:8679] mod_fcgid: stderr: #5 /var/www/clients/client0/web4/web/journal/lib/pkp/classes/services/PKPSubmissionService.inc.php(299): PKP\Services\PKPSubmissionService->getProperties(), referer: https://www.annalskemu.org/journal/index.php/annals/management/settings/access

I have tried clear all type of caches using OJS administration, changed User’s password. But the problem is still there. And surprisingly, it is only happening for that user particularly. Other users are loggin in fine. Please assist accordingly.

PHP 8.x
OJS Version : 3.3.0.17

Regards,

Hi @Farhan_Abbas ,
I’m assuming that your user is probably Chinese (because of the zh_TW language), maybe you can check the username, first and last name for special characters (not ascii).

This is not the case for this user. This user account belongs to our organizational employee and he is a co worker. I even tried to Log in as this user by using Administrator rights but get the same error. Kindly advise any further steps.

Well, it seems like a very simple way of looking at it, but many of these errors are removed simply by clearing the browser’s cache and cookies.

Hi @Farhan_Abbas,

I think you are missing a user entry for a corresponding review assignment. Try this query:

SELECT ra.review_id, ra.reviewer_id AS user_id FROM review_assignments ra LEFT JOIN users u ON (ra.reviewer_id = u.user_id) WHERE u.user_id IS NULL;

If this provides any results, it means you are missing a user entry with the corresponding user_id.

Regards,
Alec Smecher
Public Knowledge Project Team