Forum OpenACS Q&A: Request Error : No fullquery ???

Collapse
Posted by Kiran Halwai on
I am getting following error when trying to combine notes and survey package into another package. Any help?

---- 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..."

Collapse
Posted by xx xx on
No fullquery for dbqd.forums-tobe.www.add-edit.create_question and default SQL empty - query for statement missing
It 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.