Forum OpenACS Development: xowiki error after installing

Hi,

I'm using oacs-5-2 and installed xowiki and xotcl-core with no problems, but when I try to access the xowiki instance I get the error message at the end of the post.

I can't do a re-install because it's a production site. The xotcl-core and xowiki packages both installed with no problem. Besides, I have a testing site in the same machine with everything installed from scratch --oacs-5-2 and it works fine. I don't know what I'm doing wrong. My guess is that the code in the index.vuh file is not called/sourced/interpreted? correctly for some reason, because in the testing site when the index page is called for the first time, some pages(cr_items) are created. But that doesn't happen in the other case. Besides, all the tables and views are there (as I read in other posts that it was a common error when upgrading), and in the log file, when installing, I get the same messages that I get in the test site (where everything works ok). Finally, I also tried calling the procs ::xowiki::fix_all_package_ids and ::xo::db::has_ltree (which returns 0, the same that in the testing site)

Can anybody please help me? TIA!

Database operation "dml" failed (exception ERROR, "ERROR: insert or update on table «xowiki_object» violates foreign key «xowiki_object_xowiki_object_id_fkey»
DETAIL: The key (xowiki_object_id)=(228265) is not present in table xowiki_plain_page».
")

ERROR: insert or update on table «xowiki_object» violates foreign key «xowiki_object_xowiki_object_id_fkey»
DETAIL: The key (xowiki_object_id)=(228265) is not present in table «xowiki_plain_page».

SQL: insert into xowiki_objecti (item_id,revision_id,creation_user,title,description,mime_type,nls_language,text,creator) values ('228264','228265','80011','::228263',NULL,'text/plain','en_US','# this is the payload of the folder object

#set index_page "index"
',NULL)
while executing
"ns_pg_bind dml nsdb0 {insert into xowiki_objecti (item_id,revision_id,creation_user,title,description,mime_type,nls_language,text,creator) values (:i..."
("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 dml $db $full_statement_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
db_exec dml $db $full_statement_name $sql
}"
(procedure "db_dml" line 100)
invoked from within
"$insert_view_operation revision_add "insert into [$__class set table_name]i ([join $__atts ,]) values (:[join $__atts ,:])""
("uplevel" body line 12)
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 28)
invoked from within
"next"
(procedure "save_new" line 3)
::228263 ::Generic::CrCache::Item->save_new
invoked from within
"::$folder_id save_new"
(procedure "require_folder_object" line 34)
::228244 ::xowiki::Package->require_folder_object
invoked from within
"my require_folder_object"
(procedure "init" line 5)
::228244 ::xowiki::Package->init
::xowiki::Package ::xotcl::Class->create
invoked from within
"my create ::$package_id -url $url"
(procedure "require" line 8)
::xowiki::Package ::xo::PackageMgr->require
invoked from within
"my require -url $url $package_id"
(procedure "initialize" line 21)
::xowiki::Package ::xo::PackageMgr->initialize
invoked from within
"::xowiki::Package initialize -ad_doc {

This is the resolver for this package. It turns a request into
an object and executes the object with the ..."
(file "/usr/lib/aolserver4/dotlrn/packages/xowiki/www/index.vuh" line 2)
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..."

Collapse
Posted by Jose Pablo Escobedo Del Cid on
Thank you very much Gustaf!!! that was it! everything is working fine now =)