I noticed a problem while trying to upgrade my Openfire server from version 4.0.3 to 4.4.2.
After upgrading the software I couldn’t log into the admin account. Upon checking the logs I noticed there were SQL update errors. After that, my database version (table ofVersion) was on 24. While trying manually run the script numbered “25” I realized there was a mistake on the MS SQL script.
DROP INDEX IF EXISTS ofMucConvLog_msg_id ON ofMucConversationLog;
doesn’t seem to be valid on MS SQL.
I just removed the conditional, then the error changed from syntax error to not existent reference, then proceeded to run the rest of the scripts, so I could login all right.
I’m no SQL specialist and can’t suggest an improved correct syntax, sorry. I’m just reporting this issue so it can be fixed in future releases.
Thank you and have a nice day!