CiviCRM Community Forums (archive)

This is now fixed on demo (the fatal error part). Event search still has a few open issues (event types dont seem to work) in 2.0 which we'll fix this week. However, do try to reproduce the export error and file an issue if so

thanx

lobo

the demo database is a bit messed up and has 2 participant records for most of the cases. I'll ask piotr to regenerate the demo database from scratch. I cant reproduce this issue on localhost using civicrm_generated.mysql data

Can you give that a shot

thanx

lobo

can u check the civicrm_participant table and do an order by contact_id for that event and see if there are multiple records being displayed

is this the same db with the "groups bug"? if so i can debug both issues at the same time

another option is to check your mysql query log for the export SQL and restrict it to one contact and see why its returning multiple records. Will give u some good SQL experience

lobo

I just ran into this and perhaps my case can shed some light which will help to zero in on the bug.

History:
I had someone register for an event.  There was a difference between Joomla user and CCRM first names, so a new contact was created.  I noticed this when I exported participants and there was no street address for this contact.  Fixed the first name and thought I'd use the find and merge duplicates process, both for my own education and to preserve any table links, etc..  The contacts matched appropriately and I completed the merge.  I then ran a search by last name and both contacts - the full and partial display on the search list.  Selecting any of the links on the partial contact directed to display or edit the full contact.  Attempting to delete the partial contact results in "zero contacts selected" on the confirmation screen.

Situation:
CiviEvent displays the correct number of participants, but when this contact is checked and participants are exported, two lines are generated for this contact in the CSV file with the same Contact and Participant ID in each line.  The two lines only differ in that one has mailing address info in the appropriate fields and one does.  There is only one entry in the civicrm_participant table with this Contact ID.

I'm wondering if Emily's client also de-duped some contacts and if there is a relation that is being inappropriately preserved somewhere?

The issue did duplicate on the demo, and I'll open an issue in the tracker.  On the demo, the partial record did NOT display in a contact search but it did export.

I'm still using v1.9 until we complete an event at the end of the month.

I'm having this issue as well.  What happens is a client has an event that they copy.  When pulling the export participant report on the current months event, any participants that have participated in prior months events are appearing which gives the impression of duplicates.  What I noticed is that instead of assigning a new participant id for the new event, it is using the same id as it did for the prior months event.  The prior events are disabled.  Any ideas/solutions?  Thanks!