PKP Bugzilla – Bug 8495
Review round and signoff deletes don't clean corresponding notifications
Last modified: 2013-12-11 07:29:06 PST
Review round and signoff deletes don't clean corresponding notifications. This results in a broken Tasks grid.
Clean up during upgrade
Delete notifications with entities
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.