Forum OpenACS Q&A: Error in reference data language

Collapse
Posted by Luis Garcia on
Hi,
I think that there is a bug in the  acs_reference__new function. At least when called from the installation of reference data language package. It reads the ref-language-create.sql file fine up until it reads the last part where it tries to register the table with the repository.
Can I register it "manually"? or any other way?
This is the error it fires:

Request Error

psql:ref-language-create.sql:38: WARNING:  COMMIT: no transaction in progress
psql:ref-language-create.sql:48: WARNING:  Error occurred while executing PL/pgSQL function acs_reference__new
psql:ref-language-create.sql:48: WARNING:  line 9 at return
psql:ref-language-create.sql:48: ERROR:  Function acs_reference__new("unknown", character varying, "unknown", "unknown", "unknown", character varying, character varying, timestamptz, "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown") does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts

    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..."

Collapse
Posted by Bart Teeuwisse on
Luis,

from the error message it appears that you are running OpenACS on PG 7.3.x. Unfortunately the reference packages haven't been ported to PG 7.3.x.

In order to patch the language package you would have to change acs_reference__new so that it accepts 'timestamptz' instead of 'timestamp' (without time zone).

However, be aware that other incompatabilities with PG 7.3.x might be lurking in this package and other none core packages.

/Bart

Collapse
Posted by Luis Garcia on
Hi Bart,
Yeap, I was afraid that I was not going to be able to get away with PG 7.3.X Every thing was going way too smooth :) ...until now. It got me :)

Thanks!