I just compiled Aolserver 4.0.10 and the related modules to install OpenAcs 5.2.2 on SuSE 9.3, PostgreSQL 8.0.3. Everything works fine, but I can not make News Aggregator work :( . I've installed other packages like Photo Album, Blog, Notifications and they are working fine. Can someone give me a help ?. The error I receive after click on News Aggregator link is :
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: syntax error at or near "0" at character 568
SQL:
select s.source_id,
s.link,
su.show_description_p,
s.description,
s.title,
s.feed_url,
i.item_id,
i.title as item_title,
i.link as item_link,
i.description as item_description,
i.content_encoded,
i.guid as item_guid,
i.original_guid as item_original_guid,
i.permalink_p as item_permalink_p,
i.author as item_author,
to_char(i.pub_date at time zone 'UTC' 0 ' hours' ::interval, 'YYYY-MM-DD') as pub_date,
to_char(i.pub_date at time zone 'UTC' 0 ' hours' ::interval, 'YYYY-MM-DD HH24:MI:SS') as pub_date_time,
s.last_modified
from (
na_aggregators a join
na_subscriptions su on (a.aggregator_id = su.aggregator_id)
) join
na_items i on (su.source_id = i.source_id)
join na_sources s on (i.source_id = s.source_id)
where a.package_id = '861'
and a.aggregator_id = '894'
and ((i.item_id > coalesce(a.aggregator_bottom, 0)) or
(i.item_id in (select item_id from na_saved_items
where aggregator_id = '894')))
order by pub_date desc, s.title, pub_date_time desc
limit 600
while executing
"ns_pg_bind select nsdb0 {
select s.source_id,
s.link,
su.show_description_p,
s.description,
..."
("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 local_counter 0
# Make sure 'n..."
(procedure "db_multirow" line 40)
invoked from within
"db_multirow -extend {
content
diff
source_url
save_url
unsave_url
item_blog_url
technorati_url
item_guid_link
..."
("uplevel" body line 145)
invoked from within
"uplevel {
ad_page_contract {
The News Aggregator index page.
@author Simon Carstensen mailto:simon@bcuni.net
@creation-date 28-06-2003
..."
(procedure "code::tcl::/var/lib/aolserver/server0/packages/news-aggregat..." 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..."
