Forum OpenACS Q&A: Installing Task package failed

Collapse
Posted by Kulcsar Ferenc on
Hello All

On a fresh OpenACS 5.7 instance the Task package failed to install.

The configuration is:
Archlinux amd64
Tcl 8.5.10
XoTcl 1.6.6
Aolserver 4.5.1 CVS HEAD
Postgresql 8.4.8

The error message is (sorry it is long):

Database operation "0or1row" failed
(exception ERROR, "ERROR: insert or update on table "acs_attributes" violates foreign key constraint "acs_attributes_datatype_fk"
DETAIL: Key (datatype)=(money) is not present in table "acs_datatypes".
CONTEXT: SQL statement "insert into acs_attributes (attribute_id, object_type, table_name, column_name, attribute_name, pretty_name, pretty_plural, sort_order, datatype, default_value, min_n_values, max_n_values, storage, static_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 , $14 )"
PL/pgSQL function "acs_attribute__create_attribute" line 50 at SQL statement
PL/pgSQL function "content_type__create_attribute" line 30 at assignment
")

while executing
"ns_pg_bind 0or1row nsdb0 {

select content_type__create_attribute(:content_type,:attribute_name,:datatype,:pretty_name,:pretty_plural,:sort_order,:de..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
("uplevel" body line 8)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
# plsql calls that are simple selects bypass the plpgsql
# mechanism for creating anonymous fun..."
(procedure "db_exec_plsql" line 57)
invoked from within
"db_exec_plsql exec_func_plsql {}"
(procedure "package_exec_plsql" line 36)
invoked from within
"package_exec_plsql -var_list [list [list content_type $content_type ] [list attribute_name $attribute_name ] [list datatype $datatype ] [list pret..."
(procedure "content::type::attribute::new" line 14)
invoked from within
"content::type::attribute::new -content_type "contact_complaint" -attribute_name "turnover" -datatype "money" -pretty_name "Turnover" -sort_order ..."
(procedure "contacts::install::package_install" line 26)
invoked from within
"contacts::install::package_install "
("eval" body line 1)
invoked from within
"eval $command"
(procedure "apm_invoke_callback_proc" line 37)
invoked from within
"apm_invoke_callback_proc -version_id $version_id -type after-install"
(procedure "apm_package_install" line 155)
invoked from within
"apm_package_install -enable -package_path $package_path -load_data_model -data_model_files $data_model_files $spec_file"
("foreach" body line 52)
invoked from within
"foreach package_key $install {
ns_log Notice "Installing $package_key"

array unset version
array set version $repository($package_key..."
("uplevel" body line 49)
invoked from within
"uplevel {
ad_page_contract {
Install packages -- actual installation

@param install Tcl list of packages to install in the order in wh..."
(procedure "code::tcl::/var/lib/aolserver/service0/packages/acs-admin/ww..." line 2)
invoked from within
"code::tcl::$__adp_stub"
("uplevel" body line 12)
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"
invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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/$extra_url""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$extra_url"
set tcl_url2file([ad_conn url]) [ad_conn file]
set tcl_url2path..."

Any hint is very appreciated.

TIA
Feri