Forum OpenACS Q&A: Instance Aplications

Collapse
Posted by Iuri Sampaio on
I create an instance of the pkg edit-this-page on a subsite and i got this error. Does anyone know what it could be?
I tryied to reconized the error message and it seems to be a duplicate key error, but this is the first aplication that i created on the subsite. so there is no reason to have a duplicated key

There was a server error processing your request. We apologize.

Take me back where I was (before the error)
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 104 at SQL statement
PL/pgSQL function "content_folder__new" line 40 at assignment
PL/pgSQL function "content_folder__new" line 7 at return

SQL:
select content_folder__new('home', 'home', '', coalesce(etp__get_folder_id('197696'), NULL));

while executing
"ns_pg_bind 0or1row nsdb0 {
select content_folder__new(:name, :title, '', coalesce(etp__get_folder_id(:parent_package_id), NULL));
}"
("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_folder """
invoked from within
"set folder_id [db_exec_plsql create_folder ""]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 1)
invoked from within
"db_transaction {

set folder_id [db_exec_plsql create_folder ""]
db_exec_plsql register_types ""
db_exec_plsql register_folders ""
db_dml set_fol..."
invoked from within
"if { $site_node_url == "/" } {
# -100 is the magic number for the "root folder".
set folder_id -100
db_transaction {
db_dml set_folder_pa..."
("uplevel" body line 22)
invoked from within
"uplevel {
# /packages/edit-this-page/www/etp-setup-2.tcl

ad_page_contract {
@author Luke Pond (mailto:dlpond@pobox.com)
@creation-date 2001-06-01

..."
(procedure "code::tcl::/home/yabt/yabt/packages/edit-this-page/www/etp-s..." 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..."/ home / yabt / yabt / www / yabt / resources / includes / disclaimerinc

Collapse
2: Re: Instance Aplications (response to 1)
Posted by Ben Koot on
Iuri,

I Have had that happen a number of times. Sofar trying to install an other package did the trick.

Cheers
Ben

Collapse
3: Re: Instance Aplications (response to 1)
Posted by gustaf neumann on
the error message says that you are trying to create an entry with a name that exists already. A folder in the content repository is similar to a directory in a file system. The names in this folder are unique. It seems as if you have already an entry "home" in the folder that ETP uses, and you are trying to create another page with the same name. ETP should certainly provide a friendlier error message.

i am not using ETP, so there might be an error in the package as well leading to this error message.

Collapse
Posted by Iuri Sampaio on
So doesn't it matter if they are in diferents subsites??

Anyway, to avoid this problem again, i will createa unique one