How To Manually Change Attachment Data Storage Location
症状
Preexisting attachments, in either the database or file system, have been set to use the opposite of what has been set for file storage. Changing the setting will delete the attachments table and effectively un-reference all attachments.
ソリューション
アトラシアン サポートの提供について
The following SQL query is outside the scope of Atlassian Support Offerings and is provided for general guidance only.
The resolution involves making changes directly to the database, please be sure to create a backup of your database before enacting any of the following steps.
次の SQL クエリを実行します。
SELECT bandanavalue FROM bandana WHERE bandanakey='atlassian.confluence.settings';
The case may need to be altered for the above statement to work
- Copy the returned bandanvalue entry into an editor of your choosing
- Edit the '<attachmentDataStore>' value to one of the following
For file system storage use <attachmentDataStore>file.system.based.attachments.storage</attachmentDataStore>
For database storage use <attachmentDataStore>database.based.attachments.storage</attachmentDataStore> 次の SQL クエリを実行します。
UPDATE bandana SET bandanavalue=<the newly edited value from step 3> WHERE bandanakey='atlassian.confluence.settings';
The case may need to be altered for the above statement to work