All Active Submissions Error

[pkahai]

Describe the issue or problem

• Error when trying to navigate under the All Active submissions tab.

Steps I took leading up to the issue
After logging-in as admin, I navigate to Submissions, then to the All Active tab. I can see the list of articles.

• First, the count of articles is incorrect: a much higher number is displayed.
• Second, when I click on Next Page at the bottom, I see errror message An unexpected error has occurred. Please reload the page and try again. The server log is as follows:

192.168.0.109 - - [14/May/2025:16:06:22 -0500] “GET /jstem/index.php/JSTEM/api/v1/submissions?status%5B%5D=4&status%5B%5D=3&status%5B%5D=5&searchPhrase=&count=30&offset=0&=1747256780816 HTTP/1.1” 200 114579 “http://192.168.0.53/jstem/index.php/JSTEM/submissions” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36”

192.168.0.109 - - [14/May/2025:16:06:22 -0500] “GET /jstem/index.php/JSTEM/api/v1/submissions?status=1&searchPhrase=&count=30&offset=0&=1747256780815 HTTP/1.1” 200 130719 “http://192.168.0.53/jstem/index.php/JSTEM/submissions” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36”

192.168.0.109 - - [14/May/2025:16:06:34 -0500] “GET /jstem/index.php/JSTEM/api/v1/submissions?status=1&searchPhrase=&count=30&offset=30&=1747256780817 HTTP/1.1” 500 917 “http://192.168.0.53/jstem/index.php/JSTEM/submissions” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36”

192.168.0.109 - - [14/May/2025:16:08:09 -0500] “GET /jstem/index.php/JSTEM/submissions HTTP/1.1” 200 6096 “http://192.168.0.53/jstem/index.php/JSTEM/login” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36”

192.168.0.109 - - [14/May/2025:16:08:09 -0500] “GET /jstem/index.php/JSTEM/api/v1/submissions?status=1&assignedTo=-1&searchPhrase=&count=30&offset=0&=1747256887411 HTTP/1.1” 200 506 “http://192.168.0.53/jstem/index.php/JSTEM/submissions” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36”

What application are you using?

• OJS 3.3.0-19

Additional information

• Developer Tools Error 1

• Developer Tools Error 2

[asmecher]

Hi @pkahai,

Check your PHP error log; a 500 error will just about always leave details there.

Regards,
Alec Smecher
Public Knowledge Project Team

[pkahai]

Here’s the PHP log:

2025-05-15T12:11:50.289566-05:00 pk-server-u php: Slim Application Error:
2025-05-15T12:11:50.289858-05:00 pk-server-u php: Type: Error
2025-05-15T12:11:50.289898-05:00 pk-server-u php: Message: Call to a member function getFullName() on null
2025-05-15T12:11:50.289930-05:00 pk-server-u php: File: /var/www/html/jstem/lib/pkp/classes/submission/reviewAssignment/ReviewAssignmentDAO.inc.php
2025-05-15T12:11:50.289962-05:00 pk-server-u php: Line: 453
2025-05-15T12:11:50.290035-05:00 pk-server-u php: Trace: #0 /var/www/html/jstem/lib/pkp/classes/submission/reviewAssignment/ReviewAssignmentDAO.inc.php(68): ReviewAssignmentDAO->_fromRow()
2025-05-15T12:11:50.290084-05:00 pk-server-u php: #1 /var/www/html/jstem/lib/pkp/classes/submission/reviewAssignment/ReviewAssignmentDAO.inc.php(187): ReviewAssignmentDAO->_getReviewAssignmentsArray()
2025-05-15T12:11:50.290117-05:00 pk-server-u php: #2 /var/www/html/jstem/lib/pkp/classes/services/PKPSubmissionService.inc.php(692): ReviewAssignmentDAO->getBySubmissionId()
2025-05-15T12:11:50.290149-05:00 pk-server-u php: #3 /var/www/html/jstem/lib/pkp/classes/services/PKPSubmissionService.inc.php(310): PKP\Services\PKPSubmissionService->getReviewAssignments()
2025-05-15T12:11:50.290184-05:00 pk-server-u php: #4 /var/www/html/jstem/lib/pkp/classes/services/PKPSubmissionService.inc.php(214): PKP\Services\PKPSubmissionService->getPropertyReviewAssignments()
2025-05-15T12:11:50.290202-05:00 pk-server-u php: #5 /var/www/html/jstem/lib/pkp/classes/services/PKPSubmissionService.inc.php(299): PKP\Services\PKPSubmissionService->getProperties()
2025-05-15T12:11:50.290221-05:00 pk-server-u php: #6 /var/www/html/jstem/lib/pkp/api/v1/_submissions/PKPBackendSubmissionsHandler.inc.php(160): PKP\Services\PKPSubmissionService->getBackendListProperties()
2025-05-15T12:11:50.290241-05:00 pk-server-u php: #7 [internal function]: PKPBackendSubmissionsHandler->getMany()
2025-05-15T12:11:50.290264-05:00 pk-server-u php: #8 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func()
2025-05-15T12:11:50.290283-05:00 pk-server-u php: #9 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke()
2025-05-15T12:11:50.290302-05:00 pk-server-u php: #10 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke()
2025-05-15T12:11:50.290322-05:00 pk-server-u php: #11 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack()
2025-05-15T12:11:50.290341-05:00 pk-server-u php: #12 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\Route->run()
2025-05-15T12:11:50.290359-05:00 pk-server-u php: #13 /var/www/html/jstem/lib/pkp/classes/security/authorization/internal/ApiAuthorizationMiddleware.inc.php(77): Slim\App->__invoke()
2025-05-15T12:11:50.290375-05:00 pk-server-u php: #14 [internal function]: ApiAuthorizationMiddleware->__invoke()
2025-05-15T12:11:50.290395-05:00 pk-server-u php: #15 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
2025-05-15T12:11:50.290413-05:00 pk-server-u php: #16 [internal function]: Slim\DeferredCallable->__invoke()
2025-05-15T12:11:50.290433-05:00 pk-server-u php: #17 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
2025-05-15T12:11:50.290451-05:00 pk-server-u php: #18 /var/www/html/jstem/lib/pkp/classes/security/authorization/internal/ApiCsrfMiddleware.inc.php(46): Slim\App->Slim{closure}()
2025-05-15T12:11:50.290472-05:00 pk-server-u php: #19 [internal function]: ApiCsrfMiddleware->__invoke()
2025-05-15T12:11:50.290491-05:00 pk-server-u php: #20 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
2025-05-15T12:11:50.290512-05:00 pk-server-u php: #21 [internal function]: Slim\DeferredCallable->__invoke()
2025-05-15T12:11:50.290530-05:00 pk-server-u php: #22 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
2025-05-15T12:11:50.290548-05:00 pk-server-u php: #23 /var/www/html/jstem/lib/pkp/classes/security/authorization/internal/ApiTokenDecodingMiddleware.inc.php(131): Slim\App->Slim{closure}()
2025-05-15T12:11:50.290567-05:00 pk-server-u php: #24 [internal function]: ApiTokenDecodingMiddleware->__invoke()
2025-05-15T12:11:50.290585-05:00 pk-server-u php: #25 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
2025-05-15T12:11:50.290603-05:00 pk-server-u php: #26 [internal function]: Slim\DeferredCallable->__invoke()
2025-05-15T12:11:50.290623-05:00 pk-server-u php: #27 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
2025-05-15T12:11:50.290641-05:00 pk-server-u php: #28 /var/www/html/jstem/lib/pkp/classes/handler/APIHandler.inc.php(68): Slim\App->Slim{closure}()
2025-05-15T12:11:50.290659-05:00 pk-server-u php: #29 [internal function]: APIHandler->{closure}()
2025-05-15T12:11:50.290697-05:00 pk-server-u php: #30 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
2025-05-15T12:11:50.290730-05:00 pk-server-u php: #31 [internal function]: Slim\DeferredCallable->__invoke()
2025-05-15T12:11:50.290750-05:00 pk-server-u php: #32 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
2025-05-15T12:11:50.290768-05:00 pk-server-u php: #33 /var/www/html/jstem/lib/pkp/classes/handler/APIHandler.inc.php(127): Slim\App->Slim{closure}()
2025-05-15T12:11:50.290786-05:00 pk-server-u php: #34 [internal function]: APIHandler->{closure}()
2025-05-15T12:11:50.290807-05:00 pk-server-u php: #35 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
2025-05-15T12:11:50.290826-05:00 pk-server-u php: #36 [internal function]: Slim\DeferredCallable->__invoke()
2025-05-15T12:11:50.290859-05:00 pk-server-u php: #37 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
2025-05-15T12:11:50.290877-05:00 pk-server-u php: #38 /var/www/html/jstem/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\App->Slim{closure}()
2025-05-15T12:11:50.290896-05:00 pk-server-u php: #39 [internal function]: APIHandler->{closure}()
2025-05-15T12:11:50.290917-05:00 pk-server-u php: #40 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
2025-05-15T12:11:50.290936-05:00 pk-server-u php: #41 [internal function]: Slim\DeferredCallable->__invoke()
2025-05-15T12:11:50.290955-05:00 pk-server-u php: #42 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
2025-05-15T12:11:50.290999-05:00 pk-server-u php: #43 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim{closure}()
2025-05-15T12:11:50.291017-05:00 pk-server-u php: #44 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack()
2025-05-15T12:11:50.291037-05:00 pk-server-u php: #45 /var/www/html/jstem/lib/pkp/classes/handler/APIHandler.inc.php(124): Slim\App->process()
2025-05-15T12:11:50.291054-05:00 pk-server-u php: #46 [internal function]: APIHandler->{closure}()
2025-05-15T12:11:50.291072-05:00 pk-server-u php: #47 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
2025-05-15T12:11:50.291093-05:00 pk-server-u php: #48 [internal function]: Slim\DeferredCallable->__invoke()
2025-05-15T12:11:50.291112-05:00 pk-server-u php: #49 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
2025-05-15T12:11:50.291130-05:00 pk-server-u php: #50 /var/www/html/jstem/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\App->Slim{closure}()
2025-05-15T12:11:50.291147-05:00 pk-server-u php: #51 [internal function]: APIHandler->{closure}()
2025-05-15T12:11:50.291165-05:00 pk-server-u php: #52 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
2025-05-15T12:11:50.291184-05:00 pk-server-u php: #53 [internal function]: Slim\DeferredCallable->__invoke()
2025-05-15T12:11:50.291205-05:00 pk-server-u php: #54 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
2025-05-15T12:11:50.291225-05:00 pk-server-u php: #55 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim{closure}()
2025-05-15T12:11:50.291244-05:00 pk-server-u php: #56 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack()
2025-05-15T12:11:50.291263-05:00 pk-server-u php: #57 /var/www/html/jstem/lib/pkp/lib/vendor/slim/slim/Slim/App.php(297): Slim\App->process()
2025-05-15T12:11:50.291281-05:00 pk-server-u php: #58 /var/www/html/jstem/lib/pkp/classes/core/APIRouter.inc.php(115): Slim\App->run()
2025-05-15T12:11:50.291300-05:00 pk-server-u php: #59 /var/www/html/jstem/lib/pkp/classes/core/Dispatcher.inc.php(144): APIRouter->route()
2025-05-15T12:11:50.291318-05:00 pk-server-u php: #60 /var/www/html/jstem/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch()
2025-05-15T12:11:50.291337-05:00 pk-server-u php: #61 /var/www/html/jstem/index.php(68): PKPApplication->execute()
2025-05-15T12:11:50.291358-05:00 pk-server-u php: #62 {main}
2025-05-15T12:11:50.291378-05:00 pk-server-u php: View in rendered output by enabling the “displayErrorDetails” setting.
2025-05-15T12:11:50.291397-05:00 pk-server-u php:

[asmecher]

Hi @pkahai,

This is a data error; you appear to have a review assignement associated with a non-existent user account. Try the following query in your database:

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

If this returns any results, you’ll have to clean up those entries in review_assignments either by editing them to assign another user in the reviewer_id column, or by deleting them. I recommend the first approach. You’ll need to do this directly in your database. As always, make sure to take a good backup before working directly in the database.

Regards,
Alec Smecher
Public Knowledge Project Team

[pkahai]

Hi @asmecher,

I figured out what the problem was. Over a period of time, assistants took shortcuts and didn’t follow the workflow recommendations. Thus, we had several accepted, declined, and abandoned submissions in the Submissions table, all with a status of 1. Once I went through the table, and also the Publications table, and changed the status to the appropriate value, everything began to work as designed. I just have to update the publication_date and URL of the published articles now. Are there any other tables I need to update? That would help me much.

I have another question but I will post that in a separate thread. I think you can close this thread.

Best!

Perry

[asmecher]

Hi @pkahai,

Without knowing more about your specific situation, I’m not sure what other tables/columns to check over – but I’ll watch for your other thread. It sounds like you’ve resolved this one.

Regards,
Alec Smecher
Public Knowledge Project Team