I think I have found an bug in the file openfire_mysql.sql in Openfire Verison 3.6.3
CREATE TABLE ofRoster (
rosterID BIGINT NOT NULL,
username VARCHAR(64) NOT NULL,
jid VARCHAR(1024) NOT NULL,
sub TINYINT NOT NULL,
ask TINYINT NOT NULL,
recv TINYINT NOT NULL,
PRIMARY KEY (rosterID),
INDEX ofRoster_unameid_idx (username),
INDEX ofRoster_jid_idx (jid)
But mysql complains about this with "#1005 - Can’t create table ‘.\openfire\ofroster.frm’ (errno: 139) "
The bug seems to be in the INDEX commands, since if you remove the second, the command works.
Does someoneknow how to fix this (I think its intendes to have a conbination of both as index)
Best regards, Maddi
LocalMUCRoom.diff.zip (1840 Bytes)