Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql,v
diff -u -r1.2.2.2 -r1.2.2.3
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql	18 May 2010 18:04:50 -0000	1.2.2.2
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql	18 May 2010 18:15:01 -0000	1.2.2.3
@@ -4,6 +4,7 @@
 declare
   one_user_id integer;
   bio_id integer;
+  bio_mime_type_id integer;
   attr_id integer;
 begin
 
@@ -26,6 +27,11 @@
   where  pa.party_id = pe.person_id
   and pe.person_id = u.user_id;
 
+  bio_mime_type_id := attribute_id
+                      from acs_attributes
+                      where object_type = ''person''
+                      and attribute_name = ''bio_mime_type'';
+
   bio_id := attribute_id
             from acs_attributes
             where object_type = ''person''
@@ -48,6 +54,9 @@
   delete from acs_attribute_values
   where attribute_id = bio_id;
 
+  delete from acs_attribute_values
+  where attribute_id = bio_mime_type_id;
+
   perform acs_attribute__drop_attribute (''person'',''bio'');
   perform acs_attribute__drop_attribute (''person'',''bio_mime_type'');
 
