Wasn't sure this was worth a new thread:
I've been trying to upgrade XoWiki and have had an afternoon of no luck.
I'm running OpenACS 5.2.3b2 with XoTcl 1.4.0 and Postgresql 7.4.x. Starting from a brand new install, I grabbed the XoTcl Core 0.41 apm and the Xowiki 0.32 apm, installed them and get the following error when I go to /xowiki for the first time.
I nuked every thing and tried previous versions of xotcl-core and xowiki and got an error that looked like a mal-formed SQL statement when trying to create the package.
Any thoughts?
Thanks,
Matt
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_package_id_fk"
DETAIL: Key (package_id)=(0) is not present in table "apm_packages".
SQL: select content_item__new('::741',741,null,null,null,'506',null,null, 'content_item','::xowiki::Object',null,NULL,NULL, NULL,null,null,null,'f','text', 0)
while executing
"ns_pg_bind 0or1row nsdb0 { select content_item__new(:name,741,null,null,null,:creation_user,null,null, 'content_item',:object_type,null,:description,:..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "db_string" line 8)
invoked from within
"db_string insert_item " select content_item__new(:name,$parent_id,null,null,null,:creation_user,null,null, 'content_item',:object_type,null,:descripti..."
invoked from within
"set item_id [db_string insert_item " select content_item__new(:name,$parent_id,null,null,null,:creation_user,null,null, 'content_item',:object_type,nu..."
("uplevel" body line 5)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 1)
invoked from within
"db_transaction {
$__class instvar storage_type object_type
$__class folder_type -folder_id $parent_id register
db_dml lock_objects "..."
(procedure "save_new" line 23)
invoked from within
"next"
(procedure "save_new" line 3)
::741 ::Generic::CrCache::Item->save_new
invoked from within
"::$folder_id save_new"
(procedure "require_folder_object" line 34)
::734 ::xowiki::Package->require_folder_object
invoked from within
"my require_folder_object"
(procedure "init" line 7)
::734 ::xowiki::Package->init
::xowiki::Package ::xotcl::Class->create
invoked from within
"::xowiki::Package create ::$package_id -folder_id $folder_id"
invoked from within
"set Package [::xowiki::Package create ::$package_id -folder_id $folder_id]"
(file "/usr/local/www/bitdojo.org-dev/packages/xowiki/www/index.vuh" line 15)
invoked from within
"source [ad_conn file]"
(procedure "rp_handle_tcl_request" line 3)
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..."