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

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()?