I’m new openfire user. We are still configuring our system, adding new user, group, etc.
Currently I’m facing a problem when adding a Group Chat Room. I was successfully adding several rooms (62 rooms) using admin console and the room was listed in the room summary. But suddenly this morning almost all rooms are missing when I tried to view it using admin console. I only saw 1 room !
I can see the rooms in ofMucRoom table, but I cannot see it from the admin console. Can someone help me on this? Anyone know what query is used in muc-room-summary.jsp file? Maybe if I know the query, I can fix it at database level.
FYI, I’m using Openfire 3.6.0a and MS SQL Server
Thanks in advance