Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
7.4.8, 7.13.0, 7.13.2, 7.13.3
-
5
-
Severity 3 - Minor
-
1
-
Description
Issue Summary
Turning collaborative editing mode off and on again triggers a stale drafts auto cleanup but sometimes, there are stale drafts were not deleted successfully.
Steps to Reproduce
- turn collaborative mode off and on
- run query
SELECT d.contentid, d.title, d.prevver, d.lastmoddate, c.lastmoddate
FROM CONTENT d
JOIN CONTENT c
ON d.prevver = c.contentid
WHERE d.content_status = 'draft'
AND d.prevver IS NOT NULL
AND c.lastmoddate >= d.lastmoddate;
Expected Results
All stale draft pages should be deleted
Actual Results
There are old stale drafts remained in db