How to Find Attachments in Attachments Folder

症状

Attachments are stored on filesystem but there isn't any attachment in the attachments folder.

診断

You can determine the missing attachments by using the Missing Attachments Report.

原因

The attachment naming scheme is numerical so as to avoid encoding problems with operating systems.

ソリューション

You can look for the attachment detail (e.g file type, attachment name) from ATTACHMENTS table.

Select * from ATTACHMENTS where pageID='<PageID>'

As attachment is stored as this structure:
Confluence 2.x:

<attachments>/pageID/attachment/attachmentVersion, you may want to run the following query to retrieve attachments of a page:

Confluence 3.x:
See Hierarchical File System Attachment Storage.