Forum .LRN Q&A: Bug in Manage Memberships Page?

Collapse
Posted by Jarkko Laine on
I (or in fact, a tester of dotLRN) came across an error when trying to manage class memberships:

In the ...class-name/members pages (Manage Memberships from class admin page) there is an Admin button for every member of the class. When you push that button, you get the following error:

[05/Dec/2002:14:03:25][10142.4101][-conn1-] Error: GET http://swissnet.cc.tut.fi:8057/dotlrn/classes/tiedonhallinta/enterprise-information-systems/enterprise-information-systems/member-add-2?user_id=2610&referer=/dotlrn/classes/tiedonhallinta/enterprise-information-systems/enterprise-information-systems/members
referred by "http://swissnet.cc.tut.fi:8057/dotlrn/classes/tiedonhallinta/enterprise-information-systems/enterprise-information-systems/members"
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_pg_bind 0or1row nsdb0 {}"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    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 select_role {}"
    invoked from within
"if {$member_p} {
    set existing_role [dotlrn_community::get_role_pretty_name -community_id $community_id -rel_type [db_string select_role {}]]
    i..."
    ("uplevel" body line 50)
    invoked from within
"uplevel {
          #
#  Copyright (C) 2001, 2002 MIT
#
#  This file is part of dotLRN.
#
#  dotLRN is free software; you can redistribute it and/or modi..."
    (procedure "code::tcl::/web/dotlrn-test/packages/dotlrn/www/member-add-2" 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..."
This applies to every member of every class on our server (w/ PostgreSQL) and with at least two different users with site-wide admin rights trying to get to the page. I couldn't repeat the error on collaboraid's i18n server running oracle.

Collapse
Posted by Caroline Meeks on
Its probably an error in the postgres query.

This page is supposed to let you change a person's role.