src/database/upgrade/14/openfire_mysql.sql
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.