Event Calendar Pro Total Seats/Registrations for repeating events

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
3/26/2014 6:33:39 PM
Gravatar
Total Posts 6
Bryian Tan
My blog...

Event Calendar Pro Total Seats/Registrations for repeating events

System Information
mojoPortal Version 2.4.0.2 MSSQL
ASP.NET Info v4.0.30319 Running in Full Trust

Calendar Pro: sts-eventcalendarpro-3-4-1-6

I created a repeated event using the Calendar Pro version. Repeats weekly, Required Registration, Total Seats/Registrations: 10 per event.

Let say the even will repeat from Monday to Wednesday. Each event allow 10 registrations.

Let say 10 people registered for Tuesday event, none on Monday and Wednesday.

Let say a new user want to register on Tuesday also, but the event show "Sold Out", which is correct. The problem is, it also displayed "Sold Out" for Monday and Wednesday. No one can register on Monday and Wednesday, even though there are 10 slots available on those days.

Is there a setting to prevent this from happening?

 

Thanks,

Bryian Tan

3/27/2014 10:19:40 AM
Gravatar
Total Posts 18439

Re: Event Calendar Pro Total Seats/Registrations for repeating events

Hi Bryan,

There is a checkbox when creating the event for "Ticket Includes Admission to Recurrences". If that was checked when the recurring event was created then I would expect the result you described.

Hope that helps,

Joe

 

3/27/2014 6:08:18 PM
Gravatar
Total Posts 6
Bryian Tan
My blog...

Re: Event Calendar Pro Total Seats/Registrations for repeating events

Joe,

That checkbox was unchecked.

3/28/2014 3:29:12 PM
Gravatar
Total Posts 18439

Re: Event Calendar Pro Total Seats/Registrations for repeating events

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

3/28/2014 6:14:34 PM
Gravatar
Total Posts 6
Bryian Tan
My blog...

Re: Event Calendar Pro Total Seats/Registrations for repeating events

Hi Joe,

I ran the query, deleted all the events and then recreate the recurrence events again. The issue still exists.

 

Thanks,

Bryian Tan

3/29/2014 3:50:48 PM
Gravatar
Total Posts 18439

Re: Event Calendar Pro Total Seats/Registrations for repeating events

Hi Bryian,

This fixed it on my local machine and I just ran this change on the database for our demo site and it seems to have fixed it there too, I am not able to produce the problem there anymore. Can you produce the problem on our demo site? maybe you are doing something different than I am but I was able to produce the problem until this fix.

Best,

Joe

3/29/2014 9:14:31 PM
Gravatar
Total Posts 6
Bryian Tan
My blog...

Re: Event Calendar Pro Total Seats/Registrations for repeating events

Joe,

It works after I re-ran the query again. Could be cache somewhere, I guess. Thanks!!!

Quick question. Is it possible to show this information "Total Seats/Registrations: 10, 4 sold/registered so far. View Orders" on the event page, that will give the admin a high level information of how many ticket sold so far.

 

Thanks,

Bryian Tan

3/31/2014 12:08:11 PM
Gravatar
Total Posts 18439

Re: Event Calendar Pro Total Seats/Registrations for repeating events

Hi Bryian,

I have logged a request in our project tracker to show the sold vs remaining in the admin pages and also to add an option to show it for users on the ticket ordering page.

We should be able to do that for an update to Event Calendar Pro in the near future.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.