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!