Forum OpenACS Development: Re: Best version of xowiki and xotcl to download!?

Collapse
Posted by Matthew Coupe on
This is where I'm coming from:
xoWiki 0.47
xotcl-request monitor 0.38
XoTcl-core 0.47
ACS-Kernel 5.2.3

Installation Errors
Error 1:

Error: Ns_PgExec: result status: 7 message: ERROR: adding columns with defaults is not implem
ented
HINT: Add the column, then use ALTER TABLE SET DEFAULT.
CONTEXT: PL/pgSQL function "content_type__create_attribute" line 31 at execute statement

[18/Oct/2007:12:05:13][5630.3065895856][-conn:nccedudotlrn::0] Error: Error sourcing /var/lib/aolserver/nccedudotlrn/packages/xowiki/tcl/xowiki-procs.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR: adding columns with defaults is not implemented
HINT: Add the column, then use ALTER TABLE SET DEFAULT.
CONTEXT: PL/pgSQL function "content_type__create_attribute" line 31 at execute statement

SQL:
select content_type__create_attribute('::xowiki::PageTemplate', 'anon_instances', 'boolean', '#xowiki.PageTemplate-anon_instances#', null, null, null,
'boolean default ''f''')

while executing
"ns_pg_bind 0or1row $db $sql"
invoked from within
"ns_set value [ns_pg_bind 0or1row $db $sql] 0 "
invoked from within
"return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
#my log "sql=$sql, sql_command=ns_set value [ns_pg_bind 0or1row $db $sql] 0"
return [ ns_set value [ns_p..."
(procedure "create_attribute" line 17)
::xo::db::sql::content_type->create_attribute
invoked from within
"::xo::db::sql::content_type create_attribute -content_type $object_type -attribute_name $attribute_name -datatype $datatype -pretty_name $pretty_n..."
(procedure "create_attributes" line 26)
::xowiki::PageTemplate ::Generic::CrClass->create_attributes
invoked from within
"my create_attributes"
("uplevel" body line 2)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 39)
invoked from within
"db_transaction {
my create_attributes
}"
(procedure "init" line 39)
::xowiki::PageTemplate ::Generic::CrClass->init
::Generic::CrClass ::xotcl::Class->recreate
::Generic::CrClass ::xotcl::Class->create
invoked from within
"::Generic::CrClass create PageTemplate -superclass Page -pretty_name "XoWiki Page Template" -pretty_plural "XoWiki Page Templates" -table_name "xowi..."
(in namespace eval "::xowiki" script line 81)
invoked from within
"namespace eval ::xowiki {
#
# create classes for different kind of pages
#
::Generic::CrClass create Page -superclass ::Generic::CrItem \
..."
(file "/var/lib/aolserver/nccedudotlrn/packages/xowiki/tcl/xowiki-procs.tcl" line 9)
invoked from within
"source $__file "

Error 2
Error: Error sourcing /var/lib/aolserver/nccedudotlrn/packages/xowiki/tcl/xowiki-www-procs.tcl
:
invalid command name "FormPage"
while executing
"FormPage instproc create_category_fields {} {
set category_spec [my get_short_spec @categories]
foreach f [split $category_spec ,] {
if ..."
(in namespace eval "::xowiki" script line 3)
invoked from within
"namespace eval ::xowiki {

FormPage instproc create_category_fields {} {
set category_spec [my get_short_spec @categories]
foreach f [split ..."
(file "/var/lib/aolserver/nccedudotlrn/packages/xowiki/tcl/xowiki-www-procs.tcl" line 397)
invoked from within
"source $__file "

Error 3
Error: Ns_PgExec: result status: 7 message: ERROR: function content_type__drop_type("unknown"
, "unknown", "unknown", "unknown") does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.

[18/Oct/2007:12:05:33][5630.3065895856][-conn:nccedudotlrn::0] Notice: --upgrade produced error: Database operation "0or1row" failed (exception NSDB, "Query
was not a statement returning rows.")

ERROR: function content_type__drop_type("unknown", "unknown", "unknown", "unknown") does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.

SQL:
select content_type__drop_type('::xowiki::FormInstance', 't', 't', 't')

Error 4
Error: GET http://10.10.1.34:8000/acs-admin/apm/packages-install-4?
referred by "http://10.10.1.34:8000/acs-admin/apm/packages-install";
::xotcl::__#1m: unable to dispatch method 'set_content'
while executing
"$page set_content [string trim [$page text] " \n"]"
(procedure "import_prototype_page" line 29)
::2475908 ::xowiki::Package->import_prototype_page
invoked from within
"$package_id import_prototype_page weblog-portlet"
(procedure "::xowiki::upgrade_callback" line 223)
invoked from within
"::xowiki::upgrade_callback -from_version_name 0.47 -to_version_name 0.60.1"
("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-upgrade -arg_list [list from_version_name $upgrade_from_version_name to_version_name $ver..."
(procedure "apm_package_install" line 191)
invoked from within
"apm_package_install -enable=$enable_p -package_path $package_path -callback apm_ns_write_callback -load_data_model -data_model_files $data_model_..."
("foreach" body line 42)
invoked from within
"foreach pkg_info $pkg_install_list {
set spec_file [pkg_info_spec $pkg_info]
set package_path [pkg_info_path $pkg_info]

if { [catch {
ar..."
("uplevel" body line 34)
invoked from within
"uplevel {
ad_page_contract {

Installs the packages.

@author Bryan Quinn (mailto:bquinn@arsdigita.com)
@creation-date Mon Oct 9 00:22:31 2000
..."
(procedure "code::tcl::/var/lib/aolserver/nccedudotlrn/packages/acs-admi..." line 2)
invoked from within
"code::tcl::$__adp_stub"
invoked from within
"if { [file exists $__adp_stub.tcl] } {

# ensure that data source preparation procedure exists and is up-to-date
adp_init tcl $__adp_stub
..."
("uplevel" body line 3)
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 "
(procedure "template::adp_parse" line 30)
invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
(procedure "adp_parse_ad_conn_file" line 5)
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..."

Errors on subsequent start-up
Error: Ns_PgExec: result status: 7 message: ERROR: adding columns with defaults is not implemented
HINT: Add the column, then use ALTER TABLE SET DEFAULT.
CONTEXT: PL/pgSQL function "content_type__create_attribute" line 31 at execute statement

[18/Oct/2007:12:12:59][23716.3086944480][-main-] Error: Error sourcing /var/lib/aolserver/nccedudotlrn/packages/xowiki/tcl/xowiki-procs.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR: adding columns with defaults is not implemented
HINT: Add the column, then use ALTER TABLE SET DEFAULT.
CONTEXT: PL/pgSQL function "content_type__create_attribute" line 31 at execute statement

SQL:
select content_type__create_attribute('::xowiki::PageTemplate', 'anon_instances', 'boolean', '#xowiki.PageTemplate-anon_instances#', null, null, null,
'boolean default ''f''')

while executing
"ns_pg_bind 0or1row $db $sql"
invoked from within
"ns_set value [ns_pg_bind 0or1row $db $sql] 0 "
invoked from within
"return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
#my log "sql=$sql, sql_command=ns_set value [ns_pg_bind 0or1row $db $sql] 0"
return [ ns_set value [ns_p..."
(procedure "create_attribute" line 17)
::xo::db::sql::content_type->create_attribute
invoked from within
"::xo::db::sql::content_type create_attribute -content_type $object_type -attribute_name $attribute_name -datatype $datatype -pretty_name $pretty_n..."
(procedure "create_attributes" line 26)
::xowiki::PageTemplate ::Generic::CrClass->create_attributes
invoked from within
"my create_attributes"
("uplevel" body line 2)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 1)
invoked from within
"db_transaction {
my create_attributes
}"
(procedure "init" line 39)
::xowiki::PageTemplate ::Generic::CrClass->init
::Generic::CrClass ::xotcl::Class->create
invoked from within
"::Generic::CrClass create PageTemplate -superclass Page -pretty_name "XoWiki Page Template" -pretty_plural "XoWiki Page Templates" -table_name "xowi..."
(in namespace eval "::xowiki" script line 81)
invoked from within
"namespace eval ::xowiki {
#
# create classes for different kind of pages
#
::Generic::CrClass create Page -superclass ::Generic::CrItem \
..."
(file "/var/lib/aolserver/nccedudotlrn/packages/xowiki/tcl/xowiki-procs.tcl" line 9)
invoked from within
"source $__file "

Another one
invalid command name "PageInstance"
while executing
"PageInstance instproc create_form_field {
-name
{-slot ""}
{-spec ""}
{-configuration ""}
} {
set short_spec [my get_short_spe..."
(in namespace eval "::xowiki" script line 137)
invoked from within
"namespace eval ::xowiki {

Page instproc edit {
{-new:boolean false}
{-autoname:boolean false}
{-validaton_errors ""}
} {
my inst..."
(file "/var/lib/aolserver/nccedudotlrn/packages/xowiki/tcl/xowiki-www-procs.tcl" line 224)
invoked from within
"source $__file "

Collapse
Posted by Gustaf Neumann on
Error 1 and error 3 are most likely the culprits, the others are consequences of these problems.

How comes, that you don't have the following psql functions?

content_type__create_attribute()  -- 8 args
content_type__drop_type()  -- 4 args
You should see the following output in Postgres
# \df content_type__create_attribute
                                                                                             List of functions
 Schema |              Name              | Result data type |                                                             Argument data types
--------+--------------------------------+------------------+----------------------------------------------------------------------------------------------------------------------------------------------
 public | content_type__create_attribute | integer          | character varying, character varying, character varying, character varying, character varying, integer, character varying, character varying
(1 row)

# \df content_type__drop_type List of functions Schema | Name | Result data type | Argument data types --------+-------------------------+------------------+---------------------------------------------- public | content_type__drop_type | integer | character varying, boolean, boolean public | content_type__drop_type | integer | character varying, boolean, boolean, boolean (2 rows)

The problem with content_type__drop_type() looks easier to track. The SQL function was added by malte in july last year and is part of content-type.sql in oacs-5-3, and is included in the update scripts acs-content-repository/sql/postgresql/upgrade/upgrade-5.3.0d2-5.3.0d3.sql

Can it be, that these update scrips were not executed in your installation? I tend to believe that you have only the
content_type__drop_type with three arguments. Is this true? What is the your situation with content_type__create_attribute()?