All Active Submissions Error

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

Hi @pkahai,

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

Regards,
Alec Smecher
Public Knowledge Project Team

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:

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

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

1 Like

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

This topic was automatically closed after 11 days. New replies are no longer allowed.