Hi,
I'm using the newest code donwloaded from the CVS and I'm getting an error using assessment.
I upload a course to dotLRN that has a test in IMSQTI as one of the activities.
When I run the test and dotLRN opens the assessment, I fill the answers to some questions and when I press submit, I get the next ERROR:
Error in include template "/home/nsadmin/openacs-4/packages/assessment/lib/assessment": Transaction aborted: Database operation "dml" failed (exception ERROR, "ERROR: no existe la columna «title» CONTEXT: sentencia SQL: «SELECT title from as_item_choices where choice_id = $1 » PL/pgSQL function "as_item_data_choices_ins_trg" line 4 at select into variables ")
while executing
"ns_pg_bind dml nsdb0 {
insert into as_item_data_choices (item_data_id, choice_id)
values (:as_item_data_id, :choice_id)
}"
("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 dml $db $full_statement_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
db_exec dml $db $full_statement_name $sql
}"
(procedure "db_dml" line 100)
invoked from within
"db_dml save_choice_answer {}"
("foreach" body line 2)
invoked from within
"foreach choice_id $choice_answer {
db_dml save_choice_answer {}
}"
("uplevel" body line 17)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 1)
invoked from within
"db_transaction {
if {[db_0or1row old_item_id {}]} {
if {$allow_overwrite_p == "f"} {
set as_item_data_id $latest_revision
set trans..."
(procedure "as::item_data::new" line 14)
invoked from within
"as::item_data::new -session_id $session_id -subject_id $subject_id -staff_id $staff_id -as_item_id $as_item_id -section_id $section_id -choice_answer ..."
(procedure "as::item_type_mc::process" line 45)
invoked from within
"as::item_type_$item_type\::process -type_id $item_type_id -session_id $session_id -as_item_id $response_item_id -section_id $section_id -subject_id $u..."
("foreach" body line 23)
Has someone got something similar??
Does someone know, what is going on??
Thanks, javier morales
