Suddenly three quarters of my chat rooms disappear. Not visible in admin console or Spark. Server was rebooted - problem stay the same.
I saw users had similar issues with prior versions of Openfire, but no one answer.
I have OF 3.7 running on server 2003, using MS SQL database.
When I look in dbo.ofMucRoom table, I see all the chat room listed there. There are nothing in serveraudit log (except the creation of the chat rooms and assigning admins) , nothing relevant in Error or Info logs
What can be done other than clear the table and rebuild to get chat rooms back? What can be done to prevent this from happening?
Right now the server is not used by users, but when it will dissapearing chatrooms will present a huge problem.
Thanks in advance