Forum OpenACS Q&A: Re: Problem with newest xowiki
xowiki is not supposed to work under oracle, (the documentation say it at the end http://media.wu-wien.ac.at/download/xowiki-doc/), but it might not be hopeless to get a resonable working version for it.
The error in your posting (the problem with "contains") comes from the test, checking whether db-tree is available (you could simply alter ::xowiki::has_ltree to return 0 in your installation, searching for a pendant for pg_proc makes no sense).
when has_ltree is 0, the new book-style won't work, but most of the other stuff will. it should be possible to find a way for this as well, but this requires more oracle know how than i have...
2 + 3 + 4 are consequences of the first problem.
This does not mean that everything will work after that: xowiki/xotcl-core query the database for the existance of tables, views and indices and creates this on demand. this must be ported. Then xotcl-core has low-level interfaces to the content repository. i am sure, they will need some work as well. For a good developer, who knows what she does, i would think this should be doable under one week (without looking into the details).
Well, and then, xowiki syndication depends on working search service-contracts, which fill the syndication table. Not sure, what the state of the intermedia drivers is...
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
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
The error message says "Query was not a DML or DDL command." which means, that
- you are using the postgres updates from openacs 5.3 to handle the deadlock problems (using stored procedures such as "xowiki_object_f" instead of the old postgres rewrite rules),
- but you are using the core of 5.2, in which case xotcl-core uses the db_dml operation. Correct?
As long you have this configuration, look into xotcl-core/tcl/generic-procs and search for the insert_view_operation. uncomment the following line:
#CrItem set insert_view_operation db_0or1row
This command will set the db-operation to the given value, no matter what your acs-core says.
Hope this helps!
You are right in all!
This works ok now.
I'll test it and I'll tell you my comments.
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?
This all being said, I got it installed on Oracle after I cut down the description tag of xowiki.info as Oracle was complaining about "long" parameters.
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.