This seems to be linked to changes in the stored procedures belonging to the package manager. here is the error:
82.69.2.22 - - [16/Sep/2012:14:29:06 +0100] "POST /comments/comment-add-2 HTTP/1.1" 200 4404 "https://www.oakmasters.com:8440/comments/comment-add?object%5fid=11097&object%5fname=Index+Page&return%5furl=%2fweblog%2f&context%5fid=11097&category="; "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1" 0.181237 "ad_session_id=11821001%2c667%2c1+%7b708+1347805647+FB208D4C029D4AFF2D8164B12168BB64B69E09A6%7d; ad_user_login_secure=667%2c1347792208%2cBC0AB8504%2c1347792208+%7b733+0+99664A027D18CC497CEDC983FCC78822228E41D9%7d; ad_user_login=667%2c1347792208%2cBC0AB8504+%7b875+0+81627892E6669FE63275506355DF32AEA8764AB0%7d; ad_secure_token=11821001%2c1347792208%2c82%2e69%2e2%2e22+%7b877+1348397008+72D97C7BC5482D360DA92706C1C6641F96DE299E%7d"
[16/Sep/2012:14:29:09][12175.114696][-default:0-] Error: Ns_PgExec: result status: 7 message: ERROR: column "get_value__parameter_id" does not exist
LINE 1: ...es v where v.package_id = $1 and parameter_id = get_value_...
^
QUERY: select attr_value from apm_parameter_values v where v.package_id = $1 and parameter_id = get_value__parameter_id
CONTEXT: PL/pgSQL function "apm__get_value" line 9 at SQL statement
SQL statement "select apm__get_value(package_id, 'SystemURL') from apm_packages where package_key='acs-kernel'"
I have checked the functions in the database and there seem to be duplicate, overloaded function names that I wouldn't expect to see. I will post the postgres output next.
Regards
Richard
