Index: openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9d-0.9.4d.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/upgrade/Attic/upgrade-0.9d-0.9.4d.sql,v diff -u -N -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9d-0.9.4d.sql 28 Dec 2005 17:55:43 -0000 1.1.2.1 +++ openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9d-0.9.4d.sql 28 Dec 2005 18:40:36 -0000 1.1.2.2 @@ -1,2 +1,2 @@ -alter table na_user_preferences add package_id constraint na_user_preferences_pid_fk references apm_packages(package_id); +alter table na_user_preferences add column package_id integer constraint na_user_preferences_pid_fk references apm_packages(package_id); alter table na_user_preferences drop constraint na_user_prefs_uid_pk; Index: openacs-4/packages/news-aggregator/tcl/apm-callback-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/tcl/apm-callback-procs.tcl,v diff -u -N -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/news-aggregator/tcl/apm-callback-procs.tcl 28 Dec 2005 17:55:43 -0000 1.1.2.1 +++ openacs-4/packages/news-aggregator/tcl/apm-callback-procs.tcl 28 Dec 2005 18:40:38 -0000 1.1.2.2 @@ -41,8 +41,8 @@ } { db_dml set_package_id { update na_user_preferences - set package_id = $package_id - where default_aggregator = $default_aggregator + set package_id = :package_id + where default_aggregator = :default_aggregator } } }