Description of issue or problem I’m having:
Activity log loading error on all submission and will give 500 server error
$$$call$$$/grid/event-log/submission-event-log-grid/fetch-grid?submissionId
Steps I took leading up to the issue:
open the activity log and it will not show
What I tried to resolve the issue:
i refer to the topic below and try the query but give no result
https://forum.pkp.sfu.ca/t/ojs3-error-when-open-activity-log-notes-for-some-submissions-after-update-to-3-3-0-7/69382
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;
Application Version - e.g., OJS 3.1.2:
ojs 3.3.0.8
Additional information, such as screenshots and error log messages if applicable:
PHP Notice: Undefined index: stageId in G:\inetpub\wwwroot\journalfolder\lib\pkp\controllers\grid\eventLog\SubmissionEventLogGridHandler.inc.php on line 111
no php fatal error in php log… only this php notice
thank for the support