Forum OpenACS Q&A: Re: Addressbook Request Error

Collapse
Posted by David Cotter on
Jon

Thanks for the reply. I installed Contacts Lite but got an error. I then installed all your other packages followed by Contacts Lite and the install went ok but nothing works (restarted server). I uninstalled Contacts Lite and reinstalled it but got the error below. I tried to uninstall the other pachages to start again but there were error in the uninstall procedure. I'll try this again. Is there any particular order I should install the packages?

Installing data model for Contacts Lite 0.2.1d...
Loading data model /home/david/web/openacs-4.6.2/packages/contacts-lite/sql/postgresql/contacts-lite-create.sql...
CREATE
CREATE
COMMENT
COMMENT
CREATE
DROP
COMMIT
COMMIT
HTTP/1.0 200 OK
Server: AOLserver/3.3.1+ad13
Content-Type: text/html; charset=iso-8859-1
MIME-Version: 1.0
Date: Tue, 13 May 2003 09:14:33 GMT
Content-Length: 4409
Connection: close

Request Error

    psql:contact-category-create.sql:17: ERROR:  Relation 'contact_categories' already exists
psql:contact-category-plsql-create.sql:18: ERROR:  Cannot insert a duplicate key into unique index acs_object_types_pk
psql:contacts-lite-create.sql:26: ERROR:  Relation 'contacts' already exists
psql:contacts-lite-create.sql:28: ERROR:  index named "contacts_category_ix" already exists
psql:contacts-lite-create.sql:29: ERROR:  index named "contacts_party_ix" already exists
psql:contacts-plsql.sql:22: ERROR:  Cannot insert a duplicate key into unique index acs_object_types_pk
psql:contacts-plsql.sql:60: ERROR:  parser: parse error at or near "t"
psql:contacts-plsql.sql:61: ERROR:  parser: parse error at or near "return"
psql:contacts-plsql.sql:70: ERROR:  parser: parse error at or near "'"
psql:contacts-plsql.sql:71: ERROR:  parser: parse error at or near "v_return"
psql:contacts-plsql.sql:75: ERROR:  parser: parse error at or near "delete"
psql:contacts-plsql.sql:78: ERROR:  Attribute 'p_contact_id' not found
psql:contacts-plsql.sql:80: ERROR:  parser: parse error at or near "raise"
psql:contacts-plsql.sql:82: ERROR:  parser: parse error at or near "perform"
psql:contacts-plsql.sql:84: ERROR:  parser: parse error at or near "return"
psql:contacts-plsql.sql:89: ERROR:  parser: parse error at or near "'"

    invoked from within
"db_source_sql_file -callback $callback $path/$file_path"
    (procedure "apm_package_install_data_model" line 32)
    invoked from within
"apm_package_install_data_model -callback $callback -data_model_files $data_model_files $spec_file_path"
    (procedure "apm_package_install" line 103)
    invoked from within
"apm_package_install  -enable=$enable_p  -install_path $install_path  -callback apm_ns_write_callback  -load_data_model  -data_model_files $data_model_..."
    ("foreach" body line 45)
    invoked from within
"foreach pkg_info $pkg_install_list {
    set spec_file [pkg_info_spec $pkg_info]