Forum OpenACS Q&A: Canot create portal tables

Errors since 22/Aug/2001:19:32:12

[22/Aug/2001:19:32:12]
    Error: Ns_PgExec: result status: 7 message: ERROR:  Relation 'u'
does not exist
    

[22/Aug/2001:19:32:12]
    Error: dbinit: error(localhost::acs,ERROR:  Relation 'u' does not
exist
    ): '
            select first_names||' '||last_name as name 
            from   users
            where  ad_group_member_p ( user_id, 46 ) = 't'
            and u.user_id = map.user_id
            and map.group_id = 46
            and map.role in ('administrator', 'all')'

[22/Aug/2001:19:32:12]
    Error: Database operation "select" failed (exception NSDB, "Query
was not a statement returning rows.")
    Database operation "select" failed (exception NSDB, "Query was not
a statement returning rows.")
        while executing
    "ns_db select $db [db_sql_prep $sql"
        (procedure "database_to_tcl_list" line 2)
        invoked from within
    "database_to_tcl_list $db "
            select first_names||' '||last_name as name 
            from   users
            where  ad_group_member_p ( user_id, $group..."
        ("foreach" body line 8)
        invoked from within
    "foreach group_id $group_id_list {
    
        # get the name of the portal group
        set group_name [database_to_tcl_string $db "
            select group_name f..."
        (file
"/var/lib/aolserver/servers/defaultacs/www/portals/admin/index.tcl"
line 35)
        invoked from within
    "source $ad_conn(file)"
        (procedure "ad_handle_abstract_url" line 67)
        invoked from within
    "ad_handle_abstract_url cns100 {}"
    202.88.151.25 - - [22/Aug/2001:19:32:13 +0530] "GET
/portals/admin/ HTTP/1.0" 500 530 "" "Mozilla/4.75 [en] (X11; U; Linux
2.2.16-22 i686)"

[22/Aug/2001:19:32:20]
    Error: Ns_PgExec: result status: 7 message: ERROR:  Relation 'u'
does not exist
    

[22/Aug/2001:19:32:20]
    Error: dbinit: error(localhost::acs,ERROR:  Relation 'u' does not
exist
    ): '
            select first_names||' '||last_name as name 
            from   users
            where  ad_group_member_p ( user_id, 46 ) = 't'
            and u.user_id = map.user_id
            and map.group_id = 46
            and map.role in ('administrator', 'all')'

[22/Aug/2001:19:32:20]
    Error: Database operation "select" failed (exception NSDB, "Query
was not a statement returning rows.")
    Database operation "select" failed (exception NSDB, "Query was not
a statement returning rows.")
        while executing
    "ns_db select $db [db_sql_prep $sql"
        (procedure "database_to_tcl_list" line 2)
        invoked from within
    "database_to_tcl_list $db "
            select first_names||' '||last_name as name 
            from   users
            where  ad_group_member_p ( user_id, $group..."
        ("foreach" body line 8)
        invoked from within
    "foreach group_id $group_id_list {
    
        # get the name of the portal group
        set group_name [database_to_tcl_string $db "
            select group_name f..."
        (file
"/var/lib/aolserver/servers/defaultacs/www/portals/admin/index.tcl"
line 35)
        invoked from within
    "source $ad_conn(file)"
        (procedure "ad_handle_abstract_url" line 67)
        invoked from within
    "ad_handle_abstract_url cns101 {}"
    202.88.151.25 - - [22/Aug/2001:19:32:20 +0530] "GET
/portals/admin/ HTTP/1.0" 500 530 "" "Mozilla/4.75 [en] (X11; U; Linux
2.2.16-22 i686)"

I take it that the install itself was fine?  Can you confirm, so I can update my page to say that they work on RH 7.0 as well as RH 6.2 and RH 7.1?  Thanks!

I can't really help with the portals stuff; at a glance at your logs it looks like someone did "FROM users" when they may have meant "FROM users alias u" in a SELECT??  Someone who has actually used portals can hopefully help you sort this out.

i think here is what you are looking for :)

https://openacs.org/sdm/one-baf.tcl?baf_id=988