Sebastian, If something didn't get upgrade correctly than it would have been incorrect in the package. The DotNetNuke.Modules.Events.dll is dated 1/5/2015 10:37:24. If something is out of date or not correct the installation package might need to be looked at. This is happening on 2 completely different instances both upgraded from 6.1.4.
Here's what I have for the SP in the DB.
USE [DotNetNuke] GO /****** Object: StoredProcedure [dbo].[EventsSignupsMyEnrollments] Script Date: 2/5/2015 3:36:30 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /** EventsSignupsMyEnrollments **/ ALTER PROCEDURE [dbo].[EventsSignupsMyEnrollments] ( @ModuleID int, @UserID int, @SocialGroupId int ) AS BEGIN SET NOCOUNT ON; 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 SUM(NoEnrolees) FROM dbo.[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, NoEnrolees, r.EventTimeZoneId, AnonEmail, AnonName, AnonTelephone, AnonCulture, AnonTimeZoneId, S.FirstName, S.LastName, S.Company, S.JobTitle, S.ReferenceNumber, S.Street, S.PostalCode, S.City, S.Region, S.Country FROM dbo.[EventsRecurMaster] AS r RIGHT OUTER JOIN dbo.[Events] AS c ON r.RecurMasterID = c.RecurMasterID RIGHT OUTER JOIN dbo.[EventsSignups] AS s LEFT OUTER JOIN dbo.[Users] AS u ON s.UserID = u.UserID ON c.EventID = s.EventID LEFT OUTER JOIN dbo.[EventsMaster] AS e ON s.ModuleID = e.SubEventID Where s.Userid = @UserID AND (s.ModuleID = @ModuleID Or e.ModuleID = @ModuleID) AND (r.SocialGroupId = @SocialGroupId or (r.SocialGroupId is null and @SocialGroupId = 0)) ORDER BY c.EventTimeBegin desc END
|