API tools faq
paste
Guest User

DB Error

a guest
Apr 18th, 2018
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.87 KB | None | 0 0
raw download clone embed print report
  1. Database Error Code: Can't group on 'participant_register_date', 1056
  2. Additional Details:
  3. Array
  4. (
  5. [callback] => Array
  6. (
  7. [0] => CRM_Core_Error
  8. [1] => handle
  9. )
  10.  
  11. [code] => -1
  12. [message] => DB Error: unknown error
  13. [mode] => 16
  14. [debug_info] => 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
  15. 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)
  16. 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']
  17. [type] => DB_Error
  18. [user_info] => 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
  19. 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)
  20. 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']
  21. [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="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
  22. 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)
  23. 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']"]
  24. )
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!