Forum OpenACS Development: Solved: XoWiki: missing arg: create_column_p: OpenACS 5.7 Upgrade Error

Request notifications

Hi,

Just to report a solution to a strange issue:
I've updated a server from OpenACS 5.1 to OpenACS 5.7 and later installed XoWiki. During boot time I got an error message about a "missing arg" in a call like this:

acs_attribute create_attribute

After some poking around I found that there were three versions of the PL/SQL call acs_attribute__create_attribute in the DB, which I deleted. I then ran psql -f acs-metadata-create.sql again, and now everything is OK.

So apparently the upgrade process from OpenACS 5.1 -> 5.7 doesn't work correctly and leaves the wrong signatures in the DB (see below).

Cheers,
Frank

po40demo=# \df acs_object_type__create_type
List of functions
Schema | Name | Result data type | Argument data types
| Type
--------+------------------------------+------------------+-----------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------+--------
public | acs_object_type__create_type | integer | character varying, character varying, character varying, character varying, character varying, character varying, character varying, boo
lean, character varying, character varying | normal
public | acs_object_type__create_type | integer | character varying, character varying, character varying, character varying, character varying, character varying, character varying, boo
lean, character varying, character varying, boolean, boolean | normal

and

po40demo=# \df acs_attribute__create_attribute
List of f
unctions
Schema | Name | Result data type |
Argument data types | Type
--------+---------------------------------+------------------+--------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------
public | acs_attribute__create_attribute | integer | character varying, character varying, character varying, character varying, character varying, character varying, character varying,
character varying, integer, integer, integer, character varying, boolean | normal
public | acs_attribute__create_attribute | integer | character varying, character varying, character varying, character varying, character varying, character varying, character varying,
character varying, integer, integer, integer, character varying, boolean, boolean, character varying, character varying, boolean, character varying, character varying, character varying | normal
public | acs_attribute__create_attribute | integer | character varying, character varying, character varying, character varying, character varying, character varying, character varying,
integer, integer, integer, integer, character varying, boolean