Forum OpenACS Development: Re: OpenACS 5.0 Upgrade Experiences

Collapse
Posted by Jade Rubick on
My upgrade took a while, but went fairly smoothly. The only problem I'm running into is that edit-this-page doesn't seem to work any longer.

It works for viewing pages, but when you try to save an edit you make:

Request Error

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  function etp__create_new_revision("unknown", "unknown", "unknown", "unknown") does not exist
HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

SQL:
select etp__create_new_revision('1096', 'co2', '292', '7716');

I'm on Postgres 7.4, and still on OpenACS 5.0

Collapse
Posted by Jade Rubick on
I fixed this problem by manually loading the 1.3-1.5 and 1.5-1.6 scripts in the sql/postgresql/upgrade directory.