Forum .LRN Q&A: Still no access to developers admin
Any idea how to solve this?
Thanks
Ben
There was a server error processing your request. We apologize.
Take me back where I was (before the error)
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: NO DATA FOUND
CONTEXT: PL/pgSQL function "site_node__node_id" line 42 at return
SQL:
select package_id,
package_key,
pretty_name as package_pretty_name,
apm_package_type__num_parameters(package_key) as parameter_count,
node_id, url, parent_url, name, root_p, mylevel, object_id,
directory_p, parent_id, n_children,
p.instance_name as object_name,
acs_permission__permission_p(object_id, '496', 'admin') as object_admin_p
from apm_packages p join apm_package_types using (package_key) right outer join
(select n.node_id,
site_node__url(n.node_id) as url,
site_node__url(n.parent_id) as parent_url,
n.name,
case when exists (select 1 from site_nodes where parent_id = n.node_id) then 1 else 0 end as n_children,
case when n.node_id = (select site_node__node_id('/', null)) then 1 else 0 end as root_p,
(tree_level(n.tree_sortkey) - (select tree_level(n2.tree_sortkey) from site_nodes n2 where n2.node_id = (select coalesce('488', site_node__node_id('/', null))))) as mylevel,
n.object_id,
n.directory_p,
n.parent_id
from site_nodes n, site_nodes n2
where (n.object_id is null
or exists (
select 1 from acs_object_party_privilege_map ppm
where ppm.object_id = n.object_id
and ppm.party_id = '496'
and ppm.privilege = 'read'))
and n2.node_id = (select coalesce('488', site_node__node_id('/', null)))
and n.tree_sortkey between n2.tree_sortkey and tree_right(n2.tree_sortkey)
and (n.parent_id is null or n.parent_id in (488))) site_map
on site_map.object_id = p.package_id
order by url
while executing
"ns_pg_bind select nsdb0 {
select package_id,
package_key,
pretty_name as package_pretty_name,
..."
("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 select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $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 {
set selection [db_exec select $db $full_statement_name $sql]
set counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach nodes_select {} {
set add_folder_url ""
set new_app_url ""
set unmount_url ""
set mount_url ""
set rename_url ""
se..."
("uplevel" body line 184)
invoked from within
"uplevel {
ad_page_contract {
@author mailto:rhs@mit.edu
@author mailto:bquinn@arsidigta.com
@creation-date 2000-09-09
@cvs-id $Id: index..."
(procedure "code::tcl::/usr/local/www/timedeskblog.com/openacs-5-2-2/pac..." 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..."