参加者を検索する際のエラー

I got the following fatal error in the “Find Participants” page
(Events > Find Participants), when I click on the Search button
:

enter image description here

私のウェブサイトは、WordPressバージョン4.9.5とPHP 7.0とMySQL 5.7を使用しています。
この問題は、CiviCRM
5.0.0,5.0.1および5.0.2のバージョンで発生しているようです。私はバージョン5.0.0より前のこの問題を見たことがありません。

エラーログのSQLコード:

SELECT

GROUP_CONCAT(DISTINCT contact_a.id) as contact_id, 
GROUP_CONCAT(DISTINCT contact_a.contact_type) as `contact_type`, 
GROUP_CONCAT(DISTINCT contact_a.contact_sub_type) as `contact_sub_type`, 
GROUP_CONCAT(DISTINCT contact_a.sort_name) as `sort_name`, 
GROUP_CONCAT(DISTINCT contact_a.display_name) as `display_name`, 
GROUP_CONCAT(DISTINCT civicrm_event.id) as event_id, 
GROUP_CONCAT(DISTINCT civicrm_event.title) as event_title, 
GROUP_CONCAT(DISTINCT civicrm_event.start_date) as event_start_date, 
GROUP_CONCAT(DISTINCT civicrm_event.end_date) as event_end_date, 
GROUP_CONCAT(DISTINCT civicrm_event.default_role_id) as `default_role_id`, 
civicrm_participant.id as participant_id, 
GROUP_CONCAT(DISTINCT civicrm_participant.fee_level) as participant_fee_level, 
GROUP_CONCAT(DISTINCT civicrm_participant.fee_amount) as participant_fee_amount, 
GROUP_CONCAT(DISTINCT civicrm_participant.fee_currency) as participant_fee_currency, 
GROUP_CONCAT(DISTINCT event_type.label) as event_type, 
GROUP_CONCAT(DISTINCT civicrm_participant.status_id) as participant_status_id, 
GROUP_CONCAT(DISTINCT participant_status.label) as participant_status, 
GROUP_CONCAT(DISTINCT civicrm_participant.role_id) as participant_role_id, 
GROUP_CONCAT(DISTINCT civicrm_participant.role_id) as participant_role, 
GROUP_CONCAT(DISTINCT civicrm_participant.register_date) as participant_register_date, 
GROUP_CONCAT(DISTINCT civicrm_participant.source) as participant_source, 
GROUP_CONCAT(DISTINCT civicrm_note.note) as participant_note, 
GROUP_CONCAT(DISTINCT civicrm_participant.is_pay_later) as participant_is_pay_later, 
GROUP_CONCAT(DISTINCT civicrm_participant.is_test) as participant_is_test, 
GROUP_CONCAT(DISTINCT civicrm_participant.registered_by_id) as participant_registered_by_id, 
GROUP_CONCAT(DISTINCT discount_name.title) as participant_discount_name, 
GROUP_CONCAT(DISTINCT 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  
    LEFT 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.price_set_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 
            OR SUBSTRING_INDEX(role_id,'', 1) = 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_participant.is_test = 0 )  
  AND       (contact_a.is_deleted = 0)   

GROUP BY    civicrm_participant.id,  
            participant_register_date desc,  
            contact_a.id  

ORDER BY    `participant_register_date` desc, 
            `contact_a`.`id`  

LIMIT 0, 50  

エラー :

[nativecode=1056 ** Can't group on 'participant_register_date']

私はこのコードをphpmyadminでテストしましたが、
civicrm_participant.register_dateGROUP
BY
participant_register_date
を置き換えたときに動作しますファイル私は修正を行うためにcivicrmで変更する必要があります…

ご協力いただきありがとうございます!

ベストアンサー

ケビン、

This is a core bug and is fixed under https://github.com/civicrm/civicrm-core/pull/11996/files

HTH

Pradeep

コメントする

メールアドレスが公開されることはありません。 * が付いている欄は必須項目です