SuiteCRM v7.10.5 - Database failure. Please refer to suitecrm.log for details.

HI guys!

Recently I found a strange problem and I tried to solve it but without success,

the problem is that for some users with the same permissions and roles canā€™t view the detailview and other can view it without problemsā€¦ and I donā€™t know what is happeningā€¦

I tried to solve it with this :

https://github.com/salesagility/SuiteCRM/pull/5932/files

and this:

https://github.com/salesagility/SuiteCRM/pull/5953/files

andā€¦ this:

https://github.com/salesagility/SuiteCRM/commit/2e5fc11011ecba69060546c1e5524fc17ed7b4ba

and this:

I added this line on config_override.php

$sugar_config['disable_count_query'] = true;

but the problem persistsā€¦

and in the CRM log file I found this :


Mon Jul 16 09:57:43 2018 [30986][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 01/01/2016
Mon Jul 16 09:57:43 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 01/01/1900
Mon Jul 16 09:57:43 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 12/22/1975
Mon Jul 16 09:57:43 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 06/01/2017
Mon Jul 16 09:57:43 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:43 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:44 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:44 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:44 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:44 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:44 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:44 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:45 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:45 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:45 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:45 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:45 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:45 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:46 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:46 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:46 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:46 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:46 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:46 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:47 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:47 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:47 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:47 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:47 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:48 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:48 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:48 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:48 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:48 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:48 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:49 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:49 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:49 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:49 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:49 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:49 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:50 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:50 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:50 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:50 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:50 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:50 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 09:57:51 2018 [32516][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:01 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:01 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:02 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:02 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:02 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:02 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:02 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:02 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:03 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:03 2018 [450][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:00:03 2018 [450][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'b5213419-cbcb-c070-921b-5627b0f0e24c' AND contacts.date_entered > '2015-11-18 16:55:36' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='2175d95e-43e1-2d87-9b5c-564cad031aac' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:00:03 2018 [450][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:00:03 2018 [450][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '74382ffc-b201-54bf-d0f9-555b5a40d107' AND contacts.date_entered > '2015-12-14 16:28:22' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='42bfcf23-f4c2-d8df-61b2-566eee63f624' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:00:03 2018 [450][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:00:03 2018 [450][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '76b47a65-1ad4-4901-e6d5-555b58119ab7' AND contacts.date_entered > '2015-12-14 16:29:17' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='533b6a37-70eb-1e41-add6-566eeeff91f4' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:00:03 2018 [450][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:00:03 2018 [450][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'cdd2e1d9-283c-442e-5dca-555b58f3a307' AND contacts.date_entered > '2015-12-14 16:28:41' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='63b4f318-b74e-005e-6548-566eee1e4cb7' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:00:03 2018 [450][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:00:03 2018 [450][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '295b84ca-a56c-5485-53bd-551ecc77b0c6' AND contacts.date_entered > '2015-12-14 16:27:57' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b38063ec-f3d8-b4e7-9d37-566eee0f1c30' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:00:03 2018 [450][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:00:03 2018 [450][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '1' AND contacts.date_entered > '2015-12-14 16:24:08' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b70f0f7e-5767-454a-5de1-566eeda987cc' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:00:03 2018 [450][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:00:03 2018 [450][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '8eb94ce9-7a38-b34c-49cf-551ecc147297' AND contacts.date_entered > '2015-12-14 16:26:34' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='d2be9757-c26b-caea-52e0-566eed8c69eb' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:00:03 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:03 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:00:03 2018 [450][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:03:12 2018 [31212][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 01/01/1900
Mon Jul 16 10:03:12 2018 [31212][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 12/22/1975
Mon Jul 16 10:03:12 2018 [31212][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 06/01/2017
Mon Jul 16 10:03:12 2018 [31212][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:03:13 2018 [31212][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:03:25 2018 [31212][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 01/01/1900
Mon Jul 16 10:03:25 2018 [31212][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 12/22/1975
Mon Jul 16 10:03:25 2018 [31212][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 06/01/2017
Mon Jul 16 10:03:36 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 01/01/1900
Mon Jul 16 10:03:36 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 12/22/1975
Mon Jul 16 10:03:36 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 06/01/2017
Mon Jul 16 10:03:36 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:36 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:03:37 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:03:37 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:03:43 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:43 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 01/01/1900
Mon Jul 16 10:03:43 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 12/22/1975
Mon Jul 16 10:03:43 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 06/01/2017
Mon Jul 16 10:03:43 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:43 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:43 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 11/23/1999
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Executing case manager hook
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] got case manager44a0b117-d888-71e3-d7b3-55328128c241
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Executing case manager hook
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Executing case manager hook
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] got case manager60b3c3cd-37f5-c8b2-a6e8-55328138e954
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Executing case manager hook
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Executing case manager hook
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Executing case manager hook
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Executing case manager hook
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Executing case manager hook
Mon Jul 16 10:03:44 2018 [30763][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:03:56 2018 [30986][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 01/01/1900
Mon Jul 16 10:03:56 2018 [30986][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 12/22/1975
Mon Jul 16 10:03:56 2018 [30986][a89a9d84-a7cf-79d6-42c8-57bc7594dea5][FATAL] Inside after retrieve hook 06/01/2017
Mon Jul 16 10:03:57 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 01/01/2016
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 01/01/2016
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager44a0b117-d888-71e3-d7b3-55328128c241
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager60b3c3cd-37f5-c8b2-a6e8-55328138e954
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:04:00 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 11/23/1999
Mon Jul 16 10:04:01 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Mysqli_query failed.
Mon Jul 16 10:04:01 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Error retrieving Contact 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_due  as date_start  ,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  tasks.created_by  ,  'tasks' panel_name, NULL recurring_source, NULL date_due  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
Mon Jul 16 10:04:01 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:402
Mon Jul 16 10:04:01 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Jul 16 10:04:01 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] backtrace:
Mon Jul 16 10:05:01 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:01 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:01 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:02 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:02 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:02 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:02 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:02 2018 [563][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:05:02 2018 [563][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'b5213419-cbcb-c070-921b-5627b0f0e24c' AND contacts.date_entered > '2015-11-18 16:55:36' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='2175d95e-43e1-2d87-9b5c-564cad031aac' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:05:02 2018 [563][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:05:02 2018 [563][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '74382ffc-b201-54bf-d0f9-555b5a40d107' AND contacts.date_entered > '2015-12-14 16:28:22' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='42bfcf23-f4c2-d8df-61b2-566eee63f624' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:05:02 2018 [563][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:05:02 2018 [563][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '76b47a65-1ad4-4901-e6d5-555b58119ab7' AND contacts.date_entered > '2015-12-14 16:29:17' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='533b6a37-70eb-1e41-add6-566eeeff91f4' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:05:02 2018 [563][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:05:02 2018 [563][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'cdd2e1d9-283c-442e-5dca-555b58f3a307' AND contacts.date_entered > '2015-12-14 16:28:41' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='63b4f318-b74e-005e-6548-566eee1e4cb7' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:05:02 2018 [563][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:05:02 2018 [563][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '295b84ca-a56c-5485-53bd-551ecc77b0c6' AND contacts.date_entered > '2015-12-14 16:27:57' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b38063ec-f3d8-b4e7-9d37-566eee0f1c30' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:05:02 2018 [563][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:05:02 2018 [563][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '1' AND contacts.date_entered > '2015-12-14 16:24:08' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b70f0f7e-5767-454a-5de1-566eeda987cc' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:05:02 2018 [563][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:05:02 2018 [563][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '8eb94ce9-7a38-b34c-49cf-551ecc147297' AND contacts.date_entered > '2015-12-14 16:26:34' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='d2be9757-c26b-caea-52e0-566eed8c69eb' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:05:02 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:03 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:03 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:03 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:05:03 2018 [563][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:09:36 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:36 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 01/01/2016
Mon Jul 16 10:09:36 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:36 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:36 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:09:36 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:36 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager44a0b117-d888-71e3-d7b3-55328128c241
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager60b3c3cd-37f5-c8b2-a6e8-55328138e954
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 11/23/1999
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Mysqli_query failed.
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Error retrieving Contact 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_due  as date_start  ,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  tasks.created_by  ,  'tasks' panel_name, NULL recurring_source, NULL date_due  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
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:402
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Jul 16 10:09:37 2018 [31215][674e7ded-af78-4203-7937-551592df2f74][FATAL] backtrace:
Mon Jul 16 10:10:01 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:01 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:01 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:01 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:02 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:02 2018 [672][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:10:02 2018 [672][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'b5213419-cbcb-c070-921b-5627b0f0e24c' AND contacts.date_entered > '2015-11-18 16:55:36' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='2175d95e-43e1-2d87-9b5c-564cad031aac' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:10:02 2018 [672][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:10:02 2018 [672][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '74382ffc-b201-54bf-d0f9-555b5a40d107' AND contacts.date_entered > '2015-12-14 16:28:22' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='42bfcf23-f4c2-d8df-61b2-566eee63f624' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:10:02 2018 [672][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:10:02 2018 [672][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '76b47a65-1ad4-4901-e6d5-555b58119ab7' AND contacts.date_entered > '2015-12-14 16:29:17' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='533b6a37-70eb-1e41-add6-566eeeff91f4' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:10:02 2018 [672][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:10:02 2018 [672][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'cdd2e1d9-283c-442e-5dca-555b58f3a307' AND contacts.date_entered > '2015-12-14 16:28:41' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='63b4f318-b74e-005e-6548-566eee1e4cb7' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:10:02 2018 [672][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:10:02 2018 [672][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '295b84ca-a56c-5485-53bd-551ecc77b0c6' AND contacts.date_entered > '2015-12-14 16:27:57' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b38063ec-f3d8-b4e7-9d37-566eee0f1c30' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:10:02 2018 [672][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:10:02 2018 [672][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '1' AND contacts.date_entered > '2015-12-14 16:24:08' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b70f0f7e-5767-454a-5de1-566eeda987cc' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:10:02 2018 [672][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:10:02 2018 [672][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '8eb94ce9-7a38-b34c-49cf-551ecc147297' AND contacts.date_entered > '2015-12-14 16:26:34' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='d2be9757-c26b-caea-52e0-566eed8c69eb' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:10:02 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:02 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:02 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:02 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:03 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:03 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:10:03 2018 [672][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:12:57 2018 [32516][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 01/01/2016
Mon Jul 16 10:12:57 2018 [32516][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:13:27 2018 [30767][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 01/01/2016
Mon Jul 16 10:13:27 2018 [30767][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:13:27 2018 [30767][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:13:27 2018 [30767][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:14:58 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:58 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 01/01/2016
Mon Jul 16 10:14:58 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:58 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:58 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:14:58 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:58 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager44a0b117-d888-71e3-d7b3-55328128c241
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager60b3c3cd-37f5-c8b2-a6e8-55328138e954
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 11/23/1999
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Mysqli_query failed.
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Error retrieving Contact 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_due  as date_start  ,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  tasks.created_by  ,  'tasks' panel_name, NULL recurring_source, NULL date_due  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
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:402
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Jul 16 10:14:59 2018 [31212][674e7ded-af78-4203-7937-551592df2f74][FATAL] backtrace:
Mon Jul 16 10:15:01 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:01 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:01 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:01 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:01 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:02 2018 [735][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:15:02 2018 [735][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'b5213419-cbcb-c070-921b-5627b0f0e24c' AND contacts.date_entered > '2015-11-18 16:55:36' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='2175d95e-43e1-2d87-9b5c-564cad031aac' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:15:02 2018 [735][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:15:02 2018 [735][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '74382ffc-b201-54bf-d0f9-555b5a40d107' AND contacts.date_entered > '2015-12-14 16:28:22' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='42bfcf23-f4c2-d8df-61b2-566eee63f624' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:15:02 2018 [735][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:15:02 2018 [735][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '76b47a65-1ad4-4901-e6d5-555b58119ab7' AND contacts.date_entered > '2015-12-14 16:29:17' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='533b6a37-70eb-1e41-add6-566eeeff91f4' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:15:02 2018 [735][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:15:02 2018 [735][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'cdd2e1d9-283c-442e-5dca-555b58f3a307' AND contacts.date_entered > '2015-12-14 16:28:41' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='63b4f318-b74e-005e-6548-566eee1e4cb7' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:15:02 2018 [735][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:15:02 2018 [735][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '295b84ca-a56c-5485-53bd-551ecc77b0c6' AND contacts.date_entered > '2015-12-14 16:27:57' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b38063ec-f3d8-b4e7-9d37-566eee0f1c30' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:15:02 2018 [735][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:15:02 2018 [735][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '1' AND contacts.date_entered > '2015-12-14 16:24:08' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b70f0f7e-5767-454a-5de1-566eeda987cc' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:15:02 2018 [735][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:15:02 2018 [735][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '8eb94ce9-7a38-b34c-49cf-551ecc147297' AND contacts.date_entered > '2015-12-14 16:26:34' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='d2be9757-c26b-caea-52e0-566eed8c69eb' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:15:02 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:02 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:02 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:02 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:02 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:03 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:15:03 2018 [735][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:01 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:01 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:01 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:01 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:01 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:02 2018 [818][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:20:02 2018 [818][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'b5213419-cbcb-c070-921b-5627b0f0e24c' AND contacts.date_entered > '2015-11-18 16:55:36' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='2175d95e-43e1-2d87-9b5c-564cad031aac' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:20:02 2018 [818][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:20:02 2018 [818][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '74382ffc-b201-54bf-d0f9-555b5a40d107' AND contacts.date_entered > '2015-12-14 16:28:22' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='42bfcf23-f4c2-d8df-61b2-566eee63f624' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:20:02 2018 [818][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:20:02 2018 [818][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '76b47a65-1ad4-4901-e6d5-555b58119ab7' AND contacts.date_entered > '2015-12-14 16:29:17' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='533b6a37-70eb-1e41-add6-566eeeff91f4' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:20:02 2018 [818][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:20:02 2018 [818][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'cdd2e1d9-283c-442e-5dca-555b58f3a307' AND contacts.date_entered > '2015-12-14 16:28:41' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='63b4f318-b74e-005e-6548-566eee1e4cb7' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:20:02 2018 [818][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:20:02 2018 [818][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '295b84ca-a56c-5485-53bd-551ecc77b0c6' AND contacts.date_entered > '2015-12-14 16:27:57' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b38063ec-f3d8-b4e7-9d37-566eee0f1c30' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:20:02 2018 [818][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:20:02 2018 [818][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '1' AND contacts.date_entered > '2015-12-14 16:24:08' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b70f0f7e-5767-454a-5de1-566eeda987cc' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:20:02 2018 [818][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:20:02 2018 [818][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '8eb94ce9-7a38-b34c-49cf-551ecc147297' AND contacts.date_entered > '2015-12-14 16:26:34' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='d2be9757-c26b-caea-52e0-566eed8c69eb' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:20:02 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:02 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:02 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:02 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:02 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:03 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:20:03 2018 [818][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:24:27 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:27 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 01/01/2016
Mon Jul 16 10:24:27 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:27 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:27 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:24:27 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:27 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager44a0b117-d888-71e3-d7b3-55328128c241
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager60b3c3cd-37f5-c8b2-a6e8-55328138e954
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 11/23/1999
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Mysqli_query failed.
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Error retrieving Contact 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_due  as date_start  ,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  tasks.created_by  ,  'tasks' panel_name, NULL recurring_source, NULL date_due  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
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:402
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Jul 16 10:24:28 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] backtrace:
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 01/01/2016
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager44a0b117-d888-71e3-d7b3-55328128c241
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager60b3c3cd-37f5-c8b2-a6e8-55328138e954
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case manager89c33c10-d952-8656-638c-553281496051
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 02/07/1988
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Executing case manager hook
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] got case managerfc9f019c-8fed-0f8c-36a9-55328157cb2a
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Inside after retrieve hook 11/23/1999
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Mysqli_query failed.
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Error retrieving Contact 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_due  as date_start  ,  jt1.user_name assigned_user_name ,  jt1.created_by assigned_user_name_owner  ,  'Users' assigned_user_name_mod,  tasks.created_by  ,  'tasks' panel_name, NULL recurring_source, NULL date_due  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
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:402
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Jul 16 10:24:45 2018 [30763][674e7ded-af78-4203-7937-551592df2f74][FATAL] backtrace:
Mon Jul 16 10:25:01 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:01 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:01 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:01 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:01 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:02 2018 [925][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:25:02 2018 [925][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'b5213419-cbcb-c070-921b-5627b0f0e24c' AND contacts.date_entered > '2015-11-18 16:55:36' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='2175d95e-43e1-2d87-9b5c-564cad031aac' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:25:02 2018 [925][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:25:02 2018 [925][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '74382ffc-b201-54bf-d0f9-555b5a40d107' AND contacts.date_entered > '2015-12-14 16:28:22' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='42bfcf23-f4c2-d8df-61b2-566eee63f624' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:25:02 2018 [925][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:25:02 2018 [925][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '76b47a65-1ad4-4901-e6d5-555b58119ab7' AND contacts.date_entered > '2015-12-14 16:29:17' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='533b6a37-70eb-1e41-add6-566eeeff91f4' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:25:02 2018 [925][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:25:02 2018 [925][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = 'cdd2e1d9-283c-442e-5dca-555b58f3a307' AND contacts.date_entered > '2015-12-14 16:28:41' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='63b4f318-b74e-005e-6548-566eee1e4cb7' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:25:02 2018 [925][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:25:02 2018 [925][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '295b84ca-a56c-5485-53bd-551ecc77b0c6' AND contacts.date_entered > '2015-12-14 16:27:57' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b38063ec-f3d8-b4e7-9d37-566eee0f1c30' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:25:02 2018 [925][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:25:02 2018 [925][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '1' AND contacts.date_entered > '2015-12-14 16:24:08' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='b70f0f7e-5767-454a-5de1-566eeda987cc' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:25:02 2018 [925][1][FATAL] Mysqli_query failed.
Mon Jul 16 10:25:02 2018 [925][1][FATAL]  Query Failed: SELECT contacts.id AS id FROM contacts  WHERE contacts.user_id_c = '8eb94ce9-7a38-b34c-49cf-551ecc147297' AND contacts.date_entered > '2015-12-14 16:26:34' AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='d2be9757-c26b-caea-52e0-566eed8c69eb' AND aow_processed.parent_id=contacts.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND contacts.deleted = 0 : MySQL error 1054: Unknown column 'contacts.user_id_c' in 'where clause'
Mon Jul 16 10:25:02 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:02 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:02 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:02 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:02 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:03 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jul 16 10:25:03 2018 [925][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array

the browser is not throwing error messages in javascriptā€¦ then the detailview only show the contact overview data but below only the message ā€˜Database failure. Please refer to suitecrm.log for details.ā€™ and the subpanels are not appear itā€¦

but I think that that query is bad but I canā€™t find it or o donā€™t know how is generating it that queryā€¦ or what could be happening?

help, please!

What do you see in php_errors.log? Always check both logs, one is not enough. If PHP throws an error before SuiteCRM can handle it, itā€™s in the web server log.

Please go in Admin / Repairs and try a QR&R, scroll to the bottom, press button to sync vardefs if there is a button available there.

Try also Repair relationships.

Your query is trying to get ā€œuser_id_cā€ from the main contacts table, it should probably be joining the contacts_cstm table and getting it from there. But you seem to have many customizations and I donā€™t know what you did to get to this pointā€¦

Hi @pgr

the stack trace throw this:

Warning: Declaration of RelationshipHandler::build_related_list($type = ā€˜baseā€™) should be compatible with SugarBean::build_related_list($query, &$template, $row_offset = 0, $limit = -1) occurred in /var/www/html/modules/Relationships/RelationshipHandler.php on line 49 [2018-07-17 09:35:34] display_stack_trace caller, file: /var/www/html/include/utils.php line#: 3533
/var/www/html/modules/Relationships/RelationshipHandler.phpL:49
/var/www/html/modules/SecurityGroups/SecurityGroup.phpL:574
/var/www/html/modules/SecurityGroups/SecurityGroup.phpL:759
/var/www/html/custom/application/Ext/Utils/custom_utils.ext.phpL:60
/var/www/html/include/EditView/EditView2.phpL:1075
/var/www/html/include/EditView/EditView2.phpL:665
/var/www/html/include/MVC/View/views/view.detail.phpL:128
/var/www/html/modules/Contacts/views/view.detail.phpL:68
/var/www/html/custom/modules/Contacts/views/view.detail.phpL:90
/var/www/html/include/MVC/View/SugarView.phpL:207
/var/www/html/include/MVC/Controller/SugarController.phpL:432
/var/www/html/include/MVC/Controller/SugarController.phpL:375
/var/www/html/include/MVC/SugarApplication.phpL:109
/var/www/html/index.phpL:52

but the strange is that one user can see the contact and another with the same role can notā€¦

This is fixed here

https://github.com/salesagility/SuiteCRM/commit/6a7f64db82c2532f709633c83267735bb60d6a74