Forum OpenACS Development: ACS developer support is broken

Posted by Bart Teeuwisse on 06/26/01 07:48 PM

After enabling the ACS Developer Support each request for a page results in a server error. The culprit is ds_user_select_widget which is called by rp_handler. ds_user_select_widget tries to execute the following query:


        select u.user_id as user_id_from_db,
               acs_object.name(user_id) as name,
               p.email
        from   users u,
               parties p
        where  u.user_id = p.party_id

This query causes an dbinit error :


        parser: parse error at or near "("

It is here that my limited knowledge of Postgresql leaves me hanging. Could someone shed some light on the matter?

2: Response to ACS developer support is broken (response to 1)

Posted by Dan Wickstrom on 06/26/01 07:57 PM

You've found an unported query. It should be:

 select u.user_id as user_id_from_db,
                    acs_object__name(user_id) as name,
                    p.email
             from   users u,
                    parties p
             where  u.user_id = p.party_id