We are moving to Git Issues for bug tracking in future releases. During transition, content will be in both tools. If you'd like to file a new bug, please create an issue.

Bug 8495

Summary: Review round and signoff deletes don't clean corresponding notifications
Product: OMP Reporter: Alec Smecher <alec>
Component: GeneralAssignee: PKP Support <pkp-support>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P3    
Version: 1.1   
Hardware: All   
OS: All   
Version Reported In: Also Affects:

Description Alec Smecher 2013-12-02 12:01:04 PST
Review round and signoff deletes don't clean corresponding notifications. This results in a broken Tasks grid.
Comment 1 Alec Smecher 2013-12-02 12:20:03 PST
Clean up during upgrade
https://github.com/pkp/omp/commit/0fa4c94dd24ce936ff0e0bdaad937b01638331f4
Comment 2 Alec Smecher 2013-12-02 12:30:02 PST
Delete notifications with entities
https://github.com/pkp/pkp-lib/commit/dbb988996aedf4ab048d83e20d99078baf304756
Comment 3 Alec Smecher 2013-12-11 07:29:06 PST
For MySQL users, you can clean up the DB with the following queries:

DELETE notifications FROM notifications LEFT JOIN review_rounds ON (notifications.assoc_id=review_rounds.review_round_id) WHERE notifications.assoc_type=523 AND review_rounds.review_round_id IS NULL;

DELETE notifications FROM notifications LEFT JOIN signoffs ON (notifications.assoc_id=signoffs.signoff_id) WHERE notifications.assoc_type=1048582 AND signoffs.signoff_id IS NULL;

This will solve most problems with perpetually-loading task lists for OMP 1.0.