Database error while upgrading from 2.1.5 to 2.4.3

Openfire Openfire Support
1

Hi everyone,

I’'m trying to upgrade my 2.1.5 installation to 2.4.3 running on Oracle database.

I followed the instructions (copying jive-messenger.xml in the conf, directory, renaming it to wildfire.xml, etc…) but when I tried to start the server I got an error about the schema update of the database.

I tried to run the script manually on the database (2.1 from 2.2 script) and I got those errors :

ALTER TABLE mucRoom ADD useReservedNick INTEGER NOT NULL

ORA-01758: table must be empty to add mandatory (NOT NULL) column

ALTER TABLE mucRoom ADD canChangeNick INTEGER NOT NULL

ORA-01758: table must be empty to add mandatory (NOT NULL) column

ALTER TABLE mucRoom ADD canRegister INTEGER NOT NULL

ORA-01758: table must be empty to add mandatory (NOT NULL) column

UPDATE mucRoom set useReservedNick=0, canChangeNick=1, canRegister=1

ORA-00904: invalid column name

Can i still continue with the upgrade or I need to fix something before ?

Thanks !

2

Hi,

it fails to add these columns, I think they could be required so you’'d like to add them manually:

ALTER TABLE mucRoom ADD useReservedNick INTEGER NULL;

ALTER TABLE mucRoom ADD canChangeNick INTEGER NULL;

ALTER TABLE mucRoom ADD canRegister INTEGER NULL;

UPDATE mucRoom set useReservedNick=0, canChangeNick=1, canRegister=1;

ALTER TABLE mucRoom MODIFY useReservedNick INTEGER NOT NULL;

ALTER TABLE mucRoom MODIFY canChangeNick INTEGER NOT NULL;

ALTER TABLE mucRoom MODIFY canRegister INTEGER NOT NULL;

/code

LG

3

Thanks it’'s worked !

Maybe this fix should be include to the upgrade script in the next version?

4

Hey guys,

Thanks for the fix. It has been included for the next release.

Thanks,

– Gato