Forum OpenACS Q&A: Re: Package ACS Events Installation Error

Collapse
Posted by Ricardo Jorge on
If nobody fix todays problems ( issues ), we will never move to the next step.

Besides package ACS Events, I can tell that working with PostgreSQL 8.1 is not that difficult, nor impossible.

I already help fix issues with News Aggregator and Forums is also working.

I am testing tsearch2 and it seems to be working fine, but I also want to install Lars Blogger that needs ACS Events.

The problem with package ACS Events, seems to be related to these 2 functions:

======== First ===============
declare
get_html_p__event_id alias for $1; -- in acs_events.event_id%TYPE
v_html_p acs_events.html_p%TYPE;
begin
select coalesce(e.html_p, a.html_p) into v_html_p
from acs_events e
left join acs_activities a
on (e.activity_id = a.activity_id)
where e.event_id = get_html_p__event_id

return v_html_p;

end;' language 'plpgsql';

========== Second ===========
declare
get_status_summary__event_id alias for $1; -- acs_events.event_id%TYPE
v_status_summary acs_events.status_summary%TYPE;
begin
select coalesce(e.status_summary, a.status_summary) into v_status_summary
from acs_events e
left join acs_activities a
on (e.activity_id = a.activity_id)
where e.event_id = get_status_summary__event_id

return v_status_summary;

end;' language 'plpgsql';

Let's see what else can be done. Thanks Ricardo Jorge