User Profile Details Are Not Visible
After upgrading to Confluence v3.0.x, cannot view content on user home pages, and there is a similar error on the network section in user profile:
Error occurred durng template rendering: Invocation of method 'renderConfluenceMacro' in class com.atlassian.confluence.themes.GlobalHelper threw exception org.springframework.transaction.UnexpectedRollbackException Transaction rolled back because it has been marked as rollback-only at /template/includes/personal-sidebar.vm[line 30, column 25]. Contact your administrator for assistance.
Logs contain errors like:
2009-07-21 11:38:13,081 ERROR [http-8082-2] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action -- referer: http://<Your Base URL>/display/<~Username>/Home | url: /users/viewfollow.action | userName: <Username> org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar ; nested exception is java.sql.SQLException: Invalid object name 'FOLLOW_CONNECTIONS'. Caused by: java.sql.SQLException: Invalid object name 'FOLLOW_CONNECTIONS'.
When upgrading to Confluence v3.0.x, the DB schema could not be updated successfully to add a new table
FOLLOW_CONNECTIONS, responsible for the above functionality and for the new social networking features introduced since v3.0.x.
This can be caused by an inappropriate upgrade, for which the SQL dump is restored after the upgrade job, as detailed in Upgrade Troubleshooting: