Database migration script for oracle has wrong syntax in v22

today I downloaded and installed the 4.0.1 openfire rpm.

the database update failed because the Oracle migratiion script has wrong syntax (COLUMN keyword not valid for Oracle on alter table add column…).

because of the error

  • the logfiles grow to fast

  • login to admin console not possible

  • possibly XMPP does not workl at all (did not realy test that)

please fix

Filed as [OF-1079] Database migration script for oracle has wrong syntax in v22 - Jive Software Open Source