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) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Disappearing Registrations
Pages: [1]

Author Topic: Disappearing Registrations  (Read 1657 times)

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Disappearing Registrations
October 27, 2009, 03:12:04 pm
I have a system I setup recently that seems to have registrations that disappear. We have confirmation emails for most of the people who claimed they registered, so it isn't just a case of "I thought I signed up".

I have checked the server logs and find nothing unusual and I am at a loss as to where to look from here.

Has anyone experienced this before? Any direction on where I can begin looking for clues?

Thanks for your help,
Quint
« Last Edit: October 27, 2009, 03:15:41 pm by qjensen »
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

desert_rider

  • Guest
Re: Disappearing Registrations
October 27, 2009, 07:40:01 pm
I had a similar problem earlier this year as well on CiviCRM 2.2.x which I managed to work around. I can't remember exactly what I did because it was a long time ago and we don't have that problem anymore.

Anyway, can you give me some more details?

 - are these users logged in or anonymous?
 - what options have you set for "register multiple participants" and "allow same email address" for the event?
 - are these "missing" users listed in the civicrm_participants table in the database?

The problem I think we had occurred when we had logged in users buying tickets for themselves and a partner using the register multiple participants feature and we had the "allow same email address" feature checked. A profile collected first and last names. The subsequent participants first and last name were not being exported on a search, only the primary participant.

If you are up to the task, I would try backing up your database and civicrm install and then updating to civicrm 3.0.1 to see if it captures those missing participants in the searches and/or reports. The new reporting features are really powerful and I would try them out for yourself. You might find it finds those "missing" participants without any trouble.

Cheers

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Disappearing Registrations
October 28, 2009, 03:01:29 am
Hi desert rider

The participants are all anonymous at this point. We have turned on register multiple participants and did allow multiple participants to register using the same email address. Unfortunately, the missing attendees do not show up in the civicrm_participants database. That would at least explain something :)

I will disable the allow multiple users to register from the same email address for the next event and see if that clears up the problem.

I will consider the move to 3.01. I have 4 sites running CiviCRM right now and this might be a good test case for the upgrade process.

Thanks for the ideas,
Quint
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

desert_rider

  • Guest
Re: Disappearing Registrations
October 29, 2009, 04:28:25 am
You may find this post interesting:
http://forum.civicrm.org/index.php?topic=10052.0

Try setting your strict dedupe rules for contacts to email = 10, first name = 10, last name = 10 and total = 30, that may help your future events.

I'm surprised to hear they aren't in the civicrm_participant table.... try doing the following SQL statement on the table
Code: [Select]
SELECT * FROM `civicrm_participant` WHERE `registered_by_id` IS NOT NULL
Do you get any matching records?

This selects all those event participants that were registered by someone else using the "register additional participants" option on the event page.

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Disappearing Registrations
October 29, 2009, 02:43:38 pm
I ran that query and none of the records match the "missing" records. I am really at a loss as to what to tell my client. It is as if the registrations never happened despite the fact that the attendee received a confirmation email.
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

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: Disappearing Registrations
October 29, 2009, 02:49:37 pm

since you have the confirmation emails for most of the people, can you check and see the following:

1. Do any of them use the same email address

2. Is the registration happening while they are logged into the system. i.e. is someone registering from the same logged in user multiple times?

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

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Disappearing Registrations
October 30, 2009, 03:51:27 am
Hi Donald,

None of the emails from the missing registrations use the same email address and none of the registrants was logged in at the time. Right now the system is just being used for event registration so none of the participants have accounts on the system.

I am putting myself on the bcc list for confirmation emails to the next event so I will be able to confirm and double check each entry. I am also going to dump the db nightly instead of weekly so I will have snapshots that I can use for forensics work if this happens again.
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Disappearing Registrations
October 30, 2009, 12:23:44 pm
I set myself up to receive a bcc for all confirmation emails and have only received 4 messages while CiviEvent lists 33 participants. I checked the mail logs on the server and only 4 messages were sent.

I think I am missing something obvious here, but I can't put my finger on it. I am going to check with my hosting company (WiredTree) to see if they have any ideas.
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Disappearing Registrations
October 30, 2009, 03:27:34 pm
Solved problem with email messages not being sent. Found solution here -> http://forum.civicrm.org/index.php/topic,9812.0.html.

This is why I love OSS. Good solutions fast. ;D

I am still holding my breath on the missing registrants issue. I will no more after the event on Nov 10.
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Disappearing Registrations

This forum was archived on 2017-11-26.