wrong file:
/usr/share/openfire/resources/database/upgrade/14/openfire_mysql.sql
wrong syntax:
ALTER TABLE jiveRoster ALTER COLUMN jid jid varchar(1024) not null;
right syntax
ALTER TABLE jiveRoster CHANGE COLUMN jid jid varchar(1024) not null;
wrong file:
/usr/share/openfire/resources/database/upgrade/14/openfire_mysql.sql
wrong syntax:
ALTER TABLE jiveRoster ALTER COLUMN jid jid varchar(1024) not null;
right syntax
ALTER TABLE jiveRoster CHANGE COLUMN jid jid varchar(1024) not null;
This is a known issue that has been discussed in other threads. This should be fixed in the 3.5.1 update coming later this week.