Running this in the Host/SQL dialogue, with Execute as Script ticked, should solve the problem. This fix will be in 5.0.4.
/** EventsSignupsMyEnrollments **/
ALTER PROCEDURE {databaseOwner}{objectQualifier}EventsSignupsMyEnrollments
(
@ModuleID int,
@UserID int
)
AS
SET DATEFORMAT mdy
Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved,
u.displayName as UserName, u.Email,
c.EventTimeBegin, DATEADD(mi, c.Duration, c.EventTimeBegin) as EventTimeEnd ,c.EventName,c.Importance,c.Approved as EventApproved,
c.MaxEnrollment,
(Select count(*) from {databaseOwner}{objectQualifier}EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled,
PayPalStatus,
PayPalReason,
PayPalTransID,
PayPalPayerID,
PayPalPayerStatus,
PayPalRecieverEmail,
PayPalUserEmail,
PayPalPayerEmail,
PayPalFirstName,
PayPalLastName,
PayPalAddress,
PayPalCity,
PayPalState,
PayPalZip,
PayPalCountry,
PayPalCurrency,
PayPalPaymentDate,
PayPalAmount,
PayPalFee,
c.TimeZoneOffset
from {databaseOwner}{objectQualifier}EventsSignups s
Left Join {databaseOwner}{objectQualifier}Users u ON s.UserID = u.UserID
Left Join {databaseOwner}{objectQualifier}Events c ON s.EventID = c.EventID
Left Outer Join {databaseOwner}{objectQualifier}EventsMaster e ON s.ModuleID = e.SubEventID
Where s.Userid = @UserID AND (s.ModuleID = @ModuleID Or e.ModuleID = @ModuleID)
ORDER BY c.EventTimeBegin desc
GO