I´m trying to help Ben with this OpenAcs instance, but after removing and reinstalling lars-blogger, it still produces errors. In the end, I resorted tot use all sql-drop-scripts, and after that installing the last version including all packages it depends on.
Now, the error we get is:
Request Error
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: Relation "category_tree_map" does not exist
SQL:
select c.category_id as sw_category_id, c.tree_id
from categories c, category_tree_map ctm
where ctm.tree_id = c.tree_id
and ctm.object_id = '8371'
while executing
"ns_pg_bind select nsdb0 {
select c.category_id as sw_category_id, c.tree_id
from categories c, category_tree_map ctm
where ctm.tree_id = c.tr..."
("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 -unclobber -extend {sw_category_name tree_name} sw_categories sw_categories {
select c.category_id as sw_category_id, c.tree_id
fro..."
("uplevel" body line 174)
invoked from within
"uplevel {
ad_page_contract {
The Weblogger index page.
(etc.)
So, maybe I have to manually run an sql script to provide the necessary relation? Which script is that (if there is any chance of succcess)?
