Forum OpenACS Q&A: Re: site-map problems with aolserver 4

Collapse
7: Re: site-map problems with aolserver 4 (response to 1)
Posted by tammy m on 04/22/03 08:24 PM
Hi I'm glad you posted this! I have been having the problem. It happens on adding a subfolder in SiteMap and also on New Application. If I then click on any other link immediately afterword (like Administration), then I get the same error for that link, however the 2nd time I click the Administration link, The Administration page loads fine. Actually, I just tried this, and I can click any link immediately afterward (even my homepage) and it also gets an error, the first time only.

This happens on 4.0beta3 and beta4. I am using IE 5.2 on Mac OS X. It does not happen on Mozilla 1.0 on Mac OS X though.

Here is my output from the server log: 

[22/Apr/2003:11:18:13][32185.10244][-conn:openacs-dev::6] Debug: RP (17.773 ms): rp_filter: setting up request: GET /admin/site-map expand=2115&root_id=2115
[22/Apr/2003:11:18:13][32185.10244][-conn:openacs-dev::6] Debug: Security: Getting token_id 629, value D5D92E410131F7E6C88B94B226B333F47DE8389D
[22/Apr/2003:11:18:13][32185.10244][-conn:openacs-dev::6] Debug: Security: Expire_Time is 1051036650 (compare to 1051035493), hash is 32BA0FA6F92101D1DA264B89D628B664449053A1
[22/Apr/2003:11:18:13][32185.10244][-conn:openacs-dev::6] Debug: Security: Done calling get_cookie 150001,2123 {629 1051036650 32BA0FA6F92101D1DA264B89D628B664449053A1} for ad_session_id; received 1051036650 expiration, getting 150001,2123 and 629 1051036650 32BA0FA6F92101D1DA264B89D628B664449053A1.
[22/Apr/2003:11:18:13][32185.10244][-conn:openacs-dev::6] Error: invalid database id:  "nsdb0"
invalid database id:  "nsdb0"
    while executing
"ns_pg_bind 0or1row nsdb0 {
            select 1
            where 't' = acs_permission__permission_p(:object_id, :party_id, :privilege)
        }"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
        set selection [db_exec 0or1row $db $full_statement_name $sql]
    }"
    (procedure "db_0or1row" line 22)
    invoked from within
"db_0or1row select_permission_p {}"
    (procedure "permission::permission_p_not_cached" line 6)
    invoked from within
"permission::permission_p_not_cached -party_id $party_id -object_id $object_id -privilege $privilege"
    (procedure "permission_p" line 8)
    invoked from within
"permission_p -party_id $party_id -object_id $object_id -privilege $privilege"
    (procedure "permission::require_permission" line 7)
    invoked from within
"permission::require_permission -object_id [ad_conn object_id] -privilege admin"
    invoked from within
"if {[string match "admin/*" [ad_conn extra_url]]} {
            permission::require_permission -object_id [ad_conn object_id] -privilege admin
        } else..."
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
        if {[string match "admin/*" [ad_conn extra_url]]} {
            permission::require_permission -object_id [ad_conn object_id] -privilege adm..."
    (procedure "rp_filter" line 152)
    invoked from within
"rp_filter preauth"
[22/Apr/2003:11:18:17][32185.13319][-conn:openacs-dev::8] Debug: RP (34.706 ms): rp_filter: setting up request: GET /admin/site-map expand=2115&root_id=2115
[22/Apr/2003:11:18:17][32185.13319][-conn:openacs-dev::8] Debug: Security: Getting token_id 629, value D5D92E410131F7E6C88B94B226B333F47DE8389D
[22/Apr/2003:11:18:17][32185.13319][-conn:openacs-dev::8] Debug: Security: Expire_Time is 1051036650 (compare to 1051035497), hash is 32BA0FA6F92101D1DA264B89D628B664449053A1
[22/Apr/2003:11:18:17][32185.13319][-conn:openacs-dev::8] Debug: Security: Done calling get_cookie 150001,2123 {629 1051036650 32BA0FA6F92101D1DA264B89D628B664449053A1} for ad_session_id; received 1051036650 expiration, getting 150001,2123 and 629 1051036650 32BA0FA6F92101D1DA264B89D628B664449053A1.
[22/Apr/2003:11:18:18][32185.13319][-conn:openacs-dev::8] Error: invalid database id:  "nsdb0"
invalid database id:  "nsdb0"
    while executing
"ns_pg_bind 0or1row nsdb0 {
            select 1
            where 't' = acs_permission__permission_p(:object_id, :party_id, :privilege)
        }"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
        set selection [db_exec 0or1row $db $full_statement_name $sql]
    }"
    (procedure "db_0or1row" line 22)
    invoked from within
"db_0or1row select_permission_p {}"
    (procedure "permission::permission_p_not_cached" line 6)
    invoked from within
"permission::permission_p_not_cached -party_id $party_id -object_id $object_id -privilege $privilege"
    (procedure "permission_p" line 8)
    invoked from within
"permission_p -party_id $party_id -object_id $object_id -privilege $privilege"
    (procedure "permission::require_permission" line 7)
    invoked from within
"permission::require_permission -object_id [ad_conn object_id] -privilege admin"
    invoked from within
"if {[string match "admin/*" [ad_conn extra_url]]} {
            permission::require_permission -object_id [ad_conn object_id] -privilege admin
        } else..."
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
        if {[string match "admin/*" [ad_conn extra_url]]} {
            permission::require_permission -object_id [ad_conn object_id] -privilege adm..."
    (procedure "rp_filter" line 152)
    invoked from within
"rp_filter preauth"
[22/Apr/2003:11:18:34][32185.2051][-sched-] Notice: Running scheduled proc search_indexer...
[22/Apr/2003:11:18:34][32185.2051][-sched-] Error: invalid database id:  "nsdb0"
invalid database id:  "nsdb0"
    while executing
"ns_pg_bind select nsdb0 {
            select object_id, event_date, event
            from search_observer_queue
            order by event_date asc
 ..."
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    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 db {
        set selection [db_exec select $db $full_statement_name $sql]

        set counter 0
        while { [db_getrow $db $selection] } {
            incr co..."
    (procedure "db_foreach" line 35)
    invoked from within
"db_foreach search_observer_queue_entry {} {

        switch $event {
            INSERT {
                set object_type [acs_object_type $object_id]..."
    (procedure "search_indexer" line 5)
    invoked from within
"search_indexer"
    ("eval" body line 1)
    invoked from within
"eval [concat [list $proc] $args]"
    (procedure "ad_run_scheduled_proc" line 43)
    invoked from within
"ad_run_scheduled_proc {f f 30 search_indexer {} 1050957902 0 t}"
[22/Apr/2003:11:18:41][32185.12294][-conn:openacs-dev::7] Debug: RP (12.053 ms): rp_filter: setting up request: GET / 
[22/Apr/2003:11:18:41][32185.12294][-conn:openacs-dev::7] Debug: Security: Getting token_id 629, value D5D92E410131F7E6C88B94B226B333F47DE8389D
[22/Apr/2003:11:18:41][32185.12294][-conn:openacs-dev::7] Debug: Security: Expire_Time is 1051036650 (compare to 1051035521), hash is 32BA0FA6F92101D1DA264B89D628B664449053A1
[22/Apr/2003:11:18:41][32185.12294][-conn:openacs-dev::7] Debug: Security: Done calling get_cookie 150001,2123 {629 1051036650 32BA0FA6F92101D1DA264B89D628B664449053A1} for ad_session_id; received 1051036650 expiration, getting 150001,2123 and 629 1051036650 32BA0FA6F92101D1DA264B89D628B664449053A1.
[22/Apr/2003:11:18:41][32185.12294][-conn:openacs-dev::7] Error: invalid database id:  "nsdb0"
invalid database id:  "nsdb0"
    while executing
"ns_pg_bind 0or1row nsdb0 {
            select 1
            where 't' = acs_permission__permission_p(:object_id, :party_id, :privilege)
        }"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
        set selection [db_exec 0or1row $db $full_statement_name $sql]
    }"
    (procedure "db_0or1row" line 22)
    invoked from within
"db_0or1row select_permission_p {}"
    (procedure "permission::permission_p_not_cached" line 6)
    invoked from within
"permission::permission_p_not_cached -party_id $party_id -object_id $object_id -privilege $privilege"
    (procedure "permission_p" line 8)
    invoked from within
"permission_p -party_id $party_id -object_id $object_id -privilege $privilege"
    (procedure "permission::require_permission" line 7)
    invoked from within
"permission::require_permission -object_id [ad_conn object_id] -privilege read"
    invoked from within
"if {[string match "admin/*" [ad_conn extra_url]]} {
            permission::require_permission -object_id [ad_conn object_id] -privilege admin
        } else..."
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
        if {[string match "admin/*" [ad_conn extra_url]]} {
            permission::require_permission -object_id [ad_conn object_id] -privilege adm..."
    (procedure "rp_filter" line 152)
    invoked from within
"rp_filter preauth"
[22/Apr/2003:11:18:42][32185.14344][-conn:openacs-dev::9] Debug: RP (11.946 ms): rp_filter: setting up request: GET / 
[22/Apr/2003:11:18:42][32185.14344][-conn:openacs-dev::9] Debug: Security: Getting token_id 629, value D5D92E410131F7E6C88B94B226B333F47DE8389D
[22/Apr/2003:11:18:42][32185.14344][-conn:openacs-dev::9] Debug: Security: Expire_Time is 1051036650 (compare to 1051035522), hash is 32BA0FA6F92101D1DA264B89D628B664449053A1
[22/Apr/2003:11:18:42][32185.14344][-conn:openacs-dev::9] Debug: Security: Done calling get_cookie 150001,2123 {629 1051036650 32BA0FA6F92101D1DA264B89D628B664449053A1} for ad_session_id; received 1051036650 expiration, getting 150001,2123 and 629 1051036650 32BA0FA6F92101D1DA264B89D628B664449053A1.
[22/Apr/2003:11:18:42][32185.14344][-conn:openacs-dev::9] Error: invalid database id:  "nsdb0"
invalid database id:  "nsdb0"
    while executing
"ns_pg_bind 0or1row nsdb0 {
            select 1
            where 't' = acs_permission__permission_p(:object_id, :party_id, :privilege)
        }"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
        set selection [db_exec 0or1row $db $full_statement_name $sql]
    }"
    (procedure "db_0or1row" line 22)
    invoked from within
"db_0or1row select_permission_p {}"
    (procedure "permission::permission_p_not_cached" line 6)
    invoked from within
"permission::permission_p_not_cached -party_id $party_id -object_id $object_id -privilege $privilege"
    (procedure "permission_p" line 8)
    invoked from within
"permission_p -party_id $party_id -object_id $object_id -privilege $privilege"
    (procedure "permission::require_permission" line 7)
    invoked from within
"permission::require_permission -object_id [ad_conn object_id] -privilege read"
    invoked from within
"if {[string match "admin/*" [ad_conn extra_url]]} {
            permission::require_permission -object_id [ad_conn object_id] -privilege admin
        } else..."
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
        if {[string match "admin/*" [ad_conn extra_url]]} {
            permission::require_permission -object_id [ad_conn object_id] -privilege adm..."
    (procedure "rp_filter" line 152)
    invoked from within
"rp_filter preauth"
Collapse
8: Re: site-map problems with aolserver 4 (response to 7)
Posted by Michael Bluett on 04/22/03 09:45 PM
Off-topic, but it looks like the above text is an example of the automatic HTML tag-closer not working.  It doesn't look to have closed the <code> tag.