Forum OpenACS Development: error at login
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
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