Same problem here.
PHP 5.6 and 7.1
It showing up for me in the Project and Project Task pages after a task is updated. Projects and tasks that don’t have any new changes seem to show up fine.
Here’s the full error from sugarcrm.log for a Project…
Mon May 6 16:54:47 2019 [1634868][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] Mysqli_query failed.
Mon May 6 16:54:47 2019 [1634868][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] Error retrieving Project 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 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 project meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0
AND meetings.parent_type = 'Project'
where ( meetings.parent_id='d5540060-0175-0932-0024-56f18d7afbc9' AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.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 FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN project calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0
AND calls.parent_type = 'Project'
where ( calls.parent_id='d5540060-0175-0932-0024-56f18d7afbc9' AND (calls.status='Held' OR calls.status='Not Held')) AND calls.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 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 project tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = 'Project'
where ( tasks.parent_id='d5540060-0175-0932-0024-56f18d7afbc9' AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.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 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 project notes_rel ON notes.parent_id=notes_rel.id AND notes_rel.deleted=0
AND notes.parent_type = 'Project'
where ( notes.parent_id='d5540060-0175-0932-0024-56f18d7afbc9') 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 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='d5540060-0175-0932-0024-56f18d7afbc9' AND emails_beans.deleted=0
AND emails_beans.bean_module = 'Project'
where emails.deleted=0 ) ORDER BY date_entered desc LIMIT 0,100: MySQL error 1054: Unknown column 'tasks.date_end' in 'field list'
Mon May 6 16:54:47 2019 [1634868][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] Exception handling in /home/theperip/public_html/macula/include/MVC/Controller/SugarController.php:400
Mon May 6 16:54:47 2019 [1634868][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon May 6 16:54:47 2019 [1634868][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] backtrace:
#0 /home/theperip/public_html/macula/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /home/theperip/public_html/macula/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'MySQL error 105...', true)
#2 /home/theperip/public_html/macula/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true)
#3 /home/theperip/public_html/macula/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT meeting...', true, 'Error retrievin...')
#4 /home/theperip/public_html/macula/data/SugarBean.php(1286): MysqlManager->limitQuery('(SELECT meeting...', 0, 100, true, 'Error retrievin...')
#5 /home/theperip/public_html/macula/data/SugarBean.php(1018): SugarBean->process_union_list_query(Object(Project), '(SELECT meeting...', 0, -1, 100, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /home/theperip/public_html/macula/include/ListView/ListView.php(1152): SugarBean::get_union_related_list(Object(Project), 'date_entered', 'desc', '', 0, -1, 100, '', Object(aSubPanel))
#7 /home/theperip/public_html/macula/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Project), Object(aSubPanel), 'history_CELL', false)
#8 /home/theperip/public_html/macula/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Project', Object(Project), Object(aSubPanel), false)
#9 /home/theperip/public_html/macula/include/SubPanel/SubPanelTiles.php(358): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)
#10 /home/theperip/public_html/macula/include/MVC/View/SugarView.php(1191): SubPanelTiles->display()
#11 /home/theperip/public_html/macula/include/MVC/View/SugarView.php(255): SugarView->_displaySubPanels()
#12 /home/theperip/public_html/macula/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /home/theperip/public_html/macula/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /home/theperip/public_html/macula/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /home/theperip/public_html/macula/index.php(52): SugarApplication->execute()
#16 {main}
Here’s the full error from sugarcrm.log for a Project Task…
Tue May 7 08:34:15 2019 [1943875][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] Mysqli_query failed.
Tue May 7 08:34:15 2019 [1943875][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] Error retrieving ProjectTask 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 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 project_task meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0
AND meetings.parent_type = 'ProjectTask'
where ( meetings.parent_id='c332c7c2-5375-1a0d-0e28-5c337c6ca6bf' 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 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 project_task tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = 'ProjectTask'
where ( tasks.parent_id='c332c7c2-5375-1a0d-0e28-5c337c6ca6bf' 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 FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN project_task calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0
AND calls.parent_type = 'ProjectTask'
where ( calls.parent_id='c332c7c2-5375-1a0d-0e28-5c337c6ca6bf' 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 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 project_task notes_rel ON notes.parent_id=notes_rel.id AND notes_rel.deleted=0
AND notes.parent_type = 'ProjectTask'
where ( notes.parent_id='c332c7c2-5375-1a0d-0e28-5c337c6ca6bf') 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 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='c332c7c2-5375-1a0d-0e28-5c337c6ca6bf' AND emails_beans.deleted=0
AND emails_beans.bean_module = 'ProjectTask'
where emails.deleted=0 ) ORDER BY date_entered desc LIMIT 0,100: MySQL error 1054: Unknown column 'tasks.date_end' in 'field list'
Tue May 7 08:34:15 2019 [1943875][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] Exception handling in /home/theperip/public_html/macula/include/MVC/Controller/SugarController.php:400
Tue May 7 08:34:15 2019 [1943875][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Tue May 7 08:34:15 2019 [1943875][a90eeb47-6353-ad30-24ee-4464c2afb170][FATAL] backtrace:
#0 /home/theperip/public_html/macula/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /home/theperip/public_html/macula/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'MySQL error 105...', true)
#2 /home/theperip/public_html/macula/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true)
#3 /home/theperip/public_html/macula/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT meeting...', true, 'Error retrievin...')
#4 /home/theperip/public_html/macula/data/SugarBean.php(1286): MysqlManager->limitQuery('(SELECT meeting...', 0, 100, true, 'Error retrievin...')
#5 /home/theperip/public_html/macula/data/SugarBean.php(1018): SugarBean->process_union_list_query(Object(ProjectTask), '(SELECT meeting...', 0, -1, 100, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /home/theperip/public_html/macula/include/ListView/ListView.php(1152): SugarBean::get_union_related_list(Object(ProjectTask), 'date_entered', 'desc', '', 0, -1, 100, '', Object(aSubPanel))
#7 /home/theperip/public_html/macula/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(ProjectTask), Object(aSubPanel), 'history_CELL', false)
#8 /home/theperip/public_html/macula/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('ProjectTask', Object(ProjectTask), Object(aSubPanel), false)
#9 /home/theperip/public_html/macula/include/SubPanel/SubPanelTiles.php(358): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)
#10 /home/theperip/public_html/macula/include/MVC/View/SugarView.php(1191): SubPanelTiles->display()
#11 /home/theperip/public_html/macula/include/MVC/View/SugarView.php(255): SugarView->_displaySubPanels()
#12 /home/theperip/public_html/macula/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /home/theperip/public_html/macula/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /home/theperip/public_html/macula/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /home/theperip/public_html/macula/index.php(52): SugarApplication->execute()
#16 {main}
Thanks,
•• matt