Forum OpenACS Development: bug when renaming an instance from e.g. the site map

I fixed a little bug in apm_package_rename in CVS head. Prior to the fix this proc did only change the instance name in apm_packages, but not the title in acs_objects. Some functions use the title from acs_objects for naming the instances (e.g. the categories package) leading to inconsistent and confusing naming.

The following should be added to the update scripts to take care of already inconsistent values in the database. however, since apm_package_rename is in acs-tcl, and acs-tcl has no sql diectory, where should the update script go?


update acs_objects set title = s.instance_name from (select p.instance_name, p.package_id from acs_objects o, apm_packages p where o.object_id = p.package_id and p.instance_name <> o.title) as s where object_id = s.package_id;

this should go into acs-kernel, as this contains the apm_package sql scripts.