Index: openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.0d3-1.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.0d3-1.0d4.sql,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.0d3-1.0d4.sql 15 Jul 2005 21:01:52 -0000 1.3 +++ openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.0d3-1.0d4.sql 15 Jul 2005 21:19:05 -0000 1.4 @@ -42,11 +42,11 @@ UPDATE contact_search_conditions SET var_list = ''in '' || to_char(package.new_group_id,''FM9999999999999999'') - WHERE list_name = ''in -2''; + WHERE var_list = ''in -2''; UPDATE contact_search_conditions SET var_list = ''not_in '' || to_char(package.new_group_id,''FM9999999999999999'') - WHERE list_name = ''not_in -2''; + WHERE var_list = ''not_in -2''; RAISE NOTICE ''NEW GROUP ID IS %'', package.new_group_id; FOR member IN select distinct member_id, acs_object__name(member_id) as name from group_member_map where group_id = ''-2''