Forum OpenACS Development: Testing the Calendar Module

Posted by Lilian Tong on
Hi, I'm porting the calendar module. When I was testing out the calendar by adding an event on a particular date from a particular start time to a particular end time (say, 11/09/01 from 01:00 to 02:00), when i submit it, both the display start time and end time always turn out to be 00:00 to 00:00.

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, 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?

Posted by David Kuczek on
Hello Lilian,

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: