Interval doesn't work
tanc - November 18, 2007 - 02:45
| Project: | Event Repeat |
| Version: | 5.x-2.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
Description
I can't get the interval to work at all with any versions of event repeat. I recently upgraded to the 5.x-2.x version hoping this issue was fixed but it doesn't seem to be.
I've tried with both weekly and daily setting, using both Count and 'Repeat end date' types. I'm trying to set an event that repeats every two weeks from a specific start date, falling on a Tuesday. If this is supposed to work, can someone talk me through it? My settings:
Repeat type: Weekly
End Settings: repeat end date 1 January 2010
Interval: 2
Day(s): Tuesday
#1
Forgot to mention, I get an SQL warning when trying to submit an event with an interval setting:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '20:00:00) - DAYOFWEEK('2007-11-28 20:00:00')) - (TO_DAYS(date) - DAYOFWEEK(date)' at line 1 query: SELECT date FROM event_repeat_calendar_map WHERE (day_of_week IN('TU') OR day_in_month IN('TU') OR day_in_month_R IN('TU')) AND ((((TO_DAYS(2007-11-28 20:00:00) - DAYOFWEEK('2007-11-28 20:00:00')) - (TO_DAYS(date) - DAYOFWEEK(date)))/7) % 2 = 0) AND date <= '2010-01-01 23:59:59' AND date > '2007-11-28 20:00:00' ORDER BY date in /mysite.com/includes/database.mysql.inc on line 172.#2
Are you using Events 5.x-2.x with Eventrepeast 5.x-2.x?
Thanks
Robert