Event Module Not Showing Delegates List

Hello,

When I add a lead to an event, I can see the event listed in lead details page, at the events subpanel. However, when go to event details, delegates subpanel says no results found. Any ideas how I can see the list of delegates in the subpanel.

Thanks

Is this the same?

https://github.com/salesagility/SuiteCRM/issues/2106

1 Like

Just for info :

I suspect this module “Events / Locations” have many many bug in next release.

All users of suitecrm must be “prepared” for this “source of problem” in futur release of SuiteCRM.

My case is different. I don’t see delegates subpanel at all. See the attached image.

@item, why do you predict problems with that module?

1 Like

Did you make any customizations in Studio that might have caused this subpanel do go away?

Or any Security Settings?

Try a Quick Repair and Rebuild, and a Rebuild Relationships.

You can always check your logs for any clues at the moment that screen loads.

1 Like

I realized that when I create a new event with no contacts added, delegates subpanel shows. But when I add a contact to the event, it disappears.

I did not change anything for events module in the studio.

I may customize security settings some time ago, but the module worked then.

I did many quick repairs and rebuilds, no avail.

I did not check logs before, there are two fatal errors. I copy pasted them below. Any idea how I can fix them

Thu Sep 21 20:15:08 2017 [183458][1][FATAL] Error retrieving FP_events list: Query Failed: (SELECT contacts.id , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) as name, ’ ’ account_name , ’ ’ account_id , contacts.phone_work , ’ ’ e_accept_status_fields , ’ ’ fp_events_contactsfp_events_ida , ’ ’ e_invite_status_fields , contacts.first_name , contacts.last_name , contacts.salutation , contacts.assigned_user_id , ‘contacts’ panel_name, NULL fp_events_prospects_1fp_events_ida, NULL fp_events_leads_1fp_events_ida FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c INNER JOIN fp_events_contacts_c ON contacts.id=fp_events_contacts_c.fp_events_contactscontacts_idb AND fp_events_contacts_c.fp_events_contactsfp_events_ida=‘cfdc4a80-1716-7ce9-e56a-59bfa9de8061’ AND fp_events_contacts_c.deleted=0

where contacts.deleted=0) UNION ALL ( SELECT prospects.id , LTRIM(RTRIM(CONCAT(IFNULL(prospects.first_name,’’),’ ‘,IFNULL(prospects.last_name,’’)))) as name, prospects.account_name , NULL account_id, prospects.phone_work , ’ ’ e_accept_status_fields , NULL fp_events_contactsfp_events_ida, ’ ’ e_invite_status_fields , prospects.first_name , prospects.last_name , prospects.salutation , prospects.assigned_user_id , ‘prospects’ panel_name, ’ ’ fp_events_prospects_1fp_events_ida , NULL fp_events_leads_1fp_events_ida FROM prospects LEFT JOIN prospects_cstm ON prospects.id = prospects_cstm.id_c INNER JOIN fp_events_prospects_1_c ON prospects.id=fp_events_prospects_1_c.fp_events_prospects_1prospects_idb AND fp_events_prospects_1_c.fp_events_prospects_1fp_events_ida=‘cfdc4a80-1716-7ce9-e56a-59bfa9de8061’ AND fp_events_prospects_1_c.deleted=0

where prospects.deleted=0 ) UNION ALL ( SELECT leads.id , LTRIM(RTRIM(CONCAT(IFNULL(leads.first_name,’’),’ ‘,IFNULL(leads.last_name,’’)))) as name, leads.account_name , leads.account_id , leads.phone_work , ’ ’ e_accept_status_fields , NULL fp_events_contactsfp_events_ida, ’ ’ e_invite_status_fields , leads.first_name , leads.last_name , leads.salutation , leads.assigned_user_id , ‘leads’ panel_name, NULL fp_events_prospects_1fp_events_ida, ’ ’ fp_events_leads_1fp_events_ida FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c INNER JOIN fp_events_leads_1_c ON leads.id=fp_events_leads_1_c.fp_events_leads_1leads_idb AND fp_events_leads_1_c.fp_events_leads_1fp_events_ida=‘cfdc4a80-1716-7ce9-e56a-59bfa9de8061’ AND fp_events_leads_1_c.deleted=0

where leads.deleted=0 ) ORDER BY id desc LIMIT 0,10: MySQL error 1271: Illegal mix of collations for operation ‘UNION’

Thu Sep 21 20:15:08 2017 [183458][1][FATAL] Exception handling in /home/fidekayi/public_html/include/MVC/Controller/SugarController.php:397
Thu Sep 21 20:15:08 2017 [183458][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Sep 21 20:15:08 2017 [183458][1][FATAL] backtrace:
#0 /home/fidekayi/public_html/include/database/DBManager.php(345): sugar_die(‘Database failur…’)
#1 /home/fidekayi/public_html/include/database/DBManager.php(321): DBManager->registerError(‘Error retrievin…’, ‘Error retrievin…’, true)
#2 /home/fidekayi/public_html/include/database/MysqliManager.php(160): DBManager->checkError(‘Error retrievin…’, true)
#3 /home/fidekayi/public_html/include/database/MysqlManager.php(277): MysqliManager->query(’(SELECT contact…’, true, ‘Error retrievin…’)
#4 /home/fidekayi/public_html/data/SugarBean.php(1095): MysqlManager->limitQuery(’(SELECT contact…’, 0, 10, true, ‘Error retrievin…’)
#5 /home/fidekayi/public_html/data/SugarBean.php(915): SugarBean->process_union_list_query(Object(FP_events), ‘(SELECT contact…’, 0, 10, 10, ‘’, Object(aSubPanel), ‘( SELECT count(…’, Array)
#6 /home/fidekayi/public_html/include/ListView/ListView.php(1102): SugarBean::get_union_related_list(Object(FP_events), ‘id desc’, ‘desc’, ‘’, 0, -1, 10, ‘’, Object(aSubPanel))
#7 /home/fidekayi/public_html/include/ListView/ListViewSubPanel.php(141): ListView->processUnionBeans(Object(FP_events), Object(aSubPanel), ‘delegates_CELL’)
#8 /home/fidekayi/public_html/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview(‘FP_events’, Object(FP_events), Object(aSubPanel))
#9 /home/fidekayi/public_html/include/SubPanel/SubPanelTiles.php(366): SubPanel->ProcessSubPanelListView(‘include/SubPane…’, Array)
#10 /home/fidekayi/public_html/include/MVC/View/SugarView.php(1144): SubPanelTiles->display()
#11 /home/fidekayi/public_html/include/MVC/View/SugarView.php(215): SugarView->_displaySubPanels()
#12 /home/fidekayi/public_html/include/MVC/Controller/SugarController.php(427): SugarView->process()
#13 /home/fidekayi/public_html/include/MVC/Controller/SugarController.php(370): SugarController->processView()
#14 /home/fidekayi/public_html/include/MVC/SugarApplication.php(105): SugarController->execute()
#15 /home/fidekayi/public_html/index.php(52): SugarApplication->execute()
#16 {main}

Hi,
Why ? Simply my experiment. What you do for out-of-box module easily don’t work for “fp_events” modules.

This module is great (thanks to the developper) but it is bad coded and no respect SugarCrm/SuiteCRM coding requirement in next futur release.
Coding Requirement is now a big change with new release of SuiteCRM. (New API, PHP requirement, Coding rules,…)

In my experiment, I have try to create a new “customController” for Events module, and this not work because “upercase/lowercase” (I think ). My solution is copy the entire file in custom module and change there.
Some “SuiteCRM” include don’t work in these 2 modules. Then all custom “code” don’t work. After that, imagine with php7 minimum.

Regards.

1 Like

The key word in that big error is “collations”. You can solve your problem by fixing your MySQL configurations of “collations” which is related to character codepages and languages.

Google for solutions with that keyword and you will find something. Good luck