Index: openacs-4/packages/acs-events/sql/oracle/acs-events-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/oracle/acs-events-create.sql,v diff -u -r1.10.6.1 -r1.10.6.2 --- openacs-4/packages/acs-events/sql/oracle/acs-events-create.sql 30 Mar 2007 23:09:58 -0000 1.10.6.1 +++ openacs-4/packages/acs-events/sql/oracle/acs-events-create.sql 31 Mar 2007 00:06:46 -0000 1.10.6.2 @@ -747,7 +747,7 @@ for v_timespan in (select * from time_intervals where interval_id in (select interval_id from timespans where timespan_id in (select timespan_id from acs_events where recurrence_id = (select recurrence_id from acs_events where event_id = recurrence_timespan_edit.event_id))) - and (edit_past_events = 't' or start_date >= to_date(recurrence_timespan_edit.start_date,'YYYY-MM-DD HH24:MI:SS') )) + and (edit_past_events = 't' or start_date >= to_date(v_one_start_date,'YYYY-MM-DD HH24:MI:SS') )) LOOP time_interval.edit(v_timespan.interval_id, v_timespan.start_date + (start_date - v_one_start_date), v_timespan.end_date + (end_date - v_one_end_date)); END LOOP; Index: openacs-4/packages/acs-events/sql/oracle/upgrade/upgrade-0.6d1-0.6d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/oracle/upgrade/upgrade-0.6d1-0.6d2.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-events/sql/oracle/upgrade/upgrade-0.6d1-0.6d2.sql 30 Mar 2007 23:09:59 -0000 1.1.2.1 +++ openacs-4/packages/acs-events/sql/oracle/upgrade/upgrade-0.6d1-0.6d2.sql 31 Mar 2007 00:06:47 -0000 1.1.2.2 @@ -422,7 +422,7 @@ for v_timespan in (select * from time_intervals where interval_id in (select interval_id from timespans where timespan_id in (select timespan_id from acs_events where recurrence_id = (select recurrence_id from acs_events where event_id = recurrence_timespan_edit.event_id))) - and (edit_past_events = 't' or start_date >= to_date(recurrence_timespan_edit.start_date,'YYYY-MM-DD HH24:MI:SS') )) + and (edit_past_events = 't' or start_date >= to_date(v_one_start_date,'YYYY-MM-DD HH24:MI:SS') )) LOOP time_interval.edit(v_timespan.interval_id, v_timespan.start_date + (start_date - v_one_start_date), v_timespan.end_date + (end_date - v_one_end_date)); END LOOP; Index: openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql,v diff -u -r1.14.2.1 -r1.14.2.2 --- openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 30 Mar 2007 23:09:59 -0000 1.14.2.1 +++ openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 31 Mar 2007 00:06:47 -0000 1.14.2.2 @@ -805,6 +805,7 @@ where time_intervals.interval_id = timespans.interval_id and timespans.timespan_id = acs_events.timespan_id and event_id=p_event_id; +raise notice ''v_one_start_date = %'',v_one_start_date; FOR v_timespan in select * from time_intervals @@ -814,7 +815,7 @@ from acs_events where recurrence_id = (select recurrence_id from acs_events where event_id = p_event_id))) - and (p_edit_past_events_p = ''t'' or start_date >= p_start_date) + and (p_edit_past_events_p = ''t'' or start_date >= v_one_start_date) LOOP PERFORM time_interval__edit(v_timespan.interval_id, v_timespan.start_date + (p_start_date - v_one_start_date), Index: openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6d1-0.6d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6d1-0.6d2.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6d1-0.6d2.sql 30 Mar 2007 23:09:59 -0000 1.1.2.2 +++ openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6d1-0.6d2.sql 31 Mar 2007 00:06:47 -0000 1.1.2.3 @@ -345,7 +345,7 @@ from acs_events where recurrence_id = (select recurrence_id from acs_events where event_id = p_event_id))) - and (p_edit_past_events_p = ''t'' or start_date >= p_start_date) + and (p_edit_past_events_p = ''t'' or start_date >= v_one_start_date) LOOP PERFORM time_interval__edit(v_timespan.interval_id, v_timespan.start_date + (p_start_date - v_one_start_date),