Forum OpenACS Q&A: Re: Project Manager 1.09b1 released

Collapse
Posted by Rocael Hernández Rizzardini on
I was trying to upgrade from pm 1.03 and got this error:
CREATE FUNCTION
CREATE FUNCTION

Failed to install Project Manager, version 2.1b1. The following error was generated:

    Password: psql:upgrade-1.03-1.04b1.sql:70: ERROR: relation "chid" does not exist CONTEXT: PL/pgSQL function "cr_items_tree_update_tr" line 28 at select into variables

Any ideas?

The logger and organization worked well for the upgrades from openacs-5-1-compat.

Collapse
Posted by Rocael Hernández Rizzardini on
ok, the error is in the last line of the upgrade file:

db-> update cr_items set parent_id = (select package_id from cr_folders where folder_id = item_id and label = 'Projects')
db-> where item_id = (select folder_id from cr_folders where label = 'Projects' and description = 'Project Repository');
ERROR:  relation "chid" does not exist
CONTEXT:  PL/pgSQL function "cr_items_tree_update_tr" line 28 at select into variables

any hints?

Collapse
Posted by Rocael Hernández Rizzardini on
ok, its an error on this pg func: cr_items_tree_update_tr, instead of chid should be child?  I tried to re-create this function but seems to have dependencies that don't allow me to drop it, anyone with suggestions?
Collapse
Posted by Rocael Hernández Rizzardini on
ok, dropping the trigger is what I needed ;)
then all the pm upgrades worked just fine!