Forum OpenACS Development: error at login

Collapse
Posted by Iuri Sampaio on
hi there,

i got this weird error at login page.
Error in include template "/web/openacs/packages/acs-subsite/lib/login": Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

It attempts to include a lib file but it didn't find it. I already checked and everything looks fine, including the query mentioned in the error.
Has anyone already faced this kind of issue?
(logs are bellow)

[30/Jan/2009:13:26:43][23384.3030584240][-conn:openacs::3] Notice: location "http://10.5.100.50:8000/*"; url / match 0
[30/Jan/2009:13:26:43][23384.3030584240][-conn:openacs::3] Notice: location "https://10.5.100.50:8443/*"; url / match 0
[30/Jan/2009:13:26:43][23384.3030584240][-conn:openacs::3] Error: Ns_PgExec: result status: 7 message: ERROR: column "search_impl_id" does not exist
LINE 7: search_impl_id,
^

[30/Jan/2009:13:26:43][23384.3030584240][-conn:openacs::3] Error: Error in include template "/web/openacs/packages/acs-subsite/lib/login": Database operation "0or1row" failed
(exception NSDB, "Query was not a statement returning rows.")

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

while executing
"ns_pg_bind 0or1row nsdb0 {
select help_contact_text,
help_contact_text_format,
get_doc_impl_id,
..."
("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 -dbn $dbn db {
set selection [db_exec 0or1row $db $full_statement_name $sql]
}"
(procedure "db_0or1row" line 50)
invoked from within
"db_0or1row select_authority {
select help_contact_text,
help_contact_text_format,
get_doc_impl_id,
..."
("uplevel" body line 1)
invoked from within
"uplevel db_0or1row $args"
(procedure "db_1row" line 2)
invoked from within
"db_1row select_authority "
select [join $columns ",\n "]
from auth_authorities
where authorit..."
(procedure "auth::authority::get_not_cached" line 12)
invoked from within
"auth::authority::get_not_cached 9"
("eval" body line 1)
invoked from within
"eval $script"
invoked from within
"ns_cache eval util_memoize $script {
list $current_time [eval $script]
}"
(procedure "util_memoize" line 20)
invoked from within
"util_memoize [list auth::authority::get_not_cached $authority_id]"
(procedure "auth::authority::get" line 5)
invoked from within
"auth::authority::get -authority_id $authority_id -array authority"
(procedure "auth::get_register_authority" line 10)
invoked from within
"auth::get_register_authority"
invoked from within
"if { $authority_id eq [auth::get_register_authority] || [auth::UseEmailForLoginP] } {
set register_url [export_vars -no_empty -base $register_url ..."
("uplevel" body line 84)
invoked from within
"uplevel {
# Present a login box
#
# Expects:
# subsite_id - optional, defaults to nearest subsite
# return_url - optional, defaults to Your..."
(procedure "code::tcl::/web/openacs/packages/acs-subsite/lib/login" 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"
invoked from within
"template::adp_parse [template::util::url_to_file "[ad_quotehtml [lang::util::localize ${login_template}]]" "$__adp_stub"] [list return_url "[lang::uti..."
[30/Jan/2009:13:26:43][23384.3030584240][-conn:openacs::3] Warning: /register/ has no doc(title) set.
[30/Jan/2009:13:26:44][23384.3029531568][-conn:openacs::4] Error: return: failed to redirect 'GET /global/file-not-found.html': exceeded recursion limit of 3
[30/Jan/2009:13:26:50][23384.3000576944][-sched:idle0-] Notice: starting

Collapse
2: Re: error at login (response to 1)
Posted by Iuri Sampaio on
Problem solved.
it was related to DNS stuff in the firewall.

this line at aolserver init service caught my attention to it

[30/Jan/2009:13:47:55][24455.3083749600][-main-] Error: dns: getaddrinfo

failed for debian: Name or service not known