How to Find Attachments in Attachments Folder

症状

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

原因

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. As attachment is stored as this structure : <attachments>/pageID/attachment/attachmentVersion, you may want to run the following query to retrieve attachments of a page:

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

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

Additional Information