You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Due to https://jira.atlassian.com/browse/CONFSERVER-15964 we cannot purge a page as we get an error:
delete on table "content" violates foreign key constraint "fk594acc88c38fbea" on table "notifications" Detail: Key (contentid)=(182682701) is still referenced from table "notifications".
As we would like to not stop the database for something as small as this, would it be possible to delete that notification through a script? We do have scriptrunner for confluence.
DELETE FROM NOTIFICATIONS WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT WHERE (CONTENT_STATUS = 'deleted' AND SPACEID = <SPACEID>) OR PREVVER IN (SELECT CONTENTID FROM CONTENT WHERE CONTENT_STATUS = 'deleted' AND SPACEID = <SPACEID>));
It would replace the above query.