#10 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()
#11 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels()
#12 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /var/www/vhosts/midominio.es/app.midominio.es/index.php(52): SugarApplication->execute()
#16 {main}
Thu Sep 20 09:54:40 2018 [29098][1][FATAL] log call at: modules/Administration/index.tpl:53 - MY_FRAME is not set
Thu Sep 20 09:54:52 2018 [29098][1][FATAL] log call at: modules/Administration/index.tpl:53 - MY_FRAME is not set
Thu Sep 20 09:54:56 2018 [29098][1][FATAL] Mysqli_query failed.
Thu Sep 20 09:54:56 2018 [29098][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_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, ’ ’ contact_name_owner , ’ ’ contact_name_mod , meetings.recurring_source , meetings.created_by , ‘meetings’ panel_name 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=‘987709fe-13a0-9a6f-3a06-58b5567ece99’ AND meetings_leads.deleted=0
where ((meetings.status !=‘Held’ AND 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_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, ’ ’ contact_name_owner , ’ ’ contact_name_mod , meetings.recurring_source , meetings.created_by , ‘oldmeetings’ panel_name 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 = ‘987709fe-13a0-9a6f-3a06-58b5567ece99’
AND meetings.parent_type = ‘Leads’ AND meetings.id NOT IN ( SELECT meeting_id FROM meetings_leads ) AND (meetings.status !=‘Held’ AND 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 , NULL date_due, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, ’ ’ contact_name_owner , ’ ’ contact_name_mod , NULL recurring_source, tasks.created_by , ‘tasks’ panel_name 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=‘987709fe-13a0-9a6f-3a06-58b5567ece99’ AND (tasks.status != ‘Completed’ AND 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_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, ’ ’ contact_name_owner , ’ ’ contact_name_mod , calls.recurring_source , calls.created_by , ‘calls’ panel_name 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=‘987709fe-13a0-9a6f-3a06-58b5567ece99’ AND calls_leads.deleted=0
where ((calls.status != ‘Held’ AND 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_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, ’ ’ contact_name_owner , ’ ’ contact_name_mod , calls.recurring_source , calls.created_by , ‘oldcalls’ panel_name 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 = ‘987709fe-13a0-9a6f-3a06-58b5567ece99’
AND calls.parent_type = ‘Leads’ AND calls.id NOT IN ( SELECT call_id FROM calls_leads ) AND (calls.status != ‘Held’ AND calls.status != ‘Not Held’)) AND calls.deleted=0 ) ORDER BY date_start desc LIMIT 0,10: MySQL error 1054: Unknown column ‘date_start’ in ‘order clause’
Thu Sep 20 09:54:56 2018 [29098][1][FATAL] Exception handling in /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/Controller/SugarController.php:400
Thu Sep 20 09:54:56 2018 [29098][1][FATAL] Exception in Controller: Error de base de datos. Por favor, consulte SuiteCRM error .log para más detalles.
Thu Sep 20 09:54:56 2018 [29098][1][FATAL] backtrace:
#0 /var/www/vhosts/midominio.es/app.midominio.es/include/database/DBManager.php(353): sugar_die(‘Error de base d…’)
#1 /var/www/vhosts/midominio.es/app.midominio.es/include/database/DBManager.php(328): DBManager->registerError(‘Error retrievin…’, ‘Error retrievin…’, true)
#2 /var/www/vhosts/midominio.es/app.midominio.es/include/database/MysqliManager.php(179): DBManager->checkError(‘Error retrievin…’, true)
#3 /var/www/vhosts/midominio.es/app.midominio.es/include/database/MysqlManager.php(285): MysqliManager->query(’(SELECT meeting…’, true, ‘Error retrievin…’)
#4 /var/www/vhosts/midominio.es/app.midominio.es/data/SugarBean.php(1284): MysqlManager->limitQuery(’(SELECT meeting…’, 0, 10, true, ‘Error retrievin…’)
#5 /var/www/vhosts/midominio.es/app.midominio.es/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(Lead), ‘(SELECT meeting…’, 0, 10, 10, ‘’, Object(aSubPanel), ‘( SELECT count(…’, Array)
#6 /var/www/vhosts/midominio.es/app.midominio.es/include/ListView/ListView.php(1132): SugarBean::get_union_related_list(Object(Lead), ‘date_start desc’, ‘desc’, ‘’, 0, -1, 10, ‘’, Object(aSubPanel))
#7 /var/www/vhosts/midominio.es/app.midominio.es/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Lead), Object(aSubPanel), ‘activities_CELL’)
#8 /var/www/vhosts/midominio.es/app.midominio.es/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview(‘Leads’, Object(Lead), Object(aSubPanel))
#9 /var/www/vhosts/midominio.es/app.midominio.es/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView(‘include/SubPane…’, Array)
#10 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()
#11 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels()
#12 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /var/www/vhosts/midominio.es/app.midominio.es/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /var/www/vhosts/midominio.es/app.midominio.es/index.php(52): SugarApplication->execute()
#16 {main}
Thu Sep 20 11:55:01 2018 [29106][1][FATAL] Mysqli_query failed.
Thu Sep 20 11:55:01 2018 [29106][1][FATAL] Query Failed: SELECT calls.id AS id FROM calls WHERE calls.date_start < DATE_ADD(calls., INTERVAL ) AND calls.date_start > DATE_ADD(calls., INTERVAL ) AND calls.status != ‘Held’ AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id=‘9eae70a2-d055-175c-a4d1-56a6319fc08a’ AND aow_processed.parent_id=calls.id AND aow_processed.status = ‘Complete’ AND aow_processed.deleted = 0) AND calls.deleted = 0 : MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ’ INTERVAL ) AND calls.date_start > DATE_ADD(calls., INTERVAL ) AND calls.sta’ at line 1