Forum OpenACS Q&A: Request Error : No fullquery ???
---- This is what I am trying to do ---
db_transaction {
set note_id [db_nextval acs_object_id_seq]
db_exec_plsql new_note ""
set survey_id $note_id
set name $title
set description $title
set description_html_p "f"
set type "general"
set display_type "list"
db_exec_plsql create_survey ""
set section_id ""
set section_id [db_exec_plsql create_section ""]
set question_id [db_nextval acs_object_id_seq]
set sort_order "1"
set question_text $title
set abstract_data_type "text"
set required_p "f"
set active_p "t"
set presentation_type "textarea"
set presentation_options "small"
set presentation_alignment "below"
db_exec_plsql create_question {}
}
--------------------------------------------------------
------------------------------------------------
No fullquery for dbqd.forums-tobe.www.add-edit.create_question 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 "db_qd_replace_sql" line 10)
invoked from within
"db_qd_replace_sql $full_statement_name $sql"
invoked from within
"set test_sql [db_qd_replace_sql $full_statement_name $sql]"
("uplevel" body line 5)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle db {
# plsql calls that are simple selects bypass the plpgsql
# mechanism for creating anonymous functions (OpenACS - ..."
(procedure "db_exec_plsql" line 13)
invoked from within
"db_exec_plsql create_question {}"
("uplevel" body line 25)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 39)
invoked from within
"db_transaction {
set note_id [db_nextval acs_object_id_seq]
db_exec_plsql new_note ""
set survey_id $note_id
set nam..."
invoked from within
"if [template::form is_valid new_note] {
form get_values new_note title body
set user_id [ad_conn user_id]
set peeraddr [ad_conn peeraddr]
if..."
("uplevel" body line 47)
invoked from within
"uplevel {
# packages/notes/www/add-edit.tcl
ad_page_contract {
@author mailto:rhs@mit.edu
@creation-date 2000-10-23
@cvs-id $Id: add-edit.tcl,v..."
(procedure "code::tcl::/home/khalwai/openfacts/web/openacs46/packages/fo..." line 2)
invoked from within
"code::tcl::$__adp_stub"
invoked from within
"if { [file exists $__adp_stub.tcl] } {
# ensure that data source preparation procedure exists and is up-to-date
adp_init tcl $__adp_stub
..."
("uplevel" body line 3)
invoked from within
"uplevel {
if { [file exists $__adp_stub.tcl] } {
# ensure that data source preparation procedure exists and is up-to-date
adp_init t..."
(procedure "adp_prepare" line 2)
invoked from within
"adp_prepare "
(procedure "template::adp_parse" line 30)
invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
(procedure "adp_parse_ad_conn_file" line 7)
invoked from within
"$handler"
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
$handler
} ad_script_abort val {
# do nothing
}"
invoked from within
"rp_serve_concrete_file [ad_conn file]"
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$path""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$path"
set tcl_url2file([ad_conn url]) [ad_conn file]
set tcl_url2path_info([ad_conn url]) [ad_conn path_inf..."
No fullquery for dbqd.forums-tobe.www.add-edit.create_question and default SQL empty - query for statement missingIt seems that the query 'create_question' cannot be found in www/add-edit.xql. Furthermore, the default (inline) SQL is missing, which is fine if the SQL query is present in the XQL file.
You may need to do a reload/watch of that file from your packagemanager (/acs-admin/apm) also.