Forum OpenACS Development: Testing the Calendar Module
This is the query (from cal-item-postgresql.xql) that I suspect might have went wrong:
select to_char(start_date, 'MM/DD/YYYY') as start_date, to_char(start_date, 'HH24:MI') as start_time, to_char(end_date, 'HH24:MI') as end_time, coalesce(a. name, e.name) as name, coalesce(e.description, a.description) as description from acs_activities a, acs_events e, timespans s, time_intervals t where e.timespan_id = s.timespan_id and s.interval_id = t.interval_id and e.activity_id = a.activity_id and e.event_id = :cal_item_id
I had been trying to find out what went wrong for a long time, will anyone be able to help me on this issue?
I have not touched 4.x till now, but we had a similar problem with the events module in 3.2.5.
It had nothing to do with the database. It was a malfunctioning widget that broke it.
Here is my post from some times ago: