Openfire 4.3.2 does not save the Offline Message Policy setting

Openfire
1

I set "server - server settings - offline messages - Offline Message Policy = Store or Drop.
Per-user offline message storage limit: 10,00 KB
Save Settings.
After restart openfire service I have:
"server - server settings - offline messages - Offline Message Policy = Store or Bounce.
Per-user offline message storage limit: 100,00 KB
Why?

2

The most probably reason for this is some kind of bug in Openfire, or a problem with your database (not storing data). Have you checked the log files? Maybe they contain a clue that can point you at the cause.

Openfire 4.3.2 is pretty old. It was released 4 and half years ago (to the day precise, I think). Do you have this problem with newer versions of Openfire too?

3

I need a working Broadcast plugin. its plugin did not work In openfire 4.7.4. So I am using Openfire 4.3.2

4

I have such message in log file at the “save settings” moment

2023.07.31 22:04:41 org.jivesoftware.util.JiveProperties - Invalid column name “encrypted”.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘encrypted’.

5

There is same problem in 4.7.5

6

I have just tried this on Openfire 4.7.5. After changing the “Offline Message Storage” configuration, saving that, stopping and starting Openfire, my configuration changes are shown, as expected.
image

2023.07.31 22:04:41 org.jivesoftware.util.JiveProperties - Invalid column name “encrypted”. com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘encrypted’.

This error in the logs might indicate that something did not go as planned when installing or updating the database schema. If that’s the case, then Openfire will warn about that during startup.