ThankYou.tpl and email receipt missing additional participant information

[websitesRevolt]

When registering multiple participants with pay later, ThankYou.tpl and the email receipt are missing any information for additional participants, even when only one email is used for all registrants.
There are headings for Participant 2, 3 etc, but no data underneath these headings.
When checking in debug, the only data being passed for addtl participants is the participant name in the $part array, and the $customProfile only contains those headings for each addtl participant.
I have duplicated this on the demo site, so is this behavior intentional and if so why create the headings at all then?

Also, when registering multiple participants with one email, the event receipt is being sent one time for each participant but each receipt is identical, containing only the primary registrants information and the headings mentioned above. Wouldn't it make more sense to still send each participants confirmation just as you would if they had provided separate emails? What if they wanted to print it out or forward it to the registrant outside of civi?

[websitesRevolt]

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...

[Dave Greenberg]

I have duplicated this on the demo site, so is this behavior intentional and if so why create the headings at all then?

Hey - we'd like to nail this down and hopefully get a fix (I think we saw some similar quirks recently). The expected behavior for primary + additional is that the primary participant gets a receipt with all profile info for themselves and each additional participant. The additional participant receipts should just contain "their" info (and even if all receipts are going to same email, I agree that the above behavior should hold true).

Can you give exact steps for how you replicated on the demo, including:
1. What fields in the primary / additional participant profiles
2. What settings for Event Registration tab
3. Did you use same email for multiple participants
.... as much detail as you can provide will be helpful.

We'll post back here once we have a better idea of what's going on.

[websitesRevolt]

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

[Yashodha Chaku]

I was able to replicate the same behavior, will investigate and get back to you on this.

-Yashodha

[Yashodha Chaku]

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

-Yashodha

[websitesRevolt]

didnt try replicating (aren't emails still logged somewhere on the sandbox? I'll look it up in a second I suppose), but there also appears to be a problem with additional participants that don't all provide emails. Say when registering participant 2, the email field was left blank, but was provided for participant 3... the individual receipts for participant 2 and 3 both go to the email provided for participant 3... however if only primary registrants email is supplied then (at least on our server) we are getting the behavior mentioned in my first post - that being that we get a primary registrant receipt once for each registrant, instead of each additional participants individual confirmation.

[websitesRevolt]

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:

Code: [Select]

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']"]
)


[websitesRevolt]

nm seems to have been fixed by re-creating the profile the event was using