CiviCRM Community Forums (archive)

Ok, maybe I need to provide some more info and be more clear about the problem.
First of all, using Civi 3.4.1 and Joomla 1.5.23, after registering multiple participants using pay later there are some problems with the Thank You page and the confirmation/receipt email and pdf.
The main problem is that the primary registrant doesn't receive any information regarding the other participants. Attached is an image of what I mean.
Using my still quite limited knowledge of the beast that is CiviCRM, I was able to hack the BAO for the ThankYou page using the coding that adds the additional participant info in the confirmation BAO, but assigning it to customProfile instead of addParticipantInfo. This almost worked, except that now the participant note field is being output twice. This however had no effect on the receipts, and obviously is not quite right. It looks like I should probably be using the buildCustomProfile function in Event.php, but can't figure out how to properly use it.
Also, when registering multiple participants, there appears to be some problems with the additional participants when some don't have provided emails. It appears that if one participant has no email, but another participant (excluding the primary) enters one, then that participants email is used for all addtl participants registration information, and any additional participants w/o emails have confirmations  sent to that last entered email. So far I have only tested this behavior with 3 participants.

What I REALLY need to know is how to fix the primary registrants receipt to contain the rest of the participant information. The sections are there in all 3 pages, it says participant 2, participant 3, etc, but there is NO data included. This client has been a financial contributor to Civi and one of the first we have been able to bring your way. This is a deal breaker for them, and I really would like to keep them contributing as thus far it has been the most my business partner and I have been able to do to help give back. I've tried to figure it out on my own and do my part, but I've been banging my head on my desk for over a week now... my knowledge of Civi's coding is just too limited still, and quite honestly my knowledge of PHP as an OOP language is also rather limited. It's hard for me to follow everything sometimes - I am a self taught coder and when I learned PHP true OOP wasn't  even possible.

Somebody please tell me what I  can do to fix this...

I have an event setup on the sandbox that simply uses Pay later, allows multiple registrations from same email, uses new individual for the additional participant profile, no price set just set two fee levels in the event setup (members - $65, non-members $115). In other words a straightforward basic event setup, with the addition of the additional participants, multiple registrants from same email, and pay later.
I registered 3 participants using only the primary email, first registrant was members fee of $65, other two were non member fees of $115. All information was present in Confirmation.tpl, but missing in thankyou.tpl and I would assume in the emails and pdf as well but can't verify since sandbox doesn't send mail.

Here is a link to the test event, granted it hasn't been reset before you get to it...
http://joomla.demo.civicrm.org/index.php?option=com_civicrm&task=civicrm/event/info&reset=1&id=7

For tracking purpose http://issues.civicrm.org/jira/browse/CRM-8251

-Yashodha

Hey guys,
first thanks for getting that fixed so quickly, definitely appreciate it.
Have a problem however... after updating to 3.4.2, and applying the patch,  getting this error after submitting registration...
any clue whats going on?
----------------------
Database Error Code: Not unique table/alias: 'civicrm_note', 1066
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT DISTINCT(contact_a.id) as contact_id, contact_a.nick_name  as `nick_name`, civicrm_note.id as note_id, civicrm_note.note as `note`, civicrm_participant.id as participant_id, civicrm_note.note as participant_note, civicrm_value_district_counties_25.id as civicrm_value_district_counties_25_id, civicrm_value_district_counties_25.district__county_name_134 as custom_134  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 
LEFT JOIN civicrm_value_district_counties_25 ON civicrm_value_district_counties_25.entity_id = contact_a.id  LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_participant' AND
                                                        civicrm_participant.id = civicrm_note.entity_id ) WHERE  ( contact_a.id = 27003 AND civicrm_participant.id = 178 AND civicrm_participant.is_test = 0 )  AND (contact_a.is_deleted = 0)     [nativecode=1066 ** Not unique table/alias: 'civicrm_note']
    [type] => DB_Error
    [user_info] => SELECT DISTINCT(contact_a.id) as contact_id, contact_a.nick_name  as `nick_name`, civicrm_note.id as note_id, civicrm_note.note as `note`, civicrm_participant.id as participant_id, civicrm_note.note as participant_note, civicrm_value_district_counties_25.id as civicrm_value_district_counties_25_id, civicrm_value_district_counties_25.district__county_name_134 as custom_134  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 
LEFT JOIN civicrm_value_district_counties_25 ON civicrm_value_district_counties_25.entity_id = contact_a.id  LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_participant' AND
                                                        civicrm_participant.id = civicrm_note.entity_id ) WHERE  ( contact_a.id = 27003 AND civicrm_participant.id = 178 AND civicrm_participant.is_test = 0 )  AND (contact_a.is_deleted = 0)     [nativecode=1066 ** Not unique table/alias: 'civicrm_note']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT(contact_a.id) as contact_id, contact_a.nick_name  as `nick_name`, civicrm_note.id as note_id, civicrm_note.note as `note`, civicrm_participant.id as participant_id, civicrm_note.note as participant_note, civicrm_value_district_counties_25.id as civicrm_value_district_counties_25_id, civicrm_value_district_counties_25.district__county_name_134 as custom_134  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 
LEFT JOIN civicrm_value_district_counties_25 ON civicrm_value_district_counties_25.entity_id = contact_a.id  LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_participant' AND
                                                        civicrm_participant.id = civicrm_note.entity_id ) WHERE  ( contact_a.id = 27003 AND civicrm_participant.id = 178 AND civicrm_participant.is_test = 0 )  AND (contact_a.is_deleted = 0)     [nativecode=1066 ** Not unique table/alias: 'civicrm_note']"]
)