Activity log doesn't load [OJS 3.3.0.6]

asmecher · November 16, 2021, 8:13pm

Hi all,

This appears to be the issue also under discussion here:

github.com/pkp/pkp-lib

Activity Log fails to load when a file has been uploaded to a discussion message that was deleted

opened 09:11AM - 12 Nov 21 UTC

zalamuia

Bug

**Describe the bug** Please tell us what happens, what you expected to happen, …and why you think it is a bug in the software. I am using **OJS 3.3.0.8** based on OS platform | Linux PHP version | 7.4.15 Apache version | Apache/2.4.6 (CentOS) Database driver | mysql Database server version | 5.5.60-MariaDB ---------------------------------------------- It is found that some of the **Activity Log** can't be visible if the author deleted some of the notes. I just noticed recently at the production stage, the author deleted some conversions and I could not able to upload files at the copyediting stage as well as I am unable to view the activity log. When I checked the database I have seen discontinued **note id** Then I have added those missing ID's by copying the existing record then I managed to see the activity log and upload the file. Please find the attached picture in a sequence. ![InfiniteLoop](https://user-images.githubusercontent.com/61810595/141439607-83da816f-68f1-40cd-96b5-069b9b3fa264.png) ![Notes_Deleted_Screenshot 2021-11-12 162249-L](https://user-images.githubusercontent.com/61810595/141439662-ecf57733-611f-4fd9-8a86-53f8ef330f33.png) **Added two records by copying from one of the conversation by changing the note id** ![Screenshot 2021-11-12 163437_enteredRecord](https://user-images.githubusercontent.com/61810595/141439745-ce3316f5-2e12-46d1-bb15-2ebc4cea207f.png) **after added two records** ![Act_log_after_added](https://user-images.githubusercontent.com/61810595/141441332-18611b79-28d4-433e-afea-8674141c47c6.png) I also faced this problem in many articles and could not be managed to identify the root cause of the problem. However, today I was communicating with the authors and noticed that the uploaded file with communication is missing and I tried to see the activity but I could not manage to see it. I could manage to find the database since I have access to the database and added those missing data to see the functionality. I hope that the issue can be resolved if the author deleted some conversations. Thanks. Zahirul

Regards,
Alec Smecher
Public Knowledge Project Team