Forum .LRN Q&A: error with the last code downloaded from the CVS


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

Posted by Dave Bauer on
Hi, looks like a typo in the trigger I added. I'll make sure the latest version is chceked in.
Posted by Dave Bauer on
Fixed. Please re-run assessment/sql/postgresql/upgrade/upgrade-0.22d5-0.22d6.sql

to get the fix.

Thanks Dave
Hi Dave,

I had some problems with some types in the upgrade-0.22d5-0.22d6.sql file, so I uploaded a patch with my changes to the bug tracker.

Regards, javier morales