Menu
Welcome, Guest
Username: Password: Remember me

TOPIC: Lead view fails after tagging email

Lead view fails after tagging email 3 months 1 week ago #87005

  • JoeDredd
  • JoeDredd's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
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.
The administrator has disabled public write access.

Lead view fails after tagging email 3 months 1 week ago #87023

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 11152
  • Thank you received: 1670
  • Karma: 380
Have a look here

github.com/salesagility/SuiteCRM/issues/7267

maybe the fix proposed there will work for you

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: JoeDredd

Lead view fails after tagging email 3 months 1 day ago #87431

  • JoeDredd
  • JoeDredd's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
This appears to have helped thanks.
The administrator has disabled public write access.
Time to create page: 0.060 seconds
Powered by Kunena Forum