powered by Jive Software

Error in openfire_mysql.sql in 3.6.3

Hi,

I think I have found an bug in the file openfire_mysql.sql in Openfire Verison 3.6.3

It says:,

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,
nick VARCHAR(255),
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)

Hi,

Which version of MySQL do you have? I suspect it is an older one and you are hitting this bug:

http://www.igniterealtime.org/issues/browse/JM-1470

daryl

Well thanks a lot, this was the issue

(I had 5.0 and now I have 5.1)