How to reset all Confluence plugins back to their default state through the database
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.
How to Change a Plugin Back to Its Default State
The following is the process for resetting a plugin back to its default state:
- Shutdown Confluence.
- Backup your database in case you need to revert the changes.
- Run the following query in your database:
select BANDANAVALUE from BANDANA where BANDANAKEY = 'plugin.manager.state.Map';
- The result should be something similar to this:
<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>
- Use the following SQL query to delete all non-default plugin modifications:
update BANDANA set BANDANAVALUE='<map/>' where BANDANAKEY='plugin.manager.state.Map';
- Clear Plugin Cache
- Confluence を再起動します。