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) »
  • Duplicate event registration entries
Pages: [1]

Author Topic: Duplicate event registration entries  (Read 2176 times)

cbh

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.71-log
  • PHP version: 5.5.3
Duplicate event registration entries
April 28, 2011, 08:45:03 am
I'm running into a problem - with one registrant for a workshop so far, where their registration is duplicated in the participant listing. The URL for each record is identical, and if I delete one, they both disappear. Ttrying to dedupe contacts has no result. Processing a payment has it show once only on the payment register, but on both participant records. I'm running the current release of Drupal, and as well the current release (as of just now) of CIVICRM. In the participant listing the "results" number is correct at 9 participants (for example) but there are actually 10 items showing in the list (including the duplicate) Any suggestions?

Thanks
Chris

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Duplicate event registration entries
April 28, 2011, 09:46:57 am
What registration are you running ? With profile & allow multiple registration & multiple users can have the same email ? What's your dedupe rules ? Has the duplicate person been registering him/herself twice ?

That has been an issue that under the wrong combinations you get duplicates, but I thought it was fixed.

It would be great if you can reproduce on demo.civicrm.org, we can't fix for sure if we can't reproduce for sure. I know that might be quite complex, but we'd need you to step up and help identify what to do to experience the problem.

Can you update your profile to confirm you are on d7 & civi 4 ?

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

cbh

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.71-log
  • PHP version: 5.5.3
Re: Duplicate event registration entries
April 28, 2011, 12:51:39 pm
Sorry, I was referring to the current versions of D6 and civicrm 3.40 (which I'd just upgraded from 3.3.5 - where the problem arose)
A participant self registered for a workshop module (there are 5 in the program) and the registration apparently went fine - I don't administer the site on a day to day basis. The event is set to no duplicate emails and no multiple user registration. We set these to allow 15 days from registration for a cheque to arrive and then once the cheque is in process the payment. It appears this happened only for this particular registrant when the payment was processed. This happened again, for this registrant only, on their registration and payment for another module in the program as well. All other registrations appear to be going fine. Because of the circumstances, I think this would be difficult to do a second time since it seems to have been restricted to one participant.

elodie

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 3.3.3
  • CMS version: Drupal 6.17
  • MySQL version: 5.0.77
  • PHP version: 5.2.10
Re: Duplicate event registration entries
May 12, 2011, 03:36:07 pm
I'm experiencing the same problem. Some participants appear twice in the listing though they really refer to one and only event registration.
These duplicated are not counted in the total count of participants neither do they appear in exports. They are only present in the participant listing and in the event tab for the concerned contact.
Any idea what's wrong?
Here we're using Drupal 6 and CiviCRM 3.3.3.
Thanks,
Elodie

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Duplicate event registration entries
May 12, 2011, 10:01:15 pm
Can you check if they have several role
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

elodie

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 3.3.3
  • CMS version: Drupal 6.17
  • MySQL version: 5.0.77
  • PHP version: 5.2.10
Re: Duplicate event registration entries
May 13, 2011, 09:18:34 am
I'm guessing your talking about the participant role. No, they have only one: 'Attendee'.

alabra

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
Re: Duplicate event registration entries
May 23, 2011, 12:56:49 pm
We have just experienced this problem with Civi 3.4.1 on Drupal 6.20. The user was looking at a participant list in CiviEvent, found a participant, clicked Edit, and typed in the Note field. Upon clicking "Save," the participant was listed twice in the participant list. The user then deleted the apparent duplicate, but this deleted both entries. I can confirm that these are not separate instances in the civicrm_participant table and that the View and Edit links for the participant goes to the same url (same entity_id and contact_id). So, my guess is that there could be an error in the SQL that joins _participants with the _note table?  Perhaps related to issue #CRM-5271?

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: Duplicate event registration entries
May 23, 2011, 02:44:50 pm

yes, most likely this is due to the fact that the code is left joining the participant field with the notes field (to account for the case wher e a participant has no notes)

Would be great if you can take a look at the code and submit a patch. The easiest is to do so after the query and/or add a group by to the final clause

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

cbh

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.71-log
  • PHP version: 5.5.3
Re: Duplicate event registration entries
May 27, 2011, 06:42:15 am
The problem is continuing since my previous posting an is having the same result as the one described by Alabra on deletion. It seems to occur when we process a payment (they're all by cheque only) and not consistently for all payments. Drupal 6.20 and Civicrm 3.4.0. Payment records look accurate even though the participant listing displays the individual twice. We've been deleting and reentering which seems to work ok, but I'm thinking since counts, et. aren't affected, maybe we're best living with the occasional duplicate until this is patched. Sorry I don't know how to do the patching!

Cheers
Chris

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: Duplicate event registration entries
May 27, 2011, 04:01:35 pm

any chance u can enable query logging via the devel module

if so, check the queries generated, find the one generating the listing (will be the one with quite a few LEFT JOINS) and then trace the reason for the duplicate entry twice (most likely due to one of the left joins)

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

cbh

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.71-log
  • PHP version: 5.5.3
Re: Duplicate event registration entries
May 27, 2011, 04:40:49 pm
I'll give that a try.. I'm assuming you're referring to Drupal's developer module, is that right?

cbh

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.71-log
  • PHP version: 5.5.3
Re: Duplicate event registration entries
June 07, 2011, 08:08:26 am
This is what looks like what you suggested - I have no idea what I'm looking at here - so any help you can provide would be appreciated. In addition the client tells me the note data they input wasn't recorded when they hit submit. I'm going to update to the most current version in the 3 series- we're currently at 3.40. Does this help?

Thanks
Chris

4.07
1
singleValueQuery
SELECT count( DISTINCT(civicrm_participant.id) ) FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND contact_a.id = civicrm_note.entity_id ) LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id ) LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id ) LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value AND option_group_participant_role.id = participant_role.option_group_id ) LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id) WHERE ( civicrm_event.id = 7 AND civicrm_participant.status_id IN ('1','2','5','9','13') AND civicrm_participant.is_test = 0 ) AND (contact_a.is_deleted = 0)
7.01
1
executeQuery
SELECT DISTINCT(civicrm_participant.id), contact_a.id as contact_id, contact_a.contact_type as `contact_type`, contact_a.contact_sub_type as `contact_sub_type`, contact_a.sort_name as `sort_name`, contact_a.display_name as `display_name`, civicrm_event.id as event_id, civicrm_event.title as event_title, civicrm_event.start_date as event_start_date, civicrm_event.end_date as event_end_date, civicrm_participant.id as participant_id, civicrm_participant.fee_level as participant_fee_level, civicrm_participant.fee_amount as participant_fee_amount, civicrm_participant.fee_currency as participant_fee_currency, event_type.label as event_type, participant_status.label as participant_status, participant_status.id as participant_status_id, civicrm_participant.role_id as participant_role_id, civicrm_participant.register_date as participant_register_date, civicrm_participant.source as participant_source, civicrm_note.note as participant_note, civicrm_participant.is_pay_later as participant_is_pay_later, civicrm_participant.is_test as participant_is_test, civicrm_participant.registered_by_id as participant_registered_by_id, discount_name.label as participant_discount_name, civicrm_participant.campaign_id as participant_campaign_id FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id ) LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id ) LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_participant' AND civicrm_participant.id = civicrm_note.entity_id ) LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value AND option_group_participant_role.id = participant_role.option_group_id ) LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id) WHERE ( civicrm_event.id = 7 AND civicrm_participant.status_id IN ('1','2','5','9','13') AND civicrm_participant.is_test = 0 ) AND (contact_a.is_deleted = 0) ORDER BY participant_register_date desc LIMIT 0, 50

jcost

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 3.4, 4.x
  • CMS version: Drupal 6.x, 7.x
  • MySQL version: various
  • PHP version: Various
Re: Duplicate event registration entries
September 08, 2011, 09:37:00 pm
Was this ever fixed or what was the outcome?  We are experiencing the same thing - if you add notes to an event participant it duplicates them. 

cbh

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.71-log
  • PHP version: 5.5.3
Re: Duplicate event registration entries
September 09, 2011, 07:13:48 am
I never followed up. We moved to a newer version, and have now shut that site down and reopened it on a server running fastcgi to resolve some other issues we were having. Once that one is up and running, I'll see what happens with it and report back here.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Duplicate event registration entries

This forum was archived on 2017-11-26.