CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions »
  • CiviEvent Suggestions (Moderator: Michał Mach) »
  • Is number of participants for an option checked when registration is submitted?
Pages: [1]

Author Topic: Is number of participants for an option checked when registration is submitted?  (Read 1916 times)

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Is number of participants for an option checked when registration is submitted?
June 27, 2011, 03:34:39 am
We are a not-for-profit using the CiviEvent for registrations for a conference where we expect 500+ attendees.   It has 4 sessions where there are concurrent presentations.

When someone registers they must choose the presentations they will attend during each session as some presentations are limited to just 12 participants.

The ability to set the maximum number of participants for each price field option is great, but it doesn't seem to work reliably.   

I could be wrong but it seems to me that the number of participants for an option is checked when the registration process starts, but it is not checked again when the registration is submitted.   This means that an option can be oversubscribed quite easily.

For example.  If the max particpants for option 1 is 12 and there are only 11 for the option when John starts registering, his registration screen will show that he can choose option 1.  John is interupted during the registration process and doesn't return to complete it until 30 minutes later.  He has selected option 1 and his registration is OK'd.

However, whilst John was attending to his emergency, Mary started and completed her registration for the event also choosing option 1.  She is the 12th participant for the session and John is actually 13th. 

When John's registration was submitted it should have been declined with the message - "Option 1 is no longer available please select another option" in similar way to the error message you get if you try to register multiple participants and one of them has already registered themselves.

If I am wrong and the number of participants for an option is checked when the registration is submitted,  why do I have 13 participants in one of the options where the maximum is set to 12? (I have set the participant count to 1 and the option cannot be selected by anymore people but there are 13 in the group, not 12.)






Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Is number of participants for an option checked when registration is submitted?
June 27, 2011, 02:24:04 pm

I suspect your analysis is right and we just check at the beginning (which is good) but not at the end (which is bad) or setting a lock for that event while doing the processing (which is also bad)

Would be great if your org could help contribute changes and/or sponsor development to improve CiviEvent to ensure that we do another check before we the transaction and also do a db lock to avoid multiple registrations simultaneously. This will help improve CiviEvent and help make it a lot more robust. I suspect checking just before doing the transaction is a 15-20 hour project and doing the DB lock etc to make it even better another 20 or so hour project

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Is number of participants for an option checked when registration is submitted?
July 03, 2011, 05:38:53 am
I would certainly like to be able to pay our developer to do the work, but we are still converting our entire system to civiCRM and are rather stretched for funds at the moment.   There are other modifications on our list that have a higher priority and I will have to wait to see if there is any money left at the end.  In the mean time I have indicated to registrants that places in the very restricted sessions are provisional only and will be confirmed closer to the conference.

I am hoping that some of our higher priorities might be useful to the civiCRM community and will be asking our developer for his opinion in that regard.  I am very aware that free open source software can only thrive if people contribute back when they can.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions »
  • CiviEvent Suggestions (Moderator: Michał Mach) »
  • Is number of participants for an option checked when registration is submitted?

This forum was archived on 2017-11-26.