powered by Jive Software

Bug report: openfire_mysql.sql (upgrade/14)


doesn’t work under mysql 5.0

2008.04.02 13:23:59 org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:369) \ SchemaManager: Failed to execute SQL:
ALTER TABLE jiveRoster ALTER COLUMN jid jid varchar(1024) not null;
2008.04.02 13:23:59 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:266)

I changed to

ALTER TABLE jiveRoster CHANGE jid jid varchar(1024) not null;

and it works.


See also: