Forum OpenACS Q&A: Response to New Survey Package imported into CVS

Collapse
Posted by Stan Kaufman on
Dave, I got this error during the install:

Installing data model for Survey 0.1d... 
              Loading data model /var/web/epimetrics-dev/packages/survey/sql/postgresql/survey-create.sql... 

                    CREATE
                     inline_0 
                    ----------
                            0
                    (1 row)
                    DROP
                    BEGIN
                    DROP
                     acs_privilege__add_child 
                    --------------------------
                                            0
                    (1 row)
                     acs_privilege__add_child 
                    --------------------------
                                            0
                    (1 row)
                     acs_privilege__add_child 
                    --------------------------
                                            0
                    (1 row)
                     acs_privilege__add_child 
                    --------------------------
                                            0
                    (1 row)
                     acs_privilege__add_child 
                    --------------------------
                                            0
                    (1 row)
                     acs_privilege__add_child 
                    --------------------------
                                            0
                    (1 row)
                     acs_privilege__add_child 
                    --------------------------
                                            0
                    (1 row)
                    CREATE
                     acs_privilege__add_child 
                    --------------------------
                                            0
                    (1 row)
                    COMMIT
                    CREATE
                     inline_1 
                    ----------
                            0
                    (1 row)
                    DROP
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    CREATE
                    HTTP/1.0 200 OK
                    Server: AOLserver/3.3.1+ad13
                    Content-Type: text/html; charset=iso-8859-1
                    MIME-Version: 1.0
                    Date: Mon, 16 Sep 2002 02:20:38 GMT
                    Content-Length: 3565
                    Connection: close







                    Request Error


                            
                           psql:survey-create.sql:258: ERROR:  Relation "survey_question_responses" does not exist
                           psql:survey-create.sql:259: ERROR:  Relation "survey_question_responses" does not exist
                           psql:survey-create.sql:260: ERROR:  Relation "survey_question_responses" does not exist
                           psql:survey-create.sql:276: ERROR:  Function 'survey_response__initial_respon(int4)' does not exist
                                   Unable to identify a function that satisfies the given argument types
                                   You may need to add explicit typecasts
                           psql:survey-create.sql:314: ERROR:  parser: parse error at or near "view"

                               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 (bquinn@arsdigita.com)
                               @creation-date Mon Oct  9 00:22:31..."
                               (procedure "code::tcl::/var/web/epimetrics-dev/packages/acs-admin/www/ap..." 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..."