Hi Bryian,
Thanks for the bug report, I was able to reproduce this problem and fix it so it will be fixed in the next update for event calendar pro.
In the meantime you can fix it immediately if you run this sql command to update the stored procedure:
ALTER PROCEDURE [dbo].[sts_CalendarEvents_UpdateSoldTicketCount]
/*
Author: Joe Audette
Created: 2008-06-06
Last Modified: 2014-03-28
*/
@ItemGuid uniqueidentifier,
@RecurrenceGuid uniqueidentifier,
@TicketIncludesRecur bit
AS
UPDATE [dbo].[sts_CalendarEvents]
SET
SoldSeats = COALESCE((
SELECT SUM(t.Quantity)
FROM [dbo].[sts_EventTicketOrder] t
WHERE
(t.EventGuid = @ItemGuid
OR
(t.[RecurrenceGuid] = @RecurrenceGuid
AND t.RecurrenceGuid <>'00000000-0000-0000-0000-000000000000')
AND @TicketIncludesRecur = 1
)
AND t.OrderStatusGuid <> '00000000-0000-0000-0000-000000000000'
AND t.OrderStatusGuid <> 'de3b9331-b98f-493f-be5e-926ffe5003bc'
),0)
WHERE
[ItemGuid] = @ItemGuid
OR ([RecurrenceGuid] = @RecurrenceGuid AND TicketIncludesRecur = 1)
GO
It won't fix events already marked as sold out but it should prevent that from happening again.
Thanks,
Joe