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

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