Forum .LRN Q&A: Response to problems with PG7.2.1 + AOL server3.4.2

Collapse
Posted by Rafael Calvo on
thanks guys
I installed 7.2.2, updated the code from cvs and get several errors that I did not have before, for example the FAQ portlet:
*** portal::render_element show callback Error! ***

 Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  No such attribute or function 'disabled_p'

SQL: 
            select acs_objects.context_id as package_id,
                   acs_object__name(apm_package__parent_id(acs_objects.context_id)) as parent_name,
                   (select site_node__url(site_nodes.node_id)
                    from site_nodes
                    where site_nodes.object_id = acs_objects.context_id) as url,
                   faqs.faq_id,
                   faqs.faq_name
            from faqs,
                 acs_objects
            where faqs.faq_id = acs_objects.object_id
	    and faqs.disabled_p <> 't'
            and acs_objects.context_id in (0)
            order by lower(faq_name)
        

this doesn't seem like an instalation error, but since I get several such as when trying to join a community (dotlrn/register?community_id=5522&..)
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  Attribute 'autosubscribe_p' not found

SQL: 
            select forum_id
            from forums_forums
            where package_id = '5678'
              and autosubscribe_p = 't'
        
    while executing
"ns_pg_bind select nsdb0 {
            select forum_id
            from forums_forums
            where package_id = :package_id
              and auto..."
    ("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
what else could I be doing wrong, or are these new bugs?