Forum OpenACS Development: contacts from head, installation problem

Hi,

am following the thread on how to install the bleeding edge contacts version: https://openacs.org/forums/message-view?message_id=446800

With debug true, am getting this error during installation on a fresh db when following those directions:

[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Notice: dbinit: sql(localhost::head): '
      insert into lang_messages (locale, package_key, message_key, conflict_p, message, creation_user, upgrade_status, sync_time) 
      values ('en_US', 'acs-translations', 'rel_type_contact_rels_spouse_plural', 'f', 
        'MESSAGE KEY MISSING: 'contacts.lt_Contact_Rels_Spous''
    , '506', 'no_upgrade', null)
    '
[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Debug: db_exec: timing 3637 nsdb0 dml dbqd.acs-lang.tcl.lang-message-procs.lang::message::register.lang_message_insert
[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Notice: Querying '
select acs_rel_type__create_type (      
        'contact_rels_spouse',
        'MESSAGE KEY MISSING: 'acs-translations.rel_type_contact_rels_spouse'',
        'MESSAGE KEY MISSING: 'acs-translations.rel_type_contact_rels_spouse_plural'',
        'contact_rel',
        'contact_rel_employment',
        'rel_id',
        'contact_rels_spouse',
        'person',
        'spouse',
        '0',
        NULL,
        'person',
        'spouse',
        '0',
        NULL
);'
[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Error: Ns_PgExec: result status: 7 message: ERROR:  duplicate key violates unique constraint "acs_object_types_table_name_un"
CONTEXT:  PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "acs_rel_type__create_type" line 22 at perform

[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Error: dbinit: error(localhost::head,ERROR:  duplicate key violates unique constraint "acs_object_types_table_name_un"
CONTEXT:  PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "acs_rel_type__create_type" line 22 at perform
): '
select acs_rel_type__create_type (      
        'contact_rels_spouse',
        'MESSAGE KEY MISSING: 'acs-translations.rel_type_contact_rels_spouse'',
        'MESSAGE KEY MISSING: 'acs-translations.rel_type_contact_rels_spouse_plural'',
        'contact_rel',
        'contact_rel_employment',
        'rel_id',
        'contact_rels_spouse',
        'person',
        'spouse',
        '0',
        NULL,
        'person',
        'spouse',
        '0',
        NULL
);
'
[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Debug: db_exec: timing 12065 nsdb0 0or1row dbqd.acs-subsite.tcl.rel-types-procs.rel_types::new.create_type
[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_nextval.nextval_sequence --> using default SQL
[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Notice: Querying '
                select nextval('acs_object_id_seq') as nextval
                where (select relkind 
                       from pg_class 
                       where relname = 'acs_object_id_seq') = 'S';'
[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Notice: dbinit: sql(localhost::head): '
                select nextval('acs_object_id_seq') as nextval
                where (select relkind 
                       from pg_class 
                       where relname = 'acs_object_id_seq') = 'S'
            '

How to work around this?

Collapse
Posted by Iuri Sampaio on
Hi
I'm not expert of oacs. The people here wil correct if i'm wrong. My shot is:

It seems there is something, a table or a relation that you deleted it but it's still there. Check "lang_messages"
query "insert into lang_messages" right on the top.

Now that you are trying to reinstall it you get this trash code. is the first time you install contatct pkg??

[31/May/2006:23:30:39][6947.25182208][-conn:head::0] Error: Ns_PgExec: result status: 7 message: ERROR: duplicate key violates unique constraint "acs_object_types_table_name_un"
CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "acs_rel_type__create_type" line 22 at perform

Collapse
Posted by Torben Brosten on
Yes, this is the first time installing contacts package from head. Installing it on a fresh database. Haven't even changed any of the parameters after initial server startup.

My current theory is that this code recently introduced the problem, but it's just a guess at this point: http://cvs.openacs.org/cvs/openacs-4/packages/contacts/tcl/contacts-install-procs.tcl?r1=1.22&r2=1.21

Collapse
Posted by Malte Sussdorff on
Yeah, bummer. Apparently a copy/paste and not replace problem 😊.

Fixed (though utterly untested 😊).

Collapse
Posted by Iuri Sampaio on
well i also have a installation problem, please check it out.
http://www.openacs.org/forums/message-view?message%5fid=435246