Support

February 24, 2025 at 3:21 am

Hi there,

Do you mean when using the Automated Upcoming Event Notifications (AUEN for short) or when manually sending?

If using AUEN, do you know if this is with upcoming Event or Datetime notifications? If unsure no problem, just narrowing this down a little.

Also, just to double-check, the ‘Registration Status’ for these cancelled attendees was already set to ‘Cancelled’, correct? (I’m assuming this is the case but just confirming) But then they received the notification anyway.

February 24, 2025 at 3:39 pm

Yeah thats really weird!

I did some digging into this to check the query used to pull in the registrations and this is what is set:

        WHERE 
          Registration.REG_deleted = 0  
          AND (Event_CPT.post_type = 'espresso_events')  
          AND ( (Event___Datetime.DTT_deleted = 0) OR Event___Datetime.DTT_ID IS NULL)  
          AND ( (emt_mtp.MTP_deleted = 0) OR emt_mtp.GRP_ID IS NULL) 
          AND Event_CPT.post_status IN ('publish','sold_out') 
          AND Event___Datetime.DTT_EVT_start BETWEEN %s AND %s
          AND Registration.STS_ID = 'RAP'

In english:

WHERE
    the Registration is not deleted
    AND it's related to an espresso_event event
    AND the datetime connected to it has not been trashed, and we have a valid DTT_ID
    AND the message template has not been trashed and we have a valid GRP_ID
    AND the event is published or sold_out
    AND the EVT_Start date is between X and Y
    AND the Registration.STS_ID is RAP (aka <strong>R</strong>egistration <strong>AP</strong>proved)

The above is hardcoded into the add-on and can’t be changed so its really strange that your getting a cancelled Reg triggering te email. A cancelled registration will have STS_ID of ‘RCN’ (aka Registration CaNcelled) and so wouldn’t be included in that query.

Was this a single registration or part of a group?

February 25, 2025 at 6:09 pm

Yeah, that’s a group registration. Very strange indeed.

Was this cancelled registration a ‘moved’ registration or just one that had been manually cancelled?

(I’m just trying to work through all possible scenarios here to see if I can reproduce this)