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}