Hi Brian,
This problem comes up with a new install of oacs 5.10. Mounting an instance of file storage, setting it to store in the database, then uploading a pdf document, produced the error. I tried to debug and accidentally posted one of those errors instead of the original. The odd path results from the cut and paste.
I did look for the query in the -postgresql.xql and did not find 'set_content'. I tried to use 'update_content' instead of the missing 'set_content' in content-revision-procs.tcl. With this change I ended up getting a different error. I was hoping that someone had more information on the missing 'set_content' in the -postrgresql.xql.
My install uses:
http://cvs.openacs.org/browse/OpenACS/openacs-4/packages/acs-content-repository/tcl/content-revision-procs.tcl?r=1.36.2.8
and makes reference to 'set_content' which does not exist in -postgresql.xql.
ad_proc -private ::content::revision::update_content-lob {
-item_id:required
-revision_id:required
-content:required
-mime_type:required
{-tmp_filename ""}
} {
if {$tmp_filename ne ""} {
# handle file
set filename [cr_create_content_file $item_id $revision_id $tmp_filename]
db_dml set_content "" -blob_files [list $tmp_filename]
db_dml set_size ""
} else {
# handle blob
db_dml update_content "" -blobs [list $content]
}
}
Here is a cut and paste of the error message:
[28/Nov/2022:10:35:20][101538.7fa0fa406640][-conn:oacs-5-10-0:default:0:19-] Error: rp_handler no-script-abort: errorMsg Transaction aborted: No fullquery for dbqd.acs-content-repository.tcl.conten
t-revision-procs.content::revision::update_content-lob.set_content and default SQL empty - query for statement missing while serving POST /download/file-add HTTP/1.1
: ad_url </download/file-add> maps to file </var/www/oacs-5-10-0/packages/file-storage/www/file-add.adp>
: NONE
: No fullquery for dbqd.acs-content-repository.tcl.content-revision-procs.content::revision::update_content-lob.set_content and default SQL empty - query for statement missing
: while executing
: "error "No fullquery for $statement_name and default SQL empty - query for statement missing""
: (procedure "::nsf::procs::db_qd_replace_sql" line 27)
: invoked from within
: "db_qd_replace_sql -ulevel [expr {$ulevel +1 }] -subst $subst $statement_name $pre_sql"
: (procedure "::nsf::procs::db_exec" line 5)
: invoked from within
: "db_exec -subst $subst dml $db $full_statement_name $sql"
: ("uplevel" body line 21)
: invoked from within
: "uplevel 1 $code_block "
: invoked from within
: "db_with_handle -dbn $dbn db {
: # another ugly hack to avoid munging Tcl files.
: # __lob_id needs to be set inside of a query (.x..."
: (procedure "::nsf::procs::db_dml" line 70)
: invoked from within
: "db_dml set_content "" -blob_files [list $tmp_filename]"
: (procedure "::nsf::procs::content::revision::update_content-lob" line 5)
: invoked from within