Forum .LRN Q&A: Re: Announcing the release assessment-20040924 of the assessment package for OACS.

Just updated my Assesment, etc.. packages installation from HEAD (did a fresh installation), got the following errors while trying to add the Assesment Applet (Manage Applet).

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

ERROR:  duplicate key violates unique constraint "cr_items_unique_name"
CONTEXT:  PL/pgSQL function "content_item__new" line 96 at SQL statement
PL/pgSQL function "content_template__new" line 33 at assignment
PL/pgSQL function "content_template__new" line 9 at return

SQL:

    select content_template__new('as_files_default',NULL,NULL,NULL,NULL,NULL)


    while executing
"ns_pg_bind 0or1row nsdb0 {

    select content_template__new(:name,:parent_id,:template_id,:creation_date,:creation_user,:creation_ip)

      }"
    ("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]
                }
      ..."

<snip...>