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

Comments

tanc’s picture

tanc
he/him
Primary language English
Location Italy
commented

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.

rmiddle’s picture

rmiddle commented
Status: Active » Postponed (maintainer needs more info)

Are you using Events 5.x-2.x with Eventrepeast 5.x-2.x?

Thanks
Robert

oadaeh’s picture

oadaeh commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

This issue is being closed due to age and/or version. If this issue is still valid, please reopen it against the 6.x-1.x branch and update it. There will be no more follow ups against the 5.x branches.