Hi!
Recently I made upgrade all used plugins.
Monitoring to 1.4 and get stop archiving due to duplicating of key:
org.jivesoftware.openfire.archive.Conversation - Unique constraint violation: SYS_IDX_78 in statement [INSERT INTO ofConversation(conversationID, room, isExternal, startDate, lastActivity, messageCount) VALUES (?,?,?,?,?,0)]
java.sql.SQLException: Unique constraint violation: SYS_IDX_78 in statement [INSERT INTO ofConversation(conversationID, room, isExternal, startDate, lastActivity, messageCount) VALUES (?,?,?,?,?,0)]
openfile 3.9.1
HSQL Database Engine 1.8.0
Obviously, conversationID calculated wrong. How can I correct this?