Forum .LRN Q&A: Problem withEvaluation

Collapse
Posted by Antonio Mejias on
Hi to everyone,

I'm using openacs oacs 5.4 version to validate in HTML and I install the package 'evaluation' and I find this error.

(copy and paste)

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR: -20000: This items content type evaluation_grades is not registered to this folder -100

SQL:

select content_item__new('evaluation_grades_2712',NULL,'2712',NULL,'2008-02-18 18:27:27.563715-05','603','2696','127.0.0.1','content_item','evaluation_grades',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'file','2463')


while executing
"ns_pg_bind 0or1row nsdb0 {

select content_item__new(:name,:parent_id,:item_id,:locale,:creation_date,:creation_user,:context_id,:creation_ip,:item_s..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
invoked from within
"if {[regexp -nocase -- {^\s*select} $test_sql match]} {
# ns_log Debug "PLPGSQL: bypassed anon function"
set selection..."
("uplevel" body line 6)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
# plsql calls that are simple selects bypass the plpgsql
# mechanism for creating anonymous fun..."
(procedure "db_exec_plsql" line 57)
invoked from within
"db_exec_plsql exec_func_plsql {}"
(procedure "package_exec_plsql" line 31)
invoked from within
"package_exec_plsql -var_list $var_list content_item new"
invoked from within
"set item_id [package_exec_plsql -var_list $var_list content_item new]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 1)
invoked from within
"db_transaction {
db_dml lock_objects "LOCK TABLE acs_objects IN SHARE ROW EXCLUSIVE MODE"
set item_id [package_exec_plsql -var_list $var_list cont..."
(procedure "content::item::new" line 25)
invoked from within
"content::item::new -item_id $item_id -parent_id $folder_id -content_type $content_type -name $item_name -context_id $package_id -creation_date $creati..."
(procedure "evaluation::new_grade" line 17)
invoked from within
"evaluation::new_grade -new_item_p 1 -item_id $exams_item_id -content_type evaluation_grades -content_table evaluation_grades -content_id grade_id -nam..."
(procedure "evaluation::apm::package_instantiate" line 37)
invoked from within
"evaluation::apm::package_instantiate -package_id 2696"
("eval" body line 1)
invoked from within
"eval $command"
(procedure "apm_invoke_callback_proc" line 37)
invoked from within
"apm_invoke_callback_proc -package_key $package_key -type "after-instantiate" -arg_list [list package_id $package_id]"
(procedure "apm_package_instance_new" line 23)
invoked from within
"apm_package_instance_new -package_id $package_id -package_key $package_key -instance_name $package_name -context_id $context_id"
(procedure "site_node::instantiate_and_mount" line 39)
invoked from within
"site_node::instantiate_and_mount -node_name $mount_point -parent_node_id $parent_node_id -package_key $package_key -context_id $package_id "
(procedure "dotlrn::instantiate_and_mount" line 15)
invoked from within
"dotlrn::instantiate_and_mount $community_id [package_key]"
(procedure "dotlrn_evaluation::add_applet_to_community" line 5)
invoked from within
"dotlrn_evaluation::add_applet_to_community $community_id"
(procedure "AcsSc.dotlrn_applet.addapplettocommunity.dotlrn_evaluation" line 1)
invoked from within
"AcsSc.dotlrn_applet.addapplettocommunity.dotlrn_evaluation 2367"
("uplevel" body line 1)
invoked from within
"uplevel $func_and_args"
(procedure "apply" line 3)
invoked from within
"apply $proc_name $arguments"
(procedure "acs_sc_call" line 6)
invoked from within
"acs_sc_call dotlrn_applet $op $list_args $applet_key"
(procedure "applet_call" line 2)
invoked from within
"applet_call $applet_key AddAppletToCommunity [list $community_id]"
invoked from within
"set package_id [applet_call $applet_key AddAppletToCommunity [list $community_id]]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 39)
invoked from within
"db_transaction {
set package_id [applet_call $applet_key AddAppletToCommunity [list $community_id]]

register_a..."
(procedure "dotlrn_community::add_applet_to_community" line 2)
invoked from within
"dotlrn_community::add_applet_to_community $community_id $applet_key"
("uplevel" body line 43)
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::/home/cyfuss/dotlrn/packages/dotlrn/www/applet-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"
invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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..."

I think that it's a failure database but I don't know resolve it.

thank you very much
--
regards
Antonio Mejias

Collapse
2: Re: Problem withEvaluation (response to 1)
Posted by Emmanuelle Raffenne on
Hi Antonio,

This has finally been fixed in the oacs-5-4 branch (acs-content-repository package).

Thanks for reporting.