UI caching problem with SQL for Confluence
Problem statement
In some scenarios, after upgrading the SQL for Confluence app from the beta version (10.0.0-SNAPSHOT) to the official version (10.0.0), the SQL macro editor displays old UI instead of the new UI.
SQL for Confluence and Table Library - the SNAPSHOT version
SQL for Confluence - SQL Query macro editor version 10.0.0 displaying the old UI
Environment
| Application | Confluence |
|---|---|
| Version | 6.9.1 |
| App | SQL for Confluence(Pro) |
| App Version | 10.0.0 |
| Database Type | N/A |
Cause
When SQL for Confluence 10.0.0-SNAPSHOT is installed, Table Library 4.1.0-SNAPSHOT is also installed. When the Table Library is not upgraded automatically with an upgrade in SQL for Confluence from 10.0.0-SNAPSHOT to 10.0.0 (latest), the SQL macro editor still displays the older UI.
Solution
Uninstall SQL for Confluence 10.0.0, followed by uninstalling Table Library 4.1.0-SNAPSHOT. Now, re-install SQL for Confluence. This time the latest Table Library 4.1.0 gets installed and the issue shall be fixed.
- Check the folder <confluence-home directory>/plugins-cache to see if there are multiple jars for a given SQL for Confluence app and Table Library app. If yes, remove the unwanted versions.
- Check the app functionality.
- If the issue persists, uninstall and install SQL for Confluence.
- If SQL for Confluence does not work, enter Safe mode. That disables all the apps.
- Now, enable only SQL for Confluence and verify the behavior.
SQL for Confluence and Table Library - version 10.0.0
SQL for Confluence - SQL Query macro editor version 10.0.0 displaying the respective new UI
Ensure that the Table Library app version is compatible with the version of SQL for Confluence app.