Editorila history loading forever, just spinner

[primozs]

Dear all,

I am using OJS 3.3.0.5 and have found out that on two submissions the ‘Editorial history’ doesn’t show and just spins forever.
The error in the apache log is the following:

B
[Sat Apr 02 12:03:07.874901 2022] [php7:notice] [pid 1536752] [client 193.95.221.108:51088] PHP Notice: Undefined index: stageId in /…/ojs/lib/pkp/controllers/grid/eventLog/SubmissionEventLogGridHandler.inc.php on line 111, referer: https://…/workflow/index/3116/1
[Sat Apr 02 12:03:07.944326 2022] [php7:error] [pid 1536752] [client 193.95.221.108:51088] PHP Fatal error: Uncaught Error: Call to a member function getAssocId() on null in /…/lib/pkp/classes/services/PKPSubmissionFileService.inc.php:774\nStack trace:\n#0 /…/lib/pkp/controllers/grid/eventLog/EventLogGridRow.inc.php(79): PKP\Services\PKPSubmissionFileService->getWorkflowStageId()\n#1 /…/lib/pkp/classes/controllers/grid/GridHandler.inc.php(1066): EventLogGridRow->initialize()\n#2 /…/lib/pkp/classes/controllers/grid/GridHandler.inc.php(983): GridHandler->_getInitializedRowInstance()\n#3 /…/lib/pkp/classes/controllers/grid/GridHandler.inc.php(1031): GridHandler->renderRowsInternally()\n#4 /…/lib/pkp/classes/controllers/grid/GridHandler.inc.php(921): GridHandler->renderGridBodyPartsInternally()\n#5 /…/lib/pkp/classes/controllers/grid/GridHandler.inc.php(643): GridHandler->doSpecificFetchGridActions()\n#6 /…/lib/pkp/classes/core/PKPRouter.inc.php(395): GridHandler->fetchGrid()\n#7 /…/lib/pkp/clas in /…/lib/pkp/classes/services/PKPSubmissionFileService.inc.php on line 774, referer: https://…/workflow/index/3116/1

Any idea how to investigate further?

Regards, Primož

[dagosalas]

I think this can be useful

Activity log doesn't load [OJS 3.3.0.6]

@jnugent Hello we found the solution, we ran the commands below and solved it, thanks for the support, we can close this ticket. SELECT sf.submission_file_id FROM submission_files sf LEFT JOIN notes n ON (sf.assoc_id = n.note_id) WHERE sf.assoc_type = 520 AND n.note_id IS NULL; DELETE FROM submission_file_revisions WHERE submission_file_id IN (SELECT sf.submission_file_id FROM submission_files sf LEFT JOIN notes n ON (sf.assoc_id = n.note_id) WHERE sf.assoc_type = 520 AND n.note_id IS NULL); …

Activity log doesn't load [OJS 3.3.0.6]

Hi all, This appears to be the issue also under discussion here: Regards, Alec Smecher Public Knowledge Project Team

[primozs]

Thank you @dagosalas it works for me too!

[Tiziano]

hi @dagosalas in my case, this is the log error file:

[Wed Apr 06 11:09:11.110840 2022] [php7:error] [pid 5498:tid 140166744184576] [client 10.200.225.10:38582] PHP Fatal error: Uncaught Error: Call to a member function getAssocId() on null in /var/www/vhosts/monaldi/lib/pkp/classes/services/PKPSubmissionFileService.inc.php:774\nStack trace:\n#0 /var/www/vhosts/monaldi/lib/pkp/controllers/grid/eventLog/EventLogGridRow.inc.php(79): PKP\Services\PKPSubmissionFileService->getWorkflowStageId(Object(SubmissionFile))\n#1 /var/www/vhosts/monaldi/lib/pkp/classes/controllers/grid/GridHandler.inc.php(1066): EventLogGridRow->initialize(Object(Request))\n#2 /var/www/vhosts/monaldi/lib/pkp/classes/controllers/grid/GridHandler.inc.php(983): GridHandler->_getInitializedRowInstance(Object(Request), 15, Object(SubmissionEventLogEntry))\n#3 /var/www/vhosts/monaldi/lib/pkp/classes/controllers/grid/GridHandler.inc.php(1031): GridHandler->renderRowsInternally(Object(Request), Array)\n#4 /var/www/vhosts/monaldi/lib/pkp/classes/controllers/grid/GridHandler.inc.php(921): GridHandler->renderGridBodyPartsInternally(Object(Request))\n#5 /var/www/vhosts/monaldi/lib/pkp/classes/controllers/grid/GridHandler.inc.php(643) in /var/www/vhosts/monaldi/lib/pkp/classes/services/PKPSubmissionFileService.inc.php on line 774, referer: https://www.monaldi-archives.org/index.php/macd/workflow/index/2280/3

My version of OJS is 3.3.0.9
I would need support to understand where the problem lies here, can you help me?
thanks a lot!

Bye
Tiziano

[dagosalas]

Hi @Tiziano ,

Do you have the same problem? If that is not the case,
Could you make a new post where you explain the problem in this way it will reach other members of the community?

If it´s the same, could you explain the error and what actions trigger this message?

Thanks!