We are upgrading openfire from 4.1.6 to openfire 4.8.1 version. Post installation of the new version the property values are not getting updated in DB. We are getting the below error in the openfire.log:
[1;31mERRORe[m [Jetty-QTP-AdminConsole-32]: org.jivesoftware.util.JiveProperties - Invalid column name ‘encrypted’.
java.sql.SQLException: Invalid column name ‘encrypted’.
When starting up, Openfire checks for the presence of database update scripts, and tries to run them. The column that appears to be missing in your server is added by script number 26. This suggests that this script - and most likely all scripts after it, have not executed. This can cause all kind of issues.
My advice is to evaluate the database table called ofVersion. This will hold the number of the update script that was last executed for Openfire. Try to determine what update script was the first to fail, and correct for that manually.
When Openfire starts up, it will likely also log errors when it tries to run the update scripts. These errors might provide clues as to what’s going wrong.
Thanks, Guus for promptly responding to our query. This was very helpful in resolving the reported issue.