Forum OpenACS Development: Broken /admin/site-map (CVS head 12/30/02)

I've just loaded the acs-core module from CVS head 12/30/02 on top of aolserver331+ad13 and postgresql 7.3.

Browser-based installation was successful. However, when I go to the site-map (/admin/site-map), I see the following error in the aolserver error log. Can anyone point me in the right direction to solve this problem?

[31/Dec/2002:17:43:38][1216.172037][-conn4-] Error: GET http://rmosrv02.rmo.local/admin/site-map/?
referred by "http://rmosrv02.rmo.local/admin/"
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_pg_bind select nsdb0 {
            select package_id,
                   package_key,
                   pretty_name as package_pretty_name,
      ..."
    ("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 nodes_select {} {
    if { [lsearch -exact $open_nodes $parent_id] == -1 && $parent_id != "" && $mylevel > 2 } { continue } 
    doc_body_a..."
    ("uplevel" body line 106)
    invoked from within
"uplevel {
    	  ad_page_contract {

    @author rhs@mit.edu
    @author bquinn@arsidigta.com
    @creation-date 2000-09-09
    @cvs-id $Id: index.tcl..."
    (procedure "code::tcl::/home/aolserver/servers/openacs4/packages/acs-sub..." 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 7)
    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([ad_conn url]) [ad_conn path_inf..."
Collapse
Posted by Bart Teeuwisse on
Randy,

you'll have to apply a patch to PostgreSQL 7.3 posted earlier in https://openacs.org/forums/message-view?message_id=64527.

/Bart

Collapse
Posted by Randy O'Meara on
Thank you, Bart.

Would it be better to:

a) revert to pg 7.2.x
b) move up to pg 7.3.1
c) apply the patch you provided to 7.3

Randy

Collapse
Posted by Lamar Owen on
Better to get PostgreSQL 7.3.1, which has the patch Bart mentions already applied.

PostgreSQL 7.3.1 is available now at ftp://ftp.postgresql.org/pub/v7.3.1

RPMS at ftp://ftp.postgresql.org/pub/binary/v7.3.1/RPMS

Collapse
Posted by Randy O'Meara on
Thank you, Lamar.

I performed the pg 7.3.1 upgrade with RPMs and the site-map problem is fixed.

One caveat... pg 7.3.1 revised libpq.so from 2 to 3, so it was necessary to rebuild aolserver (at least the postgres.so driver). postgres.so failed to load since it couldn't find libpq.so.2.

Randy

Collapse
Posted by Lamar Owen on
Randy,

As Bart mentioned in a different thread, do be aware that CVS HEAD != OACS4.6.

Having said all that, CVS HEAD + PG 7.3.1 sounds good, and I'm glad to have helped.

There _should_ have been a libpq version upgrade at 7.3; it was done at 7.3.1 because it _wasn't_ done at 7.3.

Collapse
Posted by Randy O'Meara on
Lamar,

Thanks for the help. I'm going to drop back to PG 7.2.3 and the 4.6 CVS branch at this point.

Randy