Prelude information

The state of a Confluence plugin is stored in the table bandana with the bandanakey plugin.manager.state.Map.

If a plugin is in the default state, its entry will not appear in the 'plugin.manager.state.Map'.

For example, atlassian-failure-cache-plugin is enabled by default; therefore, the entry state for atlassian-failure-cache-plugin does not appear in the 'plugin.manager.state.Map' unless it is disabled. The same applies for plugins that are disabled by default.

データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。

How to Change a Plugin Back to Its Default State

The following is the process for resetting a plugin back to its default state:

1. Confluence を終了します。
2. Backup your database in case you need to revert the changes.
3. Run the following query in your database:

   
   

    select BANDANAVALUE from BANDANA where BANDANAKEY = 'plugin.manager.state.Map';
   

4. 結果は次のようになります。

   
   

    <map>
     <entry>
       <string>com.atlassian.atlassian-failure-cache-plugin</string>
       <boolean>false</boolean>
     </entry>
     <entry>
       <string>confluence.extra.chart</string>
       <boolean>false</boolean>
     </entry>
   </map>

   
   

   

5. Use the following SQL query to delete all non-default plugin modifications:
   

   
   

   update BANDANA 
   set BANDANAVALUE='<map/>'
   where BANDANAKEY='plugin.manager.state.Map';

6. Clear Plugin Cache
7. Confluence を再起動します。