CiviCRM Community Forums (archive)

CiviCRM 4.2.6, Drupal 7.15

I'm setting up events with waiting lists. I'm not sure if this is a bug or a configuration issue. Example:

Event 1 has max attendance set at 5. Five people sign up, one on waiting list. When one person cancels and a person is moved from "on waiting list" to "pending", and they click the link to "confirm your registration" from their email, the event is shown as full ("oops" error message). This happens even if I change participant status "pending" from "counted" to "not counted".

There are no fees involved, and all of these are single registrations, not multiple people.

I changed line 118 in CRM/Event/Form/Registration/ParticipantConfirm.php

//$requireSpace = 1 + count($additonalIds);
 $requireSpace = count($additonalIds);

and now it works fine. Maybe there is a problem with "pending" status being counted, or in calculating the required space? Any help would be appreciated. Thanks!

This is pretty hacky, and I don't really know what I'm doing, but I looked at CRM/Event/BAO/Participant.php around line 567. It looked like it wasn't taking into account 'Pending' statuses. Here's my hacky fix:

    $positiveStatuses = CRM_Event_PseudoConstant::participantStatus(NULL, "class = 'Positive'");
    $pendingStatuses = CRM_Event_PseudoConstant::participantStatus(NULL, "class = 'Pending'");
    $statusIds = '(' . implode(',', array_keys($positiveStatuses)) . ')';
    $statusPending = '(' . implode(',', array_keys($pendingStatuses)) . ')';

    $query = "
  SELECT  count(participant.id) as registered,
          civicrm_event.max_participants
    FROM  civicrm_participant participant, civicrm_event
   WHERE  participant.event_id = {$eventId}
     AND  civicrm_event.id = participant.event_id
     AND  participant.status_id IN {$statusIds}
     AND  participant.status_id IN {$statusPending}
GROUP BY  participant.event_id
";

Seems to work as it should for now. I'm sure someone can come up with a more elegant fix.