Forum .LRN Q&A: "New Community" fails in dotLRN 2.1.3b2 (and 2.1.1)
I am using dotLRN 2.1.3b2 and OpenACS 5.1.5 with PostgreSQL 7.4.7 on a FreeBSD 5.4 System.
Now, if I want to create a new Community I get the following Error Message:
There was a server error processing your request. We apologize.
Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: function portal__new("unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", timestamp with time zone, "unknown", "unknown", "unknown") is not unique
HINT: Could not choose a best candidate function. You may need to add explicit type casts.
SQL:
select portal__new(
null,
'SIGSIC Portal',
'482',
'476',
'1714',
'Page 1',
'portal',
now(),
null,
null,
'16863'
);
while executing
"ns_pg_bind 0or1row nsdb0 {
select portal__new(
null,
:name,
:theme_id,
:la..."
("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 create_new_portal {}"
invoked from within
"set portal_id [db_exec_plsql create_new_portal {}]"
("uplevel" body line 4)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 1)
invoked from within
"db_transaction {
# create the portal and the first page
set portal_id [db_exec_plsql create_new_portal {}]
permi..."
(procedure "portal::create" line 38)
invoked from within
"portal::create -template_id $template_id -name "$pretty_name Portal" -context_id $community_id $user_id "
invoked from within
"set portal_id [portal::create -template_id $template_id -name "$pretty_name Portal" -context_id $community_id $user_id ]"
("uplevel" body line 21)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 39)
invoked from within
"db_transaction {
set user_id [ad_conn user_id]
set community_id [package_instantiate_object -extra_vars $extra_vars $object_ty..."
(procedure "dotlrn_community::new" line 25)
invoked from within
"dotlrn_community::new -community_type [community_type] -object_type [community_type] -pretty_name $pretty_name -description $description -parent_..."
(procedure "dotlrn_club::new" line 6)
invoked from within
"dotlrn_club::new -description $description -pretty_name $pretty_name -join_policy $join_policy"
invoked from within
"if {[form is_valid add_club]} {
form get_values add_club pretty_name description join_policy referer
set key [dotlrn_club::new -description..."
("uplevel" body line 44)
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::/usr/local/aolserver/dotlrn/packages/dotlrn/www/a..." 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..."
------------------------
I tried to search it in the Forums, but somehow it seems this error is very common and so there are a lot of different hints for solving it and I don't no which one to try.
And one other Question: Is there a way to sort the search results in the OpenACS Forums by date?
