Problem Statement
After upgrading SQL for Confluence from beta version (10.0.0-SNAPSHOT) to the official 10.0.0 version, the SQL macro displays old UI instead of the new UI when viewed in edit mode.
Screenshot of SQL for Confluence and Table Library (SNAPSHOT) version
Screenshot of SQL macro viewed in SQL for Confluence version 10.0.0 which shows the old version
Environment
| Application | Confluence |
|---|---|
| Version | 6.9.1 |
| App | SQL for Confluence(Pro) |
| App Version | 10.0.0 |
| Database Type | N/A |
Cause
The SQL for Confluence app installs with Table Library app. When SQL for Confluence 10.0.0-SNAPSHOT is installed, Table Library 4.1.0-SNAPSHOT is also installed. When SQL for Confluence is upgraded from 10.0.0-SNAPSHOT to 10.0.0(latest), Table Library is not upgraded automatically and still shows 4.1.0-SNAPSHOT.
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, only enable SQL for Confluence and verify the behavior.
Screenshot of SQL for Confluence and Table Library (10.0.0) version
Screenshot of SQL macro viewed in SQL for Confluence version 10.0.0 which shows the new version
Ensure that the Table Library app version is compatible with the version of SQL for Confluence app.