Bug 8495 - Review round and signoff deletes don't clean corresponding notifications
Review round and signoff deletes don't clean corresponding notifications
Status: RESOLVED FIXED
Product: OMP
Classification: Unclassified
Component: General
1.1
All All
: P3 normal
Assigned To: PKP Support
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-12-02 12:01 PST by Alec Smecher
Modified: 2013-12-11 07:29 PST (History)
0 users

See Also:
Version Reported In:
Also Affects:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.