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