Don,
I got an error now when installing acs_messaging:
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Aug 16 13:24:51 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
begin
*
ERROR at line 1:
ORA-00001: unique constraint (OPENACS.ACS_OBJECT_TYPES_TABLE_NAME_UN) violated
ORA-06512: at "OPENACS.ACS_OBJECT_TYPE", line 28
ORA-06512: at line 13
No errors.
No errors.
No errors.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
The SQL involved is (oracle/acs-messaging-create.sql):
acs_object_type.create_type (
supertype => 'content_revision',
object_type => 'acs_message_revision',
pretty_name => 'Message Revision',
pretty_plural => 'Message Revisions',
table_name => 'cr_revisions',
id_column => 'revision_id',
name_method => 'acs_object.default_name'
);
I will drop the unique constraint on acs_object_types.table_name on my local installation to be able to install and run the tests.