Forum OpenACS Q&A: User Portraits on 5.1

I was just experimenting with Portraits today.
It seems that the portraits I am trying to upload don't seem to show up in /user/portrait.

The code in portrait-bits.tcl calls cr_write_content to show the image. If I understand correctly there is a section in cr_write_content for lobs.

It seems that portraits store images in the database and that portion of cr_write_content isn't working.

The issue seems to be in the acs_objects, where upload is looking for the non-existent "title" column. Error message shows:

-----snip-----------
Database operation "dml" failed (exception ERROR, "ERROR:  Relation "acs_objects" has no column "title"
")

ERROR:  Relation "acs_objects" has no column "title"

SQL: 

	    update acs_objects
	    set title = NULL
	    where object_id = '1777'
-----snip-------------

Which comes from the last part of /packages/acs-subsite/www/user/portrait/upload-2.tcl

            db_dml update_object_title "
            update acs_objects
            set title = :title
            where object_id = :revision_id"

I'm not sure what the preferred behaviour is, but I'll log it as a bug.