I'm trying to set up a reminder that sends email to people who have opted to pay later for an event, to remind them to sort out the payment in good time before the event date.
So far the way we've done this using a scheduled reminder is to specify the event and the participant status, and set the timing for the reminder to go initially on a set date, and then to repeat every X days until a couple of weeks before the event start date.
This reminder then generates a fatal mysql error and doesn't succeed. It also stops any other reminders I've set from going out.
Has anyone got reminders of this type to work?