I think this is where it's choking...I don't really have the sql chops to notice if anything is obviously wrong here -- Does anyone see something.
From:
openacs/packages/acs-content-repository/tcl/item-procs.xql
(I had ro remove some tags because the forum doesn't accept HTML...)
*SNIP*
fullquery name="item::content_methods_by_type.cmbt_get_content_mime_types">
*SNIP*
select mime_type from cr_content_mime_type_map
where content_type = :content_type
and lower(mime_type) like 'text/%'
*SNIP*
Or maybe the file needs what was taken out recently:
http://cvs.openacs.org/cvs/openacs-4/packages/acs-content-repository/tcl/item-procs.xql?r1=1.6&r2=1.6.2.1