Forum OpenACS Q&A: Problem with newest xowiki

I just installed PostgreSQL 8.2.0, Aolserver 4.5.0, xotcl 1.5.3, OpenACS 5.2 (without dotLRN) with xotcl-core 0.46 and xowiki 0.43 on my SUSE 9.3.

All seems working well except a couple of errors during aolserver startup:

[01/Jan/2007:11:05:26][1474.1076447456][-main-] Error: Error sourcing /var/lib/aolserver/oacs52/packages/xowiki/tcl/xowiki-procs.tcl:
 during '::xotcl::__#3 contains'
    ::xotcl::__#3 ::xotcl::Object->configure
    ::xo::OrderedComposite ::xotcl::Class->create
    ::xo::OrderedComposite ::xotcl::Class->new
    invoked from within
"xo::OrderedComposite new -volatile -contains [my cr_attributes]"
    (procedure "init" line 8)
    ::xowiki::Page ::Generic::CrClass->init
    ::Generic::CrClass ::xotcl::Class->create
    invoked from within
"::Generic::CrClass create Page -superclass ::Generic::CrItem  -pretty_name "XoWiki Page" -pretty_plural "XoWiki Pages"  -table_name "xowiki_page" -id_..."
    (in namespace eval "::xowiki" script line 6)
    invoked from within
"namespace eval ::xowiki {

  #
  # create classes for different kind of pages
  #
  ::Generic::CrClass create Page -superclass ::Generic::CrItem \
   ..."
    (file "/var/lib/aolserver/oacs52/packages/xowiki/tcl/xowiki-procs.tcl" line 9)
    invoked from within
"source $__file "

[01/Jan/2007:11:05:26][1474.1076447456][-main-] Error: Error sourcing /var/lib/aolserver/oacs52/packages/xowiki/tcl/xowiki-www-procs.tcl:
invalid command name "File"
    while executing
"File instproc download {} {
    my instvar text mime_type package_id item_id revision_id
    $package_id set mime_type $mime_type
    set use_bg_deliv..."
    (in namespace eval "::xowiki" script line 274)
    invoked from within
"namespace eval ::xowiki {

  Page instproc view {} {
    # view is used only for the toplevel call, when the xowiki page is viewed
    # this is not..."
    (file "/var/lib/aolserver/oacs52/packages/xowiki/tcl/xowiki-www-procs.tcl" line 32)
    invoked from within
"source $__file "

invalid command name "::xowiki::Object"
    while executing
"::xowiki::Object create ::$folder_id"
    (procedure "require_folder_object" line 27)
    ::808 ::xowiki::Package->require_folder_object
    invoked from within
"my require_folder_object"
    (procedure "init" line 5)
    ::808 ::xowiki::Package->init
    ::xowiki::Package ::xotcl::Class->create

xowiki_objecti did not exists, but updating from CVS and executing ::xowiki::update_views didn't solve the problem.

I reinstalled from scratch, but the problem is not gone. The point is that the following query returns zero rows:

oacs52=# select object_type from acs_object_types 
      where object_type like '::xowiki::%' 
                      order by tree_sortkey;
oacs52-# oacs52-#  object_type 
-------------
(0 rows)

It seems, as if the ::Generic::CrClass create Page ... statement already fails in your install. try ::xo::db::has_ltree from ds/shell. This function is supposed to return 0, if ltree is not installed.

PS: the only problem in the fresh checkout was a missing variable declaration in the sql scripts of openacs-4/packages/acs-reference, which i fixed and committed to cvs. This has nothing to do with xowiki.

• PostgreSQL 7.4.13
• Aolserver 4.0.10
• xotcl 1.5.1
• base code from cvs oacs-5-2, with dotlrn
• xotcl-core 0.44
• xowiki 0.37

[05/Jan/2007:20:34:21][7077.1076464288][-main-] Error: Error sourcing /var/lib/aolserver/oacs52/packages/xowiki/tcl/xowiki-procs.tcl:
no such cache: xotcl_object_cache
    while executing
"error $errorMsg"
    (procedure "contains" line 15)
    ::xotcl::__#3 ::xo::OrderedComposite->contains
    ::xotcl::__#3 ::xotcl::Object->configure
    ::xo::OrderedComposite ::xotcl::Class->create
    ::xo::OrderedComposite ::xotcl::Class->new
    invoked from within
"xo::OrderedComposite new -volatile -contains [my cr_attributes]"
    (procedure "init" line 8)
    ::xowiki::Page ::Generic::CrClass->init
    ::Generic::CrClass ::xotcl::Class->create
    invoked from within
"::Generic::CrClass create Page -superclass ::Generic::CrItem  -pretty_name "XoWiki Page" -pretty_plural "XoWiki Pages"  -table_name "xowiki_page" -id_..."
    (in namespace eval "::xowiki" script line 6)
    invoked from within
"namespace eval ::xowiki {

  #
  # create classes for different kind of pages
  #
  ::Generic::CrClass create Page -superclass ::Generic::CrItem \
   ..."
    (file "/var/lib/aolserver/oacs52/packages/xowiki/tcl/xowiki-procs.tcl" line 9)
    invoked from within
"source $__file "

[05/Jan/2007:20:34:21][7077.1076464288][-main-] Error: Error sourcing /var/lib/aolserver/oacs52/packages/xowiki/tcl/xowiki-www-procs.tcl:
invalid command name "File"
    while executing
"File instproc download {} {
    my instvar text mime_type package_id item_id revision_id
    $package_id set mime_type $mime_type
    set use_bg_deliv..."
    (in namespace eval "::xowiki" script line 274)
    invoked from within
"namespace eval ::xowiki {

  Page instproc view {} {
    # view is used only for the toplevel call, when the xowiki page is viewed
    # this is not..."
    (file "/var/lib/aolserver/oacs52/packages/xowiki/tcl/xowiki-www-procs.tcl" line 32)
    invoked from within
"source $__file "

are you listining? This should fix your problem as well. your mailserver says about your email address "reason: 550 5.7.1 No such recipient)

The errors are as follows. I have applied the patches mentioned in the xotcl-core installation instructions as described at https://openacs.org/xowiki/xotcl-core (I actually copied the entire bootstrap file from HEAD, because only part of the patch worked). The versions of xotcl-core and xowiki were freshly checked out from HEAD this afternoon.

I don't want to spend too much time trying to track down errors if the real problem is that Oracle isn't supported... if that's the case then I have a different issue to address.

1. The table pg_proc does not exist and there doesn't seem to be any equivalent for Oracle

2. Not sure what is causing this, but Claudio was reporting it also:

[03/Jan/2007:17:35:15][12244.16384][-main-] Error: Error sourcing /var/lib/aolserver/dodss-dev/packages/xowiki/tcl/xowiki-procs.tcl:
during '::xotcl::__#3 contains'
::xotcl::__#3 ::xotcl::Object->configure
::xo::OrderedComposite ::xotcl::Class->create
::xo::OrderedComposite ::xotcl::Class->new
invoked from within
"::xo::OrderedComposite new -contains [my cr_attributes]"
(procedure "init" line 8)
::xowiki::Page ::Generic::CrClass->init
::Generic::CrClass ::xotcl::Class->create
invoked from within
"::Generic::CrClass create Page -superclass ::Generic::CrItem -pretty_name "XoWiki Page" -pretty_plural "XoWiki Pages" -table_name "xowiki_page" -id_..."

3. Another one Claudio also saw:

[03/Jan/2007:17:35:15][12244.16384][-main-] Error: Error sourcing /var/lib/aolserver/dodss-dev/packages/xowiki/tcl/xowiki-www-procs.tcl:
invalid command name "File"
while executing
"File instproc download {} {
my instvar text mime_type package_id item_id revision_id
$package_id set mime_type $mime_type
set use_bg_deliv..."

4. And then when I actually go to /xowiki:

invalid command name "::xowiki::Object"
while executing
"::xowiki::Object create ::$folder_id"
(procedure "require_folder_object" line 27)
::1820 ::xowiki::Package->require_folder_object

I am having problems trying the install of xowiki portlet in
oacs 5.2 with postgres 8.2 with ltree contrib installed.
I have read all forums threads but I can not rid off the
error.

Can you help me?

-----------------------------------------------------
Xowiki Portlet Administration
Error in include template "/var/lib/aolserver/oacs_5_2/packages/xowiki-portlet/www/xowiki-admin-portlet": Transaction aborted: Database operation "dml" failed (exception NSDB, "Query was not a DML or DDL command.") SQL: insert into xowiki_objecti (item_id,revision_id,creation_user,title,description,mime_type,nls_language,text,page_order,creator) values ('17923357','17923356','506','::17923355',NULL,'text/plain','en_US','# this is the payload of the folder object #set index_page "index" ',NULL,NULL)
-------------------------------------------------------
From postgres log:
insert into xowiki_objecti (item_id,revision_id,creation_user,title,description,mime_type,nls_language,text,page_order,creator) values ('17923013','17923012','506','::17922984',NULL,'text/plain','en_US','kkkk',NULL,NULL);
ERROR: null value in column "object_type" violates not-null constraint
CONTEXT: SQL statement "INSERT INTO acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )"
PL/pgSQL function "acs_object__new" line 40 at SQL statement
PL/pgSQL function "content_revision__new" line 33 at assignment
PL/pgSQL function "content_revision__new" line 15 at return
SQL statement "select content_revision__new( $1 , $2 , now(), $3 , $4 , case when $5 is null then $6 else $5 end, content_symlink__resolve( $7 ), $8 , now(), $9 , $10 , $11 )"
PL/pgSQL function "xowiki_object_f" line 5 at SQL statement

You are right in all!

This works ok now.
I'll test it and I'll tell you my comments.

Regards,
Agustín

I'm trying to install xowiki 0.52, all dependencies are met.

but during the installation this error comes up:

Notice: unknown called with map_sql_datatype text, ::xowiki::Page ::Generic::CrClass->unknown (5670ms)
Error: Ns_PgExec: result status: 7 message: ERROR: syntax error at or near "," at character 118

Error: Error sourcing /....../packages/xowiki/tcl/xowiki-procs.tcl:
Database operation "dml" failed (exception ERROR, "ERROR: syntax error at or near "," at character 118
")

ERROR: syntax error at or near "," at character 118

SQL: create table xowiki_references (reference integer references cr_items(item_id) on delete cascade,
link_type ,
page integer references cr_items(item_id) on delete cascade)
while executing
"ns_pg_bind dml nsdb0 {create table xowiki_references (reference integer references cr_items(item_id) on delete cascade,
link_type ,
..."
("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
"db_dml [my qn create-table-$name] "create table $name ($definition)""
(procedure "table" line 6)
::xo::db::require->table
invoked from within
"::xo::db::require table xowiki_references "reference integer references cr_items(item_id) on delete cascade,
link_type [::xowiki::Page map_..."
(in namespace eval "::xowiki" script line 42)
invoked from within
"namespace eval ::xowiki {

#
# create classes for different kind of pages
#
::Generic::CrClass create Page -superclass ::Generic::CrItem \
..."
(file "/...../packages/xowiki/tcl/xowiki-procs.tcl" line 9)
invoked from within
"source $__file "

Any help will be greatly appreciated.

(it looks more like an xotcl error, I'm using version 0.51)

required arg: 'package_id' missing
::xotcl::nonposArgs ::xotcl::NonposArgs->required
invoked from within
"::xotcl::nonposArgs required package_id"
invoked from within
"::xotcl::interpretNonpositionalArgs $args"
(procedure "new" line 2)
::xo::db::content_item->new
invoked from within
"::xo::db::content_item new -name $name -parent_id $parent_id -creation_user $creation_user -item_subtype "content_item" -content_type $object_type -..."
("eval" body line 1)
invoked from within
"eval ::xo::db::content_item new [[self class] set content_item__new_args]"
invoked from within
"set item_id [eval ::xo::db::content_item new [[self class] set content_item__new_args]]"
("uplevel" body line 14)
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
[self class] lock acs..."
(procedure "save_new" line 28)
invoked from within
"next"
(procedure "save_new" line 3)
::32066 ::Generic::CrCache::Item->save_new
invoked from within
"::$folder_id save_new"
(procedure "require_folder_object" line 34)
::32045 ::xowiki::Package->require_folder_object
invoked from within
"my require_folder_object"
(procedure "init" line 5)
::32045 ::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 "/home/cesar/miviaro/viaro_testing/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..."

is it a problem for you to upgrade that machine at least to 5.2? xotcl-core and xowiki have a few tests on the kernel version to behave differently in pre 5.2 versions. You can certainly grep for 5.2 in xotcl-core and xowiki to change this into 5.1.99 or whatever to address this problem.

Has anyone made progress with porting xowiki to oracle?
If not, I would like to do it because I want to use xowiki at UCLA.

I've installed xotcl-core and have a working openacs5.3.1 on oracle9i
and have checked out xowiki from HEAD

My first question is:
Where is: xowiki/xotcl-core??
There is no xotcl-core directory under the xowiki package and I don't see any xql files in the xowiki package. Can you point me to where the queries are?

Thanks much,
Avni 😊

you need to checkout two packages from cvs head,
xowiki and xotcl-core. If you have a recent dotlrn installation, move away the version of xotcl-core that you have already before getting the head versions

For you other questions, please wait a couple of days for the new release. We discussed with roc to update xotcl-core in the oacs-5-3 branch and put xowiki there as well to have a place for a "stable release", while the eager development continues in cvs head. More and more sites rely on xowiki. Depending on when they grab a version of xowiki the get a current snapshot of xowiki. While i am trying to keep thinks working, with about 15 commits per week, people get sometimes features and new behaviors, they don't expect, which makes as well communication and support harder than necessary.

There are two stable version in addition to the head version:
a) one in the branch oacs-5-3 (named 0.60.6)
b) one in the branch oacs-5-4 (named 0.106.1)
The head version is currently 0.109

Where did you get your version from?
Most likely, you have in your error.log an earlier error message which is the cause for the symptom that the method get_payload is not defined.