mirror of
https://github.com/SuiteCRM/SuiteCRM.git
synced 2026-03-02 19:16:58 -05:00
Accounts view broken on 7.10.9 #3358
Labels
No labels
Area: API
Area: Campaigns
Area: Cases
Area: Clean Up
Area: Clean Up: Performance
Area: Dashlets
Area: Databases
Area: Developer Tools
Area: Elasticsearch
Area: Elasticsearch
Area: Emails
Area: Emails:Campaigns
Area: Emails:Cases
Area: Emails:Compose
Area: Emails:Config
Area: Emails:Templates
Area: Environment
Area: Installation
Area: Language
Area: Mobile
Area: Module
Area: PDFs
Area: PHP8
Area: Reports
Area: Studio
Area: Styling
Area: Upgrading
Area: Workflow
Area:Activity Stream
Area:Calls
Area:Import
Area:Projects
Area:Search
Area:Surveys
Area:Themes
Area:Users
Branch:Hotfix
Good First Issue
Hacktoberfest
Help Wanted
PR:Community Contribution
PR:Type:Enhancement
Priority:Critical
Priority:Important
Priority:Moderate
Severity: Major
Severity: Minor
Severity: Moderate
Status: Requires Code Review
Status: Requires Updates
Status: Stale
Status: Team Investigating
Status:Assessed
Status:Fix Proposed
Status:Needs Assessed
Status:Requires Automated Tests
Type: Bug
Type:Deprecated
Type:Discussion
Type:Duplicate
Type:Invalid
Type:Question
Type:Suggestion
Type:Suggestion
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/SuiteCRM-SuiteCRM#3358
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @ghost on GitHub (Oct 16, 2018).
Issue
After upgrade to 7.10.9 some of accounts does not show any subpanels. I think it is somehow connected with calls related with account but I'm not certain if that's the case.
Accounts module have 3 custom fields but this should not be related with the case.
I can't reproduce problem on demo site.
Tue Oct 16 14:52:04 2018 [4667][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception handling in /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php:400
Tue Oct 16 14:52:04 2018 [4667][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception in Controller: Awaria bazy danych. Szczegóły zapisano w logu SuiteCRM.
Tue Oct 16 14:52:04 2018 [4667][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] backtrace:
#0 /var/www/crm.fortecait.pl/include/database/DBManager.php(353): sugar_die('Awaria bazy dan...')
#1 /var/www/crm.fortecait.pl/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'Error retrievin...', true)
#2 /var/www/crm.fortecait.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true)
#3 /var/www/crm.fortecait.pl/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT tasks.i...', true, 'Error retrievin...')
#4 /var/www/crm.fortecait.pl/data/SugarBean.php(1284): MysqlManager->limitQuery('(SELECT tasks.i...', 0, 10, true, 'Error retrievin...')
#5 /var/www/crm.fortecait.pl/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(Account), '(SELECT tasks.i...', 0, 10, 10, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /var/www/crm.fortecait.pl/include/ListView/ListView.php(1132): SugarBean::get_union_related_list(Object(Account), 'date_entered de...', 'desc', '', 0, -1, 10, '', Object(aSubPanel))
#7 /var/www/crm.fortecait.pl/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Account), Object(aSubPanel), 'history_CELL')
#8 /var/www/crm.fortecait.pl/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Accounts', Object(Account), Object(aSubPanel))
#9 /var/www/crm.fortecait.pl/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)
#10 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()
#11 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels()
#12 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /var/www/crm.fortecait.pl/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /var/www/crm.fortecait.pl/index.php(52): SugarApplication->execute()
#16 {main}
Tue Oct 16 14:52:16 2018 [4667][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Mysqli_query failed.
Tue Oct 16 14:52:16 2018 [4667][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Error retrieving Account list: Query Failed: (SELECT tasks.id , tasks.contact_id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , ' ' contact_name_owner , ' ' contact_name_mod , tasks.date_modified , tasks.date_entered , tasks.date_due 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 , tasks.parent_id , tasks.parent_type , ' ' filename , ' ' assigned_user_owner , ' ' assigned_user_mod , tasks.created_by , 'tasks' panel_name, NULL recurring_source, NULL category_id FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c 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 accounts tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = 'Accounts'
where ( tasks.parent_id='9a86077e-c456-1950-81df-581c5868fd96' AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.deleted=0) UNION ALL ( SELECT meetings.id , ' ' contact_id , meetings.assigned_user_id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_name_owner , ' ' contact_name_mod , 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 , meetings.parent_id , meetings.parent_type , ' ' filename , ' ' assigned_user_owner , ' ' assigned_user_mod , meetings.created_by , 'meetings' panel_name, meetings.recurring_source , 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 accounts meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0
AND meetings.parent_type = 'Accounts'
where ( meetings.parent_id='9a86077e-c456-1950-81df-581c5868fd96' AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT calls.id , ' ' contact_id , calls.assigned_user_id , calls.name , calls.status , ' ' contact_name , ' ' contact_name_owner , ' ' contact_name_mod , calls.date_modified , calls.date_entered , calls.date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, 0 reply_to_status , calls.parent_id , calls.parent_type , ' ' filename , ' ' assigned_user_owner , ' ' assigned_user_mod , calls.created_by , 'calls' panel_name, calls.recurring_source , NULL category_id 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 accounts calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0
AND calls.parent_type = 'Accounts'
where ( calls.parent_id='9a86077e-c456-1950-81df-581c5868fd96' AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT notes.id , notes.contact_id , notes.assigned_user_id , notes.name , ' ' status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , ' ' contact_name_owner , ' ' contact_name_mod , 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 , notes.parent_id , notes.parent_type , notes.filename , ' ' assigned_user_owner , ' ' assigned_user_mod , notes.created_by , 'notes' panel_name, NULL recurring_source, 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 accounts notes_rel ON notes.parent_id=notes_rel.id AND notes_rel.deleted=0
AND notes.parent_type = 'Accounts'
where ( notes.parent_id='9a86077e-c456-1950-81df-581c5868fd96') AND notes.deleted=0 ) UNION ALL ( SELECT DISTINCT emails.id , ' ' contact_id , emails.assigned_user_id , emails.name , emails.status , ' ' contact_name , ' ' contact_name_owner , ' ' contact_name_mod , 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 , emails.parent_id , emails.parent_type , ' ' filename , ' ' assigned_user_owner , ' ' assigned_user_mod , emails.created_by , 'emails' panel_name, NULL recurring_source, 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 (
SELECT
eb.email_id,
'direct' source
FROM
emails_beans eb
WHERE
eb.bean_module = 'Accounts'
AND eb.bean_id = '9a86077e-c456-1950-81df-581c5868fd96'
AND eb.deleted=0
UNION
SELECT DISTINCT
eear.email_id,
'relate' source
FROM
emails_email_addr_rel eear
INNER JOIN
email_addr_bean_rel eabr
ON
eabr.bean_id ='9a86077e-c456-1950-81df-581c5868fd96'
AND eabr.bean_module = 'Accounts'
AND eabr.email_address_id = eear.email_address_id
AND eabr.deleted=0
WHERE
eear.deleted=0
UNION
SELECT DISTINCT
eb.email_id,
'contact' source
FROM
emails_beans eb
INNER JOIN accounts_contacts linkt ON '9a86077e-c456-1950-81df-581c5868fd96'=linkt.account_id AND linkt.deleted=0
INNER JOIN contacts link_bean ON link_bean.id=linkt.contact_id AND link_bean.deleted=0
AND link_bean.id = eb.bean_id
WHERE
eb.bean_module = 'Contacts'
AND eb.deleted=0
UNION
SELECT DISTINCT
eear.email_id,
'relate_contact' source
FROM
emails_email_addr_rel eear
INNER JOIN
email_addr_bean_rel eabr
ON
eabr.email_address_id=eear.email_address_id
AND eabr.bean_module = 'Contacts'
AND eabr.deleted=0
INNER JOIN accounts_contacts linkt ON '9a86077e-c456-1950-81df-581c5868fd96'=linkt.account_id AND linkt.deleted=0
INNER JOIN contacts link_bean ON link_bean.id=linkt.contact_id AND link_bean.deleted=0
AND link_bean.id = eabr.bean_id
WHERE
eear.deleted=0
) email_ids ON emails.id=email_ids.email_id where ( emails.deleted=0 ) AND emails.deleted=0 ) ORDER BY date_entered desc LIMIT 0,10: MySQL error 1054: Unknown column 'calls.date_due' in 'field list'
Tue Oct 16 14:52:16 2018 [4667][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception handling in /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php:400
Tue Oct 16 14:52:16 2018 [4667][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception in Controller: Awaria bazy danych. Szczegóły zapisano w logu SuiteCRM.
Tue Oct 16 14:52:16 2018 [4667][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] backtrace:
#0 /var/www/crm.fortecait.pl/include/database/DBManager.php(353): sugar_die('Awaria bazy dan...')
#1 /var/www/crm.fortecait.pl/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'Error retrievin...', true)
#2 /var/www/crm.fortecait.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true)
#3 /var/www/crm.fortecait.pl/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT tasks.i...', true, 'Error retrievin...')
#4 /var/www/crm.fortecait.pl/data/SugarBean.php(1284): MysqlManager->limitQuery('(SELECT tasks.i...', 0, 10, true, 'Error retrievin...')
#5 /var/www/crm.fortecait.pl/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(Account), '(SELECT tasks.i...', 0, 10, 10, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /var/www/crm.fortecait.pl/include/ListView/ListView.php(1132): SugarBean::get_union_related_list(Object(Account), 'date_entered de...', 'desc', '', 0, -1, 10, '', Object(aSubPanel))
#7 /var/www/crm.fortecait.pl/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Account), Object(aSubPanel), 'history_CELL')
#8 /var/www/crm.fortecait.pl/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Accounts', Object(Account), Object(aSubPanel))
#9 /var/www/crm.fortecait.pl/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)
#10 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()
#11 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels()
#12 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /var/www/crm.fortecait.pl/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /var/www/crm.fortecait.pl/index.php(52): SugarApplication->execute()
#16 {main}
Tue Oct 16 14:52:30 2018 [4743][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Slow Query (time:0.55346608161926
SELECT accounts.id ,accounts_cstm.nip_c, accounts.assigned_user_id , accounts.name , accounts.account_type , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , accounts.annual_revenue , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, accounts.created_by FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON accounts.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 where (((accounts.name like '%grzelak%' ) OR ( accounts.phone_office like '%grzelak%' ) OR ( accounts.id IN (select bean_id from (SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE '%grzelak%%') email_derived) ) OR ( accounts_cstm.nip_c like '%grzelak%'))) AND accounts.deleted=0 LIMIT 0,11)
Tue Oct 16 14:53:17 2018 [4897][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Mysqli_query failed.
Tue Oct 16 14:53:17 2018 [4897][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Error retrieving Account list: Query Failed: (SELECT tasks.id , tasks.contact_id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , ' ' contact_name_owner , ' ' contact_name_mod , tasks.date_modified , tasks.date_entered , tasks.date_due 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 , tasks.parent_id , tasks.parent_type , ' ' filename , ' ' assigned_user_owner , ' ' assigned_user_mod , tasks.created_by , 'tasks' panel_name, NULL recurring_source, NULL category_id FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c 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 accounts tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = 'Accounts'
where ( tasks.parent_id='9a86077e-c456-1950-81df-581c5868fd96' AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.deleted=0) UNION ALL ( SELECT meetings.id , ' ' contact_id , meetings.assigned_user_id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_name_owner , ' ' contact_name_mod , 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 , meetings.parent_id , meetings.parent_type , ' ' filename , ' ' assigned_user_owner , ' ' assigned_user_mod , meetings.created_by , 'meetings' panel_name, meetings.recurring_source , 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 accounts meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0
AND meetings.parent_type = 'Accounts'
where ( meetings.parent_id='9a86077e-c456-1950-81df-581c5868fd96' AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT calls.id , ' ' contact_id , calls.assigned_user_id , calls.name , calls.status , ' ' contact_name , ' ' contact_name_owner , ' ' contact_name_mod , calls.date_modified , calls.date_entered , calls.date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, 0 reply_to_status , calls.parent_id , calls.parent_type , ' ' filename , ' ' assigned_user_owner , ' ' assigned_user_mod , calls.created_by , 'calls' panel_name, calls.recurring_source , NULL category_id 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 accounts calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0
AND calls.parent_type = 'Accounts'
where ( calls.parent_id='9a86077e-c456-1950-81df-581c5868fd96' AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT notes.id , notes.contact_id , notes.assigned_user_id , notes.name , ' ' status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , ' ' contact_name_owner , ' ' contact_name_mod , 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 , notes.parent_id , notes.parent_type , notes.filename , ' ' assigned_user_owner , ' ' assigned_user_mod , notes.created_by , 'notes' panel_name, NULL recurring_source, 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 accounts notes_rel ON notes.parent_id=notes_rel.id AND notes_rel.deleted=0
AND notes.parent_type = 'Accounts'
where ( notes.parent_id='9a86077e-c456-1950-81df-581c5868fd96') AND notes.deleted=0 ) UNION ALL ( SELECT DISTINCT emails.id , ' ' contact_id , emails.assigned_user_id , emails.name , emails.status , ' ' contact_name , ' ' contact_name_owner , ' ' contact_name_mod , 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 , emails.parent_id , emails.parent_type , ' ' filename , ' ' assigned_user_owner , ' ' assigned_user_mod , emails.created_by , 'emails' panel_name, NULL recurring_source, 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 (
SELECT
eb.email_id,
'direct' source
FROM
emails_beans eb
WHERE
eb.bean_module = 'Accounts'
AND eb.bean_id = '9a86077e-c456-1950-81df-581c5868fd96'
AND eb.deleted=0
UNION
SELECT DISTINCT
eear.email_id,
'relate' source
FROM
emails_email_addr_rel eear
INNER JOIN
email_addr_bean_rel eabr
ON
eabr.bean_id ='9a86077e-c456-1950-81df-581c5868fd96'
AND eabr.bean_module = 'Accounts'
AND eabr.email_address_id = eear.email_address_id
AND eabr.deleted=0
WHERE
eear.deleted=0
UNION
SELECT DISTINCT
eb.email_id,
'contact' source
FROM
emails_beans eb
INNER JOIN accounts_contacts linkt ON '9a86077e-c456-1950-81df-581c5868fd96'=linkt.account_id AND linkt.deleted=0
INNER JOIN contacts link_bean ON link_bean.id=linkt.contact_id AND link_bean.deleted=0
AND link_bean.id = eb.bean_id
WHERE
eb.bean_module = 'Contacts'
AND eb.deleted=0
UNION
SELECT DISTINCT
eear.email_id,
'relate_contact' source
FROM
emails_email_addr_rel eear
INNER JOIN
email_addr_bean_rel eabr
ON
eabr.email_address_id=eear.email_address_id
AND eabr.bean_module = 'Contacts'
AND eabr.deleted=0
INNER JOIN accounts_contacts linkt ON '9a86077e-c456-1950-81df-581c5868fd96'=linkt.account_id AND linkt.deleted=0
INNER JOIN contacts link_bean ON link_bean.id=linkt.contact_id AND link_bean.deleted=0
AND link_bean.id = eabr.bean_id
WHERE
eear.deleted=0
) email_ids ON emails.id=email_ids.email_id where ( emails.deleted=0 ) AND emails.deleted=0 ) ORDER BY date_entered desc LIMIT 0,10: MySQL error 1054: Unknown column 'calls.date_due' in 'field list'
Tue Oct 16 14:53:17 2018 [4897][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception handling in /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php:400
Tue Oct 16 14:53:17 2018 [4897][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception in Controller: Awaria bazy danych. Szczegóły zapisano w logu SuiteCRM.
Tue Oct 16 14:53:17 2018 [4897][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] backtrace:
#0 /var/www/crm.fortecait.pl/include/database/DBManager.php(353): sugar_die('Awaria bazy dan...')
#1 /var/www/crm.fortecait.pl/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'Error retrievin...', true)
#2 /var/www/crm.fortecait.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true)
#3 /var/www/crm.fortecait.pl/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT tasks.i...', true, 'Error retrievin...')
#4 /var/www/crm.fortecait.pl/data/SugarBean.php(1284): MysqlManager->limitQuery('(SELECT tasks.i...', 0, 10, true, 'Error retrievin...')
#5 /var/www/crm.fortecait.pl/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(Account), '(SELECT tasks.i...', 0, 10, 10, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /var/www/crm.fortecait.pl/include/ListView/ListView.php(1132): SugarBean::get_union_related_list(Object(Account), 'date_entered de...', 'desc', '', 0, -1, 10, '', Object(aSubPanel))
#7 /var/www/crm.fortecait.pl/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Account), Object(aSubPanel), 'history_CELL')
#8 /var/www/crm.fortecait.pl/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Accounts', Object(Account), Object(aSubPanel))
#9 /var/www/crm.fortecait.pl/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)
#10 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()
#11 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels()
#12 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /var/www/crm.fortecait.pl/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /var/www/crm.fortecait.pl/index.php(52): SugarApplication->execute()
#16 {main}
Tue Oct 16 14:56:42 2018 [5071][1][FATAL] log call at: modules/Administration/index.tpl:53 - MY_FRAME is not set
Expected Behavior
Actual Behavior
Possible Fix
Steps to Reproduce
Context
Problem is really problematic, right now 5 people are acessing related opportunities, contats, etc. different way but it's very time consuming.
Your Environment
@pgorod commented on GitHub (Oct 16, 2018):
Looks like a duplicate of #6356
The error message lost in the middle of all that is
Unknown column 'calls.date_due'There is a fix proposed in that other Issue, can you please try it?
@ghost commented on GitHub (Oct 17, 2018):
@pgorod Tried, no effect :(
@ghost commented on GitHub (Oct 26, 2018):
Problem solved on 7.10.10