Forum .LRN Q&A: Survey Module Error

Collapse
1: Survey Module Error
Posted by Effendy Zainuddin on 04/10/03 04:34 AM
Platform:
dotlrn-1.0-beta2 Tarball, Redhat 7.3, Postgresql7.2.4

Survey Module

Presented with a confirm button during creation of survey, after clicking encountered the following error in the browser:

Request Error

No fullquery for dbqd.survey.tcl.survey-procs.get_survey_info.n_completed 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 $statement_name $pre_sql"
    (procedure "db_exec" line 5)
    invoked from within
"db_exec 0or1row $db $full_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
    set selection [db_exec 0or1row $db $full_name $sql]
    }"
    (procedure "db_string" line 7)
    invoked from within
"db_string n_completed {}"
    (procedure "get_survey_info" line 26)
    invoked from within
"get_survey_info -section_id $section_id"
    ("uplevel" body line 23)
    invoked from within
"uplevel {
          ad_page_contract {
    Present form to begin adding a question to a survey.
    Lets user enter the question and select a presentatio..."
    (procedure "code::tcl::/web/service0/packages/survey/www/admin/question-..." 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..."

And the followings in the log file:

[09/Apr/2003:17:06:32][4794.4101][-conn1-] Debug: NO FULLQUERY FOR dbqd.survey.tcl.survey-procs.get_survey_info.n_completed --> using default SQL
[09/Apr/2003:17:06:32][4794.4101][-conn1-] Notice: RP (293.76 ms): error in rp_handler: serving GET /survey/admin/question-add?section_id=2736
    ad_url "/survey/admin/question-add" maps to file "/web/service0/packages/survey/www/admin/question-add.adp"
errmsg is No fullquery for dbqd.survey.tcl.survey-procs.get_survey_info.n_completed and default SQL empty - query for statement missing
[09/Apr/2003:17:06:32][4794.4101][-conn1-] Debug: PgBindCmd: sql =
            select 1
            where 't' = acs_permission__permission_p(:object_id, :party_id, :privilege)

[09/Apr/2003:17:06:32][4794.4101][-conn1-] Debug: PgBindCmd: bind var: object_id = 2732
[09/Apr/2003:17:06:32][4794.4101][-conn1-] Debug: PgBindCmd: bind var: party_id = 1031
[09/Apr/2003:17:06:32][4794.4101][-conn1-] Debug: PgBindCmd: bind var: privilege = admin
[09/Apr/2003:17:06:32][4794.4101][-conn1-] Debug: PgBindCmd: query with bind variables substituted =
            select 1
            where 't' = acs_permission__permission_p('2732', '1031', 'admin')

[09/Apr/2003:17:06:32][4794.4101][-conn1-] Notice: Querying '
            select 1
            where 't' = acs_permission__permission_p('2732', '1031', 'admin');'
[09/Apr/2003:17:06:32][4794.4101][-conn1-] Notice: dbinit: sql(localhost::service0): '
            select 1
            where 't' = acs_permission__permission_p('2732', '1031', 'admin')
        '
[09/Apr/2003:17:06:32][4794.4101][-conn1-] Error: GET http://192.168.1.8:8000/survey/admin/question-add?section_id=2736
referred by "http://192.168.1.8:8000/survey/admin/survey-create"
No fullquery for dbqd.survey.tcl.survey-procs.get_survey_info.n_completed 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 $statement_name $pre_sql"
    (procedure "db_exec" line 5)
    invoked from within
"db_exec 0or1row $db $full_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
    set selection [db_exec 0or1row $db $full_name $sql]
    }"
    (procedure "db_string" line 7)
    invoked from within
"db_string n_completed {}"
    (procedure "get_survey_info" line 26)
    invoked from within
"get_survey_info -section_id $section_id"
    ("uplevel" body line 23)
    invoked from within
"uplevel {
          ad_page_contract {
    Present form to begin adding a question to a survey.
    Lets user enter the question and select a presentatio..."
    (procedure "code::tcl::/web/service0/packages/survey/www/admin/question-..." 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..."
[09/Apr/2003:17:07:12][4794.89099][-sched:10-] Notice: Running scheduled proc acs_mail_lite::sweeper...
[09/Apr/2003:17:07:12][4794.89099][-sched:10-] Debug: PgBindCmd: sql =
            select message_id,
                  to_addr,
                  from_addr,
                  subject,
                  body,
                  extra_headers,
                  bcc
            from acs_mail_lite_queue

[09/Apr/2003:17:07:12][4794.89099][-sched:10-] Notice: Querying '
            select message_id,
                  to_addr,
                  from_addr,
                  subject,
                  body,
                  extra_headers,
                  bcc
            from acs_mail_lite_queue;'
[09/Apr/2003:17:07:12][4794.89099][-sched:10-] Notice: dbinit: sql(localhost::service0): '
            select message_id,
                  to_addr,
                  from_addr,
                  subject,
                  body,
                  extra_headers,
                  bcc
            from acs_mail_lite_queue
        '
[09/Apr/2003:17:07:12][4794.89099][-sched:10-] Notice: Done running scheduled proc acs_mail_lite::sweeper.

Collapse
2: Re: Survey Module Error (response to 1)
Posted by Don Baccus on 04/11/03 05:42 PM
Thanks ... this was indeed a bug in that package however I included the wrong survey package in the tarball.  Thanks for catching this.  It will be fixed in the openacs 4.6.2 release and the proper (simple survey) package included in dotLRN 1.0 (the full survey package will follow in dotLRN 1.0.1 in a few weeks)