How to Manually Change a Plugin Back to Default State Through the Database
The state of a Confluence plugin is stored in the
bandana table with the bandanakey plugin.manager.state.Map. If the 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:
- Identify the plugin key in Confluence Admin >> Manage Add On >> System. As you can see in the screenshot below, the plugin key is com.atlassian.atlassian-failure-cache-plugin.
- 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>
- Note the plugin key com.atlassian.atlassian-failure-cache-plugin in the result. Remove the "com.atlassian.atlassian-failure-cache-plugin" entry from the BANDANAVALUE to re-enable the plugin.
update BANDANA set BANDANAVALUE='<map> <entry> <string>confluence.extra.chart</string> <boolean>false</boolean> </entry> </map>' where BANDANAKEY='plugin.manager.state.Map';
- Clear Plugin Cache
- Restart Confluence