Hi,
When updating to Openfire version 4.7.4 with Oracle DB, the migration script fails with:
CREATE INDEX ofMucConversationLog_roomtime_idx ON ofMucConversationLog (roomID, logTime);
-- SQL Command: CREATE INDEX ofMucConversationLog_roomtime_idx ON ofMucConversationLog (roomID, logTime)
-- SQL Error Code: 972
-- SQL Error Message: ORA-00972: identifier is too long
The too long index name is used in resources/database/openfire_oracle.sql and resources/database/upgrade/34/openfire_oracle.sql.
Best regards,
Michael