Forum .LRN Q&A: Query did not return any rows

Collapse
Posted by Ibrahim Wan on
When add user(Proffesor/student) the following error occurr;

Query did not return any rows.
while executing
"db_1row get_layout_id_name_select {}"
(procedure "get_layout_id" line 8)
invoked from within
"get_layout_id"
(procedure "portal::create" line 26)
invoked from within
"portal::create -template_id $template_id -name "[_ dotlrn.lt_Your_dotLRN_Workspace]" $user_id"
invoked from within
"set portal_id [portal::create -template_id $template_id -name "[_ dotlrn.lt_Your_dotLRN_Workspace]" $user_id] "
("uplevel" body line 4)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 1)
invoked from within
"db_transaction {
set_can_browse -user_id $user_id -can_browse\=$can_browse_p

set portal_id [portal::create -template_id $template_i..."
(procedure "dotlrn::user_add" line 20)
invoked from within
"dotlrn::user_add -id $id -type $type -can_browse\=$can_browse_p -user_id $user_id"
("uplevel" body line 3)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 39)
invoked from within
"db_transaction {

dotlrn::user_add -id $id -type $type -can_browse\=$can_browse_p -user_id $user_id

dotlrn_privacy::set_user_gues..."
invoked from within
"if {[form is_valid add_user]} {

form get_values add_user user_id id type can_browse_p guest_p referer

set subject "Your [ad_system_name] me..."
("uplevel" body line 57)
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::/var/lib/aolserver/nsadmin/packages/dotlrn/www/ad..." 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 5)
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..."

My system configuration as following;
FEDORA 3,AOL40r10,Postgres-7.4.7,openacs-5.1.5 and dotlrn-2.1.1

Appreciate any help.

Collapse
Posted by Sudheer Alladi on
I too face the problem. Am using openacs 5.1.5 on oracle 10g.

Any one who faced the same problem, please suggest how to overcome it.

Thanks,
Sudheer Alladi.