Forum OpenACS Q&A: ACS Events 0.2d error

Collapse
Posted by Luis Garcia on
Hi everyone. A few days ago I posted a note to see if somebody had any idea of what's going on with ACS Events 0.2d. It keeps firing this error. I did not get any reply; so, I'm posting it again.
Thanks in advance

Installing data model for ACS Events 0.2d...

Loading data model /home/lgarcia3/web/exchange/packages/acs-events/sql/postgresql/acs-events-create.sql...

CREATE FUNCTION
DROP FUNCTION
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
CREATE FUNCTION
DROP FUNCTION
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
HTTP/1.0 200 OK
Server: AOLserver/3.3.1+ad13
Content-Type: text/html; charset=iso-8859-1
MIME-Version: 1.0
Date: Sat, 01 Feb 2003 00:36:22 GMT
Content-Length: 13362
Connection: close

Request Error

psql:oracle-compat-create.sql:61: ERROR:  function dow_to_int already exists with same argument types
psql:oracle-compat-create.sql:90: ERROR:  Type "timespan" does not exist
psql:oracle-compat-create.sql:133: ERROR:  function next_day already exists with same argument types
psql:oracle-compat-create.sql:158: ERROR:  function add_months already exists with same argument types
psql:oracle-compat-create.sql:202: ERROR:  function last_day already exists with same argument types
psql:activity-create.sql:100: WARNING:  Error occurred while executing PL/pgSQL function acs_object_type__create_type
psql:activity-create.sql:100: WARNING:  line 37 at SQL statement
psql:activity-create.sql:100: ERROR:  Cannot insert a duplicate key into unique index acs_object_types_pk
psql:activity-create.sql:117: ERROR:  Relation 'acs_activities' already exists
psql:activity-create.sql:133: ERROR:  Relation 'acs_activity_object_map' already exists
psql:activity-create.sql:211: ERROR:  function acs_activity__new already exists with same argument types
psql:activity-create.sql:238: ERROR:  function acs_activity__delete already exists with same argument types
psql:activity-create.sql:265: ERROR:  function acs_activity__name already exists with same argument types
psql:activity-create.sql:305: ERROR:  function acs_activity__edit already exists with same argument types
psql:activity-create.sql:334: ERROR:  function acs_activity__object_map already exists with same argument types
psql:activity-create.sql:364: ERROR:  function acs_activity__object_unmap already exists with same argument types
psql:timespan-create.sql:10: ERROR:  Relation 'timespan_sequence' already exists
psql:timespan-create.sql:11: ERROR:  Relation 'timespan_seq' already exists
psql:timespan-create.sql:31: ERROR:  Relation 'time_intervals' already exists
psql:timespan-create.sql:80: ERROR:  function time_interval__new already exists with same argument types
psql:timespan-create.sql:105: ERROR:  function time_interval__delete already exists with same argument types
psql:timespan-create.sql:161: ERROR:  function time_interval__edit already exists with same argument types
psql:timespan-create.sql:196: ERROR:  function time_interval__shift already exists with same argument types
psql:timespan-create.sql:234: ERROR:  function time_interval__shift already exists with same argument types
psql:timespan-create.sql:278: ERROR:  function time_interval__overlaps_p already exists with same argument types
psql:timespan-create.sql:318: ERROR:  function time_interval__overlaps_p already exists with same argument types
psql:timespan-create.sql:399: ERROR:  function time_interval__overlaps_p already exists with same argument types
psql:timespan-create.sql:439: ERROR:  function time_interval__eq already exists with same argument types
psql:timespan-create.sql:491: ERROR:  function time_interval__copy already exists with same argument types
psql:timespan-create.sql:516: ERROR:  function time_interval__copy already exists with same argument types
psql:timespan-create.sql:545: ERROR:  function time_interval__copy already exists with same argument types
psql:timespan-create.sql:562: ERROR:  Relation 'timespans' already exists
psql:timespan-create.sql:564: ERROR:  relation named "timespans_idx" already exists
psql:timespan-create.sql:569: ERROR:  relation named "timespans_interval_id_idx" already exists
psql:timespan-create.sql:652: ERROR:  function timespan__new already exists with same argument types
psql:timespan-create.sql:681: ERROR:  function timespan__new already exists with same argument types
psql:timespan-create.sql:711: ERROR:  function timespan__new already exists with same argument types
psql:timespan-create.sql:739: ERROR:  function timespan__delete already exists with same argument types
psql:timespan-create.sql:785: ERROR:  function timespan__join_interval already exists with same argument types
psql:timespan-create.sql:822: ERROR:  function timespan__join already exists with same argument types
psql:timespan-create.sql:868: ERROR:  function timespan__join already exists with same argument types
psql:timespan-create.sql:897: ERROR:  function timespan__interval_delete already exists with same argument types
psql:timespan-create.sql:933: ERROR:  function timespan__exists_p already exists with same argument types
psql:timespan-create.sql:966: ERROR:  function timespan__multi_interval_p already exists with same argument types
psql:timespan-create.sql:1001: ERROR:  function timespan__overlaps_interval_p already exists with same argument types
psql:timespan-create.sql:1043: ERROR:  function timespan__overlaps_p already exists with same argument types
psql:timespan-create.sql:1090: ERROR:  function timespan__overlaps_p already exists with same argument types
psql:timespan-create.sql:1145: ERROR:  function timespan__copy already exists with same argument types
psql:timespan-create.sql:1169: ERROR:  function timespan__copy already exists with same argument types
psql:timespan-create.sql:1197: ERROR:  function timespan__copy already exists with same argument types
psql:recurrence-create.sql:10: ERROR:  Relation 'recurrence_sequence' already exists
psql:recurrence-create.sql:11: ERROR:  Relation 'recurrence_seq' already exists
psql:recurrence-create.sql:21: ERROR:  Relation 'recurrence_interval_types' already exists
psql:recurrence-create.sql:24: ERROR:  Cannot insert a duplicate key into unique index recurrence_interval_type_pk
psql:recurrence-create.sql:25: ERROR:  Cannot insert a duplicate key into unique index recurrence_interval_type_pk
psql:recurrence-create.sql:26: ERROR:  Cannot insert a duplicate key into unique index recurrence_interval_type_pk
psql:recurrence-create.sql:27: ERROR:  Cannot insert a duplicate key into unique index recurrence_interval_type_pk
psql:recurrence-create.sql:28: ERROR:  Cannot insert a duplicate key into unique index recurrence_interval_type_pk
psql:recurrence-create.sql:29: ERROR:  Cannot insert a duplicate key into unique index recurrence_interval_type_pk
psql:recurrence-create.sql:30: ERROR:  Cannot insert a duplicate key into unique index recurrence_interval_type_pk
psql:recurrence-create.sql:84: ERROR:  Relation 'recurrences' already exists
psql:recurrence-create.sql:88: ERROR:  relation named "recurrences_interval_type_idx" already exists
psql:recurrence-create.sql:181: ERROR:  function recurrence__new already exists with same argument types
psql:recurrence-create.sql:208: ERROR:  function recurrence__delete already exists with same argument types
psql:acs-events-create.sql:15: ERROR:  Relation 'acs_events_sequence' already exists
psql:acs-events-create.sql:16: ERROR:  Relation 'acs_events_seq' already exists
psql:acs-events-create.sql:195: WARNING:  Error occurred while executing PL/pgSQL function acs_object_type__create_type
psql:acs-events-create.sql:195: WARNING:  line 37 at SQL statement
psql:acs-events-create.sql:195: ERROR:  Cannot insert a duplicate key into unique index acs_object_types_pk
psql:acs-events-create.sql:254: ERROR:  Relation 'acs_events' already exists
psql:acs-events-create.sql:260: ERROR:  relation named "acs_events_activity_id_ids" already exists
psql:acs-events-create.sql:263: ERROR:  relation named "acs_events_recurrence_id_idx" already exists
psql:acs-events-create.sql:307: ERROR:  Relation 'acs_event_party_map' already exists
psql:acs-events-create.sql:324: ERROR:  Relation 'acs_events_dates' already exists
psql:acs-events-create.sql:345: ERROR:  Relation 'acs_events_activities' already exists
psql:acs-events-create.sql:369: ERROR:  Relation 'partially_populated_event_ids' already exists
psql:acs-events-create.sql:384: ERROR:  Relation 'partially_populated_events' already exists
psql:acs-events-create.sql:493: ERROR:  function acs_event__new already exists with same argument types
psql:acs-events-create.sql:529: ERROR:  function acs_event__delete already exists with same argument types
psql:acs-events-create.sql:561: ERROR:  function acs_event__delete_all_recurrences already exists with same argument types
psql:acs-events-create.sql:592: ERROR:  function acs_event__delete_all already exists with same argument types
psql:acs-events-create.sql:623: ERROR:  function acs_event__get_name already exists with same argument types
psql:acs-events-create.sql:654: ERROR:  function acs_event__get_description already exists with same argument types
psql:acs-events-create.sql:683: ERROR:  function acs_event__get_html_p already exists with same argument types
psql:acs-events-create.sql:711: ERROR:  function acs_event__get_status_summary already exists with same argument types
psql:acs-events-create.sql:739: ERROR:  function acs_event__timespan_set already exists with same argument types
psql:acs-events-create.sql:783: ERROR:  function acs_event__recurrence_timespan_edit already exists with same argument types
psql:acs-events-create.sql:810: ERROR:  function acs_event__activity_set already exists with same argument types
psql:acs-events-create.sql:839: ERROR:  function acs_event__party_map already exists with same argument types
psql:acs-events-create.sql:867: ERROR:  function acs_event__party_unmap already exists with same argument types
psql:acs-events-create.sql:896: ERROR:  function acs_event__recurs_p already exists with same argument types
psql:acs-events-create.sql:929: ERROR:  function acs_event__instances_exist_p already exists with same argument types
psql:acs-events-create.sql:961: ERROR:  function acs_event__get_value already exists with same argument types
psql:acs-events-create.sql:1023: ERROR:  function acs_event__new_instance already exists with same argument types
psql:acs-events-create.sql:1263: ERROR:  function acs_event__insert_instances already exists with same argument types
psql:acs-events-create.sql:1317: ERROR:  function acs_event__shift already exists with same argument types
psql:acs-events-create.sql:1355: ERROR:  function acs_event__shift already exists with same argument types
psql:acs-events-create.sql:1414: ERROR:  function acs_event__shift_all already exists with same argument types
psql:acs-events-create.sql:1455: ERROR:  function acs_event__shift_all already exists with same argument types

    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 19)
    invoked from within
"apm_package_install -install_path $install_path  -callback apm_ns_write_callback -load_data_model  -data_model_files $data_model_files $spec_file"
    ("foreach" body line 36)
    invoked from within
"foreach pkg_info $pkg_install_list {
    set spec_file [pkg_info_spec $pkg_info]
    if { [catch {
        array set version [apm_read_package_info_file $spe..."
    ("uplevel" body line 34)
    invoked from within
"uplevel {
          ad_page_contract {

    Installs the packages.

    @author Bryan Quinn (mailto:bquinn@arsdigita.com)
    @creation-date Mon Oct  9 00:22:31..."
    (procedure "code::tcl::/home/lgarcia3/web/exchange/packages/acs-admin/ww..." line 2)
    invoked from within
"code::tcl::$__adp_stub"
    invoked from within
"if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init tcl $__adp_stub
..."
    ("uplevel" body line 3)
    invoked from within
"uplevel {

    if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init t..."
    (procedure "adp_prepare" line 2)
    invoked from within
"adp_prepare "
    (procedure "template::adp_parse" line 30)
    invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
    (procedure "adp_parse_ad_conn_file" line 7)
    invoked from within
"$handler"
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
        $handler
      } ad_script_abort val {
        # do nothing
      }"
    invoked from within
"rp_serve_concrete_file [ad_conn file]"
    (procedure "rp_serve_abstract_file" line 60)
    invoked from within
"rp_serve_abstract_file "$root/$path""
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
        rp_serve_abstract_file "$root/$path"
        set tcl_url2file([ad_conn url]) [ad_conn file]
        set tcl_url2path_info([ad_conn url]) [ad_conn path_inf...