The definition of the groups table in the oracle_setup.pl setup script
leaves out a column. It fails to create the "contract" field. near line 643
in the table definition for "groups" a line like:
contract INTEGER DEFAULT(0)";
needs to be inserted.
(this field is used by the AddGroup in the same script for example)
Thank you for bringing this to my attention. The oracle_setup.pl file is a
serious need of updating. I did the conversion of check_setup.pl (for Mysql) a
while back and then had to make a lot of changes to the database structure that
I have not had a chance to add them into the oracle_setup.pl script as of yet. I
will hopefully be finishing this up real soon now. Until then I recommend people
with database experience to use the .sql scripts located in the oracle sub
directory until then.
*** Bug 12835 has been marked as a duplicate of this bug. ***