-
Bug
-
Resolution: Answered
-
Low
-
None
-
6.2.4, 6.3.4, 6.4.0
-
None
-
1
-
Severity 2 - Major
-
Summary
As per the Administering Collaborative Editing documentation, all existing shared drafts should be deleted upon disabling the Collaborative Editing feature.
All existing shared drafts are lost when you switch to this mode, so make sure your users have published any work they want to keep before you make the change.
How to Reproduce
- Enable Collaborative Editing.
- Create a shared draft by inserting some texts on the title and the content space.
- Quit editing by closing the browser tab or save the draft by clicking the 'Close' button at the bottom right of the editor and choose 'Keep Draft'.
- Disable and reenable Collaborative Editing.
Expected Behavior
Existing shared drafts should be deleted from the database.
Actual Behavior
Existing shared drafts remain in the database. The following SQL query returns result(s).
SELECT * FROM CONTENT WHERE CONTENTTYPE = 'PAGE' AND CONTENT_STATUS = 'draft';
Workaround
- Discard the drafts via Profile Picture > Drafts.
Reference: https://confluence.atlassian.com/doc/drafts-149040.html#Drafts-deleteDeleteadraft - Remove all drafts from the database using the following SQL query.
DELETE FROM CONTENT WHERE CONTENTTYPE = 'PAGE' AND CONTENT_STATUS = 'draft';
It is important that you backup your data before performing any modifications to the database. Please test any INSERT, UPDATE or DELETE queries on a staging environment prior to rolling out changes onto production environment.
- relates to
-
CONFSERVER-35921 Administrators should be able to see and delete drafts from all users
- Gathering Interest
[CONFSERVER-53589] Disabling Collaborative Editing feature does not remove existing shared drafts
We experience same issue in 6.4.2.
Also since this issue is resolved, in which version is it?
The documentation has been updated to reflect that users should publish any changes they want to keep, before turning Collaborative Editing off.
Although shared draft data does remain in the database, primarily for pages with unpublished changes where the user has exited the editor and selected "Keep draft", these are overwritten the next time the page is edited and published (with Collaborative Editing off), so there is still a risk that changes will be lost.
Please see Rachel's comment where we have updated the documentation to make it clearer that shared drafts are not automatically removed when collaborative editing is turned off. This would be undesirable toany customers as they would loose users work even if it were only turned off for a short time. This is a complex scenario to explain in detail as there is no perfect solution, as ultimately changing modes has a profound impact on the entire draft experience.