要約

Atlassian implemented an automatic labelling function to correct the pages affected by bug: CONFSERVER-55928 - Getting issue details... STATUS

Further details about the plugin created to implement this labelling can be found in suggestion:  CONFSERVER-63615 - Getting issue details... STATUS

However, some users experience that newly created pages also are labeled unintentionally with unrestored-unknown-attachment label. 

環境

Confluence is running on versions 7.4.9, 7.11.3, 7.12.1, 7.13.0 or later. 

原因

If a user creates a page as a copy of an existing page with the option "Include attached files and images" unchecked, the new page is missing the previous page attachments and it will be automatically labelled as "unrestored-unknown-attachment”.

ソリューション

To prevent this behaviour for new pages, disable the Reconcile unknown attachments plugin.

1. Browse to General Configuration > Manage Apps
2. Select System apps
3. Find Confluence Unknown Attachment Reconciliation Plugin and click on Disable
4. From now on, new pages should not be labeled as "unrestored-unknown-attachment” 

The already affected pages will have to be unlabelled manually. The following SQL can be used to identify the creator of the page, the last editor/modifier of that page along with the timestamp respectively which are labelled with unrestored-unknown-attachment label:

SELECT c.contentid, 
       c.title, 
       u.username  AS Creator, 
       c.creationdate, 
       c.lastmoddate, 
       um.username AS LastModifier from content c
JOIN user_mapping u ON c.creator = u.user_key 
JOIN user_mapping um ON c.lastmodifier = um.user_key 
where c.contentid in (select contentid from bodycontent where body like '%unrestored-unknown-attachment%') and prevver is null;