Forum OpenACS Q&A: Re: null tree_sortkey on upgrading acs-kernel

Collapse
2: Re: null tree_sortkey on upgrading acs-kernel (response to 1)
Posted by Victor Guerra on 02/20/13 12:31 PM
Hi Justis,

actually there is a trigger on the acs_objects table ( acs_objects_insert_tr ) which executes before inserting, that trigger takes care of calculating the tree_sortkey. Are you probably dropping that trigger during the upgrade process? Maybe you can quickly check if the trigger is still there after running the whole upgrade process?. I quickly grep'd the upgrade scripts and I don't see any obvious code that would drop that trigger.

Best,

Collapse
3: Re: null tree_sortkey on upgrading acs-kernel (response to 2)
Posted by Justis Peters on 02/20/13 05:41 PM
Thanks, Victor. I think that's the issue. We're testing this on a copy of the database and it appears that the triggers on rel_constraints somehow didn't get restored.

Kind regards,
Justis

Collapse
4: Re: null tree_sortkey on upgrading acs-kernel (response to 3)
Posted by Justis Peters on 02/21/13 05:31 AM
Yes, that was the issue. Thanks again for the pointer.