Forum OpenACS Development: Re: get_value__parameter

2: Re: get_value__parameter_id error (response to 1)

Posted by Cesareo Garcia Rodicio on 11/05/13 10:21 PM

I've checked if this function exists in my database (and it doesn't)

 \df get_value*
\df get_value*
                       List of functions
 Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows)

Seeking with these problem, I see it has already reported but ...

I check apm-create.file and it seems to be fine;

> grep "parameter_id =" acs-kernel/sql/postgresql/apm-create.sql    and parameter_id = v_parameter_id;
    and parameter_id = v_parameter_id;
     where parameter_id = v_parameter_id
     where parameter_id = v_parameter_id

3: Re: get_value__parameter_id error (response to 2)

Posted by Gustaf Neumann on 11/06/13 08:09 AM

try the following when calling psql with you database name:

\x
\df+ apm__get_value

you should see two functions with different argument types.
-g

5: Re: get_value__parameter_id error (response to 3)

Posted by Cesareo Garcia Rodicio on 11/06/13 11:45 AM

Yes, two functions:

openacs=# \df apm__get_value*
\df apm__get_value*
List of functions
-[ RECORD 1 ]-------+-------------------------------------
Schema              | public
Name                | apm__get_value
Result data type    | character varying
Argument data types | character varying, character varying
Type                | normal
-[ RECORD 2 ]-------+-------------------------------------
Schema              | public
Name                | apm__get_value
Result data type    | character varying
Argument data types | integer, character varying
Type                | normal

4: Re: get_value__parameter_id error (response to 2)

Posted by Gustaf Neumann on 11/06/13 09:21 AM

The bug was introduced between OpenACS 5.6.0 and OpenACS 5.7.0 and effects only upgrades. i wonder, why we don't see more complaints about this. Anyhow, i've added an upgrade script to the oacs-5-8 branch. Please either upgrade from CVS, or wait until tomorrow and do an "upgrade from repository" when you are using OpenACS 5.8.0.

-gustaf

6: Re: get_value__parameter_id error (response to 4)

Posted by Cesareo Garcia Rodicio on 11/06/13 11:47 AM

As you wish. It sounds "more general" to use "upgrade from repository" but I can test whether option you want.

7: Re: get_value__parameter_id error (response to 6)

Posted by Gustaf Neumann on 11/06/13 06:24 PM

please try tomorrow "upgrade from repo" .. -g

8: Re: get_value__parameter_id error (response to 7)

Posted by Cesareo Garcia Rodicio on 11/07/13 01:38 PM

Update Kernel:
acs-admin ... Install Software ... Upgrade from Repository

Kernel from 5.8.1d3 to 5.8.1d4

Restart and ... voilá 😊 Thanks

Forum OpenACS Development: Re: get_value__parameter_id error