Lead view fails after tagging email

Hi,

Just experience a fairly rare issue, not used to reporting these things so let me know if you need anything else.

I just attached an email (from Gmail) to a lead - nothing I’ve not done before.
When viewing the lead it fails to render the whole page and outputs this to the log:
Maybe of relevance: recently upgraded to Version 7.11.6 from 7.11.0
PHP 7.1.30-1+ubuntu18.04.1

Thu Jul 11 12:32:32 2019 [1433][1][FATAL] Mysqli_query failed.
Thu Jul 11 12:32:32 2019 [1433][1][FATAL] Error retrieving Lead list:  Query Failed: (SELECT meetings.id ,  meetings.assigned_user_id  ,  meetings.name ,  meetings.status ,  '                                                                                                                                                                                                                                                              ' contact_name ,  '                                    '  contact_id ,  meetings.date_modified ,  meetings.date_entered ,  meetings.date_end  as date_due  ,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  0 reply_to_status ,  '                                                                                                                                                                                                                                                              ' contact_name_owner ,  '                                                                                                                                                                                                                                                              ' contact_name_mod ,  meetings.parent_id ,  meetings.parent_type ,  '                                                                                                                                                                                                                                                              ' filename ,  meetings.recurring_source ,  '                                                                                                                                                                                                                                                              ' assigned_user_owner ,  '                                                                                                                                                                                                                                                              ' assigned_user_mod ,  meetings.created_by  ,  'meetings' panel_name, NULL date_end, NULL category_id  FROM meetings  LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c   LEFT JOIN  users jt1 ON meetings.assigned_user_id=jt1.id AND jt1.deleted=0

 AND jt1.deleted=0 INNER JOIN  meetings_leads ON meetings.id=meetings_leads.meeting_id AND meetings_leads.lead_id='a7f936e0-b48b-feae-2c0d-5c8288103104' AND meetings_leads.deleted=0

  where ((meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0) UNION ALL ( SELECT meetings.id ,  meetings.assigned_user_id  ,  meetings.name ,  meetings.status ,  '                                                                                                                                                                                                                                                              ' contact_name ,  '                                    '  contact_id ,  meetings.date_modified ,  meetings.date_entered ,  meetings.date_end  as date_due  ,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  0 reply_to_status ,  '                                                                                                                                                                                                                                                              ' contact_name_owner ,  '                                                                                                                                                                                                                                                              ' contact_name_mod ,  meetings.parent_id ,  meetings.parent_type ,  '                                                                                                                                                                                                                                                              ' filename ,  meetings.recurring_source ,  '                                                                                                                                                                                                                                                              ' assigned_user_owner ,  '                                                                                                                                                                                                                                                              ' assigned_user_mod ,  meetings.created_by  ,  'oldmeetings' panel_name, NULL date_end, NULL category_id  FROM meetings  LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c   LEFT JOIN  users jt1 ON meetings.assigned_user_id=jt1.id AND jt1.deleted=0

 AND jt1.deleted=0  where ( meetings.parent_id = 'a7f936e0-b48b-feae-2c0d-5c8288103104'
            AND meetings.parent_type = 'Leads' AND meetings.id NOT IN ( SELECT meeting_id FROM meetings_leads )  AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id ,  tasks.assigned_user_id  ,  tasks.name ,  tasks.status  ,  LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name ,  tasks.contact_id  ,  tasks.date_modified ,  tasks.date_entered , NULL date_due,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  0 reply_to_status ,  '                                                                                                                                                                                                                                                              ' contact_name_owner ,  '                                                                                                                                                                                                                                                              ' contact_name_mod ,  tasks.parent_id ,  tasks.parent_type ,  '                                                                                                                                                                                                                                                              ' filename , NULL recurring_source,  '                                                                                                                                                                                                                                                              ' assigned_user_owner ,  '                                                                                                                                                                                                                                                              ' assigned_user_mod ,  tasks.created_by  ,  'tasks' panel_name,  tasks.date_end  , NULL category_id  FROM tasks   LEFT JOIN  contacts contacts ON tasks.contact_id=contacts.id AND contacts.deleted=0

 AND contacts.deleted=0  LEFT JOIN  users jt1 ON tasks.assigned_user_id=jt1.id AND jt1.deleted=0

 AND jt1.deleted=0 INNER JOIN  leads tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
 AND tasks.parent_type = 'Leads'
  where ( tasks.parent_id='a7f936e0-b48b-feae-2c0d-5c8288103104' AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id ,  calls.assigned_user_id  ,  calls.name ,  calls.status ,  '                                                                                                                                                                                                                                                              ' contact_name ,  '                                    '  contact_id ,  calls.date_modified ,  calls.date_entered ,  calls.date_end  as date_due  ,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  0 reply_to_status ,  '                                                                                                                                                                                                                                                              ' contact_name_owner ,  '                                                                                                                                                                                                                                                              ' contact_name_mod ,  calls.parent_id ,  calls.parent_type ,  '                                                                                                                                                                                                                                                              ' filename ,  calls.recurring_source ,  '                                                                                                                                                                                                                                                              ' assigned_user_owner ,  '                                                                                                                                                                                                                                                              ' assigned_user_mod ,  calls.created_by  ,  'calls' panel_name, NULL date_end, NULL category_id  FROM calls   LEFT JOIN  users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

 AND jt1.deleted=0 INNER JOIN  calls_leads ON calls.id=calls_leads.call_id AND calls_leads.lead_id='a7f936e0-b48b-feae-2c0d-5c8288103104' AND calls_leads.deleted=0

  where ((calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT calls.id ,  calls.assigned_user_id  ,  calls.name ,  calls.status ,  '                                                                                                                                                                                                                                                              ' contact_name ,  '                                    '  contact_id ,  calls.date_modified ,  calls.date_entered ,  calls.date_end  as date_due  ,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  0 reply_to_status ,  '                                                                                                                                                                                                                                                              ' contact_name_owner ,  '                                                                                                                                                                                                                                                              ' contact_name_mod ,  calls.parent_id ,  calls.parent_type ,  '                                                                                                                                                                                                                                                              ' filename ,  calls.recurring_source ,  '                                                                                                                                                                                                                                                              ' assigned_user_owner ,  '                                                                                                                                                                                                                                                              ' assigned_user_mod ,  calls.created_by  ,  'oldcalls' panel_name, NULL date_end, NULL category_id  FROM calls   LEFT JOIN  users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

 AND jt1.deleted=0  where ( calls.parent_id = 'a7f936e0-b48b-feae-2c0d-5c8288103104'
            AND calls.parent_type = 'Leads' AND calls.id NOT IN ( SELECT call_id FROM calls_leads )  AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT notes.id ,  notes.assigned_user_id  ,  notes.name ,  '                                                                                                                                                                                                                                                              ' status  ,  LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name ,  notes.contact_id  ,  notes.date_modified ,  notes.date_entered  , NULL date_due,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  0 reply_to_status ,  '                                                                                                                                                                                                                                                              ' contact_name_owner ,  '                                                                                                                                                                                                                                                              ' contact_name_mod ,  notes.parent_id ,  notes.parent_type ,  notes.filename , NULL recurring_source,  '                                                                                                                                                                                                                                                              ' assigned_user_owner ,  '                                                                                                                                                                                                                                                              ' assigned_user_mod ,  notes.created_by  ,  'notes' panel_name, NULL date_end, NULL category_id  FROM notes   LEFT JOIN  contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0

 AND contacts.deleted=0  LEFT JOIN  users jt1 ON notes.assigned_user_id=jt1.id AND jt1.deleted=0

 AND jt1.deleted=0 INNER JOIN  leads notes_rel ON notes.parent_id=notes_rel.id AND notes_rel.deleted=0
 AND notes.parent_type = 'Leads'
  where ( notes.parent_id='a7f936e0-b48b-feae-2c0d-5c8288103104') AND notes.deleted=0 ) UNION ALL ( SELECT emails.id ,  emails.assigned_user_id  ,  emails.name ,  emails.status ,  '                                                                                                                                                                                                                                                              ' contact_name ,  '                                                                                                                                                                                                                                                              ' contact_id ,  emails.date_modified ,  emails.date_entered  , NULL date_due,  jt0.user_name assigned_user_name ,  jt0.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  emails.reply_to_status ,  '                                                                                                                                                                                                                                                              ' contact_name_owner ,  '                                                                                                                                                                                                                                                              ' contact_name_mod ,  emails.parent_id ,  emails.parent_type ,  '                                                                                                                                                                                                                                                              ' filename , NULL recurring_source,  '                                                                                                                                                                                                                                                              ' assigned_user_owner ,  '                                                                                                                                                                                                                                                              ' assigned_user_mod ,  emails.created_by  ,  'emails' panel_name, NULL date_end,  emails.category_id   FROM emails   LEFT JOIN  users jt0 ON emails.assigned_user_id=jt0.id AND jt0.deleted=0

 AND jt0.deleted=0 INNER JOIN  emails_beans ON emails.id=emails_beans.email_id AND emails_beans.bean_id='a7f936e0-b48b-feae-2c0d-5c8288103104' AND emails_beans.deleted=0
 AND emails_beans.bean_module = 'Leads'
  where emails.deleted=0 ) UNION ALL ( SELECT emails.id ,  emails.assigned_user_id  ,  emails.name ,  emails.status ,  '                                                                                                                                                                                                                                                              ' contact_name ,  '                                                                                                                                                                                                                                                              ' contact_id ,  emails.date_modified ,  emails.date_entered  , NULL date_due,  jt0.user_name assigned_user_name ,  jt0.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  emails.reply_to_status ,  '                                                                                                                                                                                                                                                              ' contact_name_owner ,  '                                                                                                                                                                                                                                                              ' contact_name_mod ,  emails.parent_id ,  emails.parent_type ,  '                                                                                                                                                                                                                                                              ' filename , NULL recurring_source,  '                                                                                                                                                                                                                                                              ' assigned_user_owner ,  '                                                                                                                                                                                                                                                              ' assigned_user_mod ,  emails.created_by  ,  'linkedemails' panel_name, NULL date_end,  emails.category_id   FROM emails   LEFT JOIN  users jt0 ON emails.assigned_user_id=jt0.id AND jt0.deleted=0

 AND jt0.deleted=0 JOIN (select DISTINCT email_id from emails_email_addr_rel eear

	join email_addr_bean_rel eabr on eabr.bean_id ='a7f936e0-b48b-feae-2c0d-5c8288103104' and eabr.bean_module = 'Leads' and
	eabr.email_address_id = eear.email_address_id and eabr.deleted=0
	where eear.deleted=0 and eear.email_id not in
	(select eb.email_id from emails_beans eb where eb.bean_module ='Leads' and eb.bean_id = 'a7f936e0-b48b-feae-2c0d-5c8288103104')
	) derivedemails on derivedemails.email_id = emails.id  where emails.deleted=0 ) ORDER BY date_entered desc LIMIT 0,10: MySQL error 1054: Unknown column 'tasks.date_end' in 'field list'
Thu Jul 11 12:32:32 2019 [1433][1][FATAL] Exception handling in /var/www/crm/include/MVC/Controller/SugarController.php:400
Thu Jul 11 12:32:32 2019 [1433][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Jul 11 12:32:32 2019 [1433][1][FATAL] backtrace:
#0 /var/www/crm/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /var/www/crm/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'Error retrievin...', true)
#2 /var/www/crm/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true)
#3 /var/www/crm/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT meeting...', true, 'Error retrievin...')
#4 /var/www/crm/data/SugarBean.php(1286): MysqlManager->limitQuery('(SELECT meeting...', 0, 10, true, 'Error retrievin...')
#5 /var/www/crm/data/SugarBean.php(1017): SugarBean->process_union_list_query(Object(Lead), '(SELECT meeting...', 0, 10, 10, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /var/www/crm/include/ListView/ListView.php(1151): SugarBean::get_union_related_list(Object(Lead), 'date_entered de...', 'desc', '', 0, -1, 10, '', Object(aSubPanel))
#7 /var/www/crm/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Lead), Object(aSubPanel), 'history_CELL', false)
#8 /var/www/crm/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Leads', Object(Lead), Object(aSubPanel), false)
#9 /var/www/crm/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)
#10 /var/www/crm/include/MVC/View/SugarView.php(1191): SubPanelTiles->display()
#11 /var/www/crm/include/MVC/View/SugarView.php(255): SugarView->_displaySubPanels()
#12 /var/www/crm/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /var/www/crm/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /var/www/crm/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /var/www/crm/index.php(52): SugarApplication->execute()
#16 {main}

Just noticed also getting regular : [ERROR] ImapHandler trying to use a non valid resource stream.

Have a look here

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

maybe the fix proposed there will work for you

1 Like

This appears to have helped thanks.