Hi,
Sorry for the second post in as many days…managed to overcome many issues with help of posts from this forum so appreciate everyones input!!
I’ve just been entering some dummy data into my test environment and coming across an issue when editing the assigned to field of an existing call, when saving it returns a blank page.
Log indicates the following error:http://xxx/suitecrm/index.php
I’ve tried to repair and set correct permissions but not sure how to resolve issue with my limited but improving knowledge!
I’ve turned on display errors and get the following details on Save:
TIA
Can you reproduce that error in the SuiteCRM online demo? Just to check if the problem is only in your system…
http://demo.suiteondemand.com/
Thanks
1 Like
Thanks for details of that demo very useful!!
I’m unable to replicate issue here, can update Assigned To user for an existing call without any problem??
What are version of Suite are you running?
On what environment are you running apache, nginx, php version?, OS, and so on.
Hi,
SuitCRM Version 7.8.3
Running on:
Thanks!
I think here is a similar problem with a solution:
https://stackoverflow.com/questions/6304088/sugarcrm-unable-to-create-calls-meetings-php-catchable-fatal-error-with-timed
but I would definitely like to find out the root cause of this, it’s strange if it’s an old bug from SugarCRM, how come it only happens to a few people?
Well your config looks normal enough.
Have you tried setting the proper error reporting for php? I believe it should be something along the lines of
error_reporting = E_ALL & ~E_NOTICE
Perhaps try going with another fresh install and see if the same issue arises. I am running 7.8.2 and not 7.8.3, so I can’t say for sure it’s not in the code. Sometimes a file can become corrupt when being transferred.
Can you please go to this file
and around line 546 there is a function called set_notification_body. Please add a few lines, where you see
// rrs: bug 42684 - passing a contact breaks this call
$notifyUser =($call->current_notify_user->object_name == 'User') ? $call->current_notify_user : $current_user;
change it do to this, by adding a line to write some variables to the log:
// rrs: bug 42684 - passing a contact breaks this call
$notifyUser =($call->current_notify_user->object_name == 'User') ? $call->current_notify_user : $current_user;
$GLOBALS['log']->fatal("Inside set_notification_body. object_name is $call->current_notify_user->object_name, call->current_notify_user is $call->current_notify_user and current_user is $current_user ");
That is all in one line, no line breaks!
Then make the error occur again and paste here that message as it appears in your suitecrm.log. This will help me debug the issue. Thanks!
My error_reporting values are set as follows: error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT
When changing to as suggested the system won’t run following restart of apache
pgr:
Can you please go to this file
and around line 546 there is a function called set_notification_body. Please add a few lines, where you see
// rrs: bug 42684 - passing a contact breaks this call
$notifyUser =($call->current_notify_user->object_name == 'User') ? $call->current_notify_user : $current_user;
change it do to this, by adding a line to write some variables to the log:
// rrs: bug 42684 - passing a contact breaks this call
$notifyUser =($call->current_notify_user->object_name == 'User') ? $call->current_notify_user : $current_user;
$GLOBALS['log']->fatal("Inside set_notification_body. object_name is $call->current_notify_user->object_name, call->current_notify_user is $call->current_notify_user and current_user is $current_user ");
That is all in one line, no line breaks!
Then make the error occur again and paste here that message as it appears in your suitecrm.log. This will help me debug the issue. Thanks!
Thanks for info pg., I have made the following changes and it’s now returning this error:
[color=#ff0000]Catchable fatal error: Object of class User could not be converted to string in /Users/atadmin/Sites/suitecrm/modules/Calls/Call.php on line 556[/color]
Line 556 is the line I added.
Sorry, my fault, I should have looked more attentively at what kind of objects these were.
Let’s try this logging line instead:
$GLOBALS['log']->fatal("Inside set_notification_body. call->current_notify_user is\n" . print_r($call->current_notify_user) . "\n\ncurrent_user is " . print_r($current_user));
Now, that could generate a LOT of lines of output, I don’t know how big/complex that object is. But let’s try it.
NOTE: make sure those outputs don’t include any passwords before posting them here… and post them using the forum’s “code” tags please
1 Like
Here goes…it has output quite a few lines so apologies if this is no use. Appreciate your assistance!!
User Object ( [name] => Joe Bloggs [full_name] => Joe Bloggs [id] => 883a0b73-6be5-2d01-bf82-591eada7827d [user_name] => JoeBloggs [user_hash] => $1$vGfBvXQ8$EnJOP.V0US/hFIHxe.NJx1 [salutation] => [first_name] => Joe [last_name] => Bloggs [date_entered] => 19/05/2017 08:31 [date_modified] => 01/06/2017 15:13 [modified_user_id] => 883a0b73-6be5-2d01-bf82-591eada7827d [created_by] => 1 [created_by_name] => Administrator [modified_by_name] => Joe Bloggs [description] => [phone_home] => [phone_mobile] => [phone_work] => [phone_other] => [phone_fax] => [email1] => Joe.Bloggs@example.com [email2] => [address_street] => [address_city] => [address_state] => [address_postalcode] => [address_country] => [status] => Active [title] => Customer Service Team Leader [photo] => [portal_only] => 0 [department] => [authenticated] => [error_string] => [is_admin] => 1 [employee_status] => Active [messenger_id] => [messenger_type] => [is_group] => 0 [accept_status] => [team_id] => [receive_notifications] => 1 [reports_to_name] => [reports_to_id] => [team_exists] => [table_name] => users [module_dir] => Users [object_name] => User [user_preferences] => [importable] => 1 [_userPreferenceFocus] => UserPreference Object ( [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => 1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22919 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [field_name_map] => Array ( [id] => Array ( [name] => id [vname] => LBL_NAME [type] => id [required] => 1 [reportable] => ) [category] => Array ( [name] => category [type] => varchar [len] => 50 ) [deleted] => Array ( [name] => deleted [type] => bool [default] => 0 [required] => ) [date_entered] => Array ( [name] => date_entered [type] => datetime [required] => 1 ) [date_modified] => Array ( [name] => date_modified [type] => datetime [required] => 1 ) [assigned_user_id] => Array ( [name] => assigned_user_id [rname] => user_name [id_name] => assigned_user_id [type] => assigned_user_name [table] => users [required] => 1 [dbType] => id ) [assigned_user_name] => Array ( [name] => assigned_user_name [vname] => LBL_ASSIGNED_TO_NAME [type] => varchar [reportable] => [massupdate] => [source] => non-db [table] => users ) [contents] => Array ( [name] => contents [type] => longtext [vname] => LBL_DESCRIPTION [isnull] => 1 ) ) [id] => [date_entered] => [date_modified] => [assigned_user_id] => [assigned_user_name] => [name] => [category] => [contents] => [deleted] => 0 [object_name] => UserPreference [table_name] => user_preferences [disable_row_level_security] => 1 [module_dir] => UserPreferences [field_defs] => Array ( [id] => Array ( [name] => id [vname] => LBL_NAME [type] => id [required] => 1 [reportable] => ) [category] => Array ( [name] => category [type] => varchar [len] => 50 ) [deleted] => Array ( [name] => deleted [type] => bool [default] => 0 [required] => ) [date_entered] => Array ( [name] => date_entered [type] => datetime [required] => 1 ) [date_modified] => Array ( [name] => date_modified [type] => datetime [required] => 1 ) [assigned_user_id] => Array ( [name] => assigned_user_id [rname] => user_name [id_name] => assigned_user_id [type] => assigned_user_name [table] => users [required] => 1 [dbType] => id ) [assigned_user_name] => Array ( [name] => assigned_user_name [vname] => LBL_ASSIGNED_TO_NAME [type] => varchar [reportable] => [massupdate] => [source] => non-db [table] => users ) [contents] => Array ( [name] => contents [type] => longtext [vname] => LBL_DESCRIPTION [isnull] => 1 ) ) [field_defs_map] => Array ( ) [new_schema] => 1 [_userFocus:protected] => User Object *RECURSION* [new_with_id] => [disable_vardefs] => [new_assigned_user_name] => [processed_dates_times] => Array ( ) [process_save_dates] => 1 [save_from_post] => 1 [duplicates_found] => [update_date_modified] => 1 [update_modified_by] => 1 [update_date_entered] => [set_created_by] => 1 [ungreedy_count] => [module_name] => UserPreferences [custom_fields] => DynamicField Object ( [use_existing_labels] => [base_path] => custom/Extension/modules/UserPreferences/Ext/Vardefs [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22920 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [bean] => UserPreference Object *RECURSION* [module] => UserPreferences ) [column_fields] => Array ( [0] => id [1] => category [2] => deleted [3] => date_entered [4] => date_modified [5] => assigned_user_id [6] => assigned_user_name [7] => contents ) [list_fields] => Array ( ) [additional_column_fields] => Array ( ) [relationship_fields] => Array ( ) [current_notify_user] => [fetched_row] => [fetched_rel_row] => Array ( ) [layout_def] => [force_load_details] => [optimistic_lock] => [disable_custom_fields] => [number_formatting_done] => [process_field_encrypted] => [acltype] => module [additional_meta_fields] => Array ( ) [notify_inworkflow] => [description] => [modified_user_id] => [created_by] => [created_by_name] => [modified_by_name] => [importable] => [special_notification] => [in_workflow] => [tracker_visibility] => [listview_inner_join] => Array ( ) [in_import] => [in_save] => [logicHookDepth] => [max_logic_depth:protected] => 10 [loaded_relationships:protected] => Array ( ) [is_updated_dependent_fields:protected] => [required_fields] => Array ( [id] => 1 [date_entered] => 1 [date_modified] => 1 [assigned_user_id] => 1 ) [added_custom_field_defs] => 1 ) [encodeFields] => Array ( [0] => first_name [1] => last_name [2] => description ) [additional_column_fields] => Array ( [0] => reports_to_name ) [emailAddress] => SugarEmailAddress Object ( [table_name] => email_addresses [module_name] => EmailAddresses [module_dir] => EmailAddresses [object_name] => EmailAddress [regex] => /^(?:['\.\-\+&#!$\*=\?\^_`\{\}~\/\w]+)@(?:(?:\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})|\w+(?:[\.-]*\w+)*(?:\.[\w-]{2,})+)$/ [disable_custom_fields] => 1 [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22921 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [smarty] => [addresses] => Array ( [0] => Array ( [email_address] => Joe.Bloggs@example.com [email_address_caps] => Joe.Bloggs@example.COM [invalid_email] => 0 [opt_out] => 0 [date_created] => 2017-05-19 08:27:38 [date_modified] => 2017-05-19 08:27:38 [id] => 11146183-ea26-2989-0415-591eadde4324 [email_address_id] => 139b37a9-bcec-6da3-bad1-591eaccd0b72 [bean_id] => 883a0b73-6be5-2d01-bf82-591eada7827d [bean_module] => Users [primary_address] => 1 [reply_to_address] => 0 [deleted] => 0 ) ) [view] => [stateBeforeWorkflow:SugarEmailAddress:private] => [email_address] => [id] => [new_with_id] => [disable_vardefs] => [new_assigned_user_name] => [processed_dates_times] => Array ( ) [process_save_dates] => 1 [save_from_post] => 1 [duplicates_found] => [deleted] => 0 [update_date_modified] => 1 [update_modified_by] => 1 [update_date_entered] => [set_created_by] => 1 [ungreedy_count] => [field_name_map] => Array ( [id] => Array ( [name] => id [type] => id [vname] => LBL_EMAIL_ADDRESS_ID [required] => 1 ) [email_address] => Array ( [name] => email_address [type] => varchar [vname] => LBL_EMAIL_ADDRESS [length] => 100 [required] => 1 ) [email_address_caps] => Array ( [name] => email_address_caps [type] => varchar [vname] => LBL_EMAIL_ADDRESS_CAPS [length] => 100 [required] => 1 [reportable] => ) [invalid_email] => Array ( [name] => invalid_email [type] => bool [default] => 0 [vname] => LBL_INVALID_EMAIL ) [opt_out] => Array ( [name] => opt_out [type] => bool [default] => 0 [vname] => LBL_OPT_OUT ) [date_created] => Array ( [name] => date_created [type] => datetime [vname] => LBL_DATE_CREATE ) [date_modified] => Array ( [name] => date_modified [type] => datetime [vname] => LBL_DATE_MODIFIED ) [deleted] => Array ( [name] => deleted [type] => bool [default] => 0 [vname] => LBL_DELETED ) ) [field_defs] => Array ( [id] => Array ( [name] => id [type] => id [vname] => LBL_EMAIL_ADDRESS_ID [required] => 1 ) [email_address] => Array ( [name] => email_address [type] => varchar [vname] => LBL_EMAIL_ADDRESS [length] => 100 [required] => 1 ) [email_address_caps] => Array ( [name] => email_address_caps [type] => varchar [vname] => LBL_EMAIL_ADDRESS_CAPS [length] => 100 [required] => 1 [reportable] => ) [invalid_email] => Array ( [name] => invalid_email [type] => bool [default] => 0 [vname] => LBL_INVALID_EMAIL ) [opt_out] => Array ( [name] => opt_out [type] => bool [default] => 0 [vname] => LBL_OPT_OUT ) [date_created] => Array ( [name] => date_created [type] => datetime [vname] => LBL_DATE_CREATE ) [date_modified] => Array ( [name] => date_modified [type] => datetime [vname] => LBL_DATE_MODIFIED ) [deleted] => Array ( [name] => deleted [type] => bool [default] => 0 [vname] => LBL_DELETED ) ) [custom_fields] => [column_fields] => Array ( [0] => id [1] => email_address [2] => email_address_caps [3] => invalid_email [4] => opt_out [5] => date_created [6] => date_modified [7] => deleted ) [list_fields] => Array ( ) [additional_column_fields] => Array ( ) [relationship_fields] => Array ( ) [current_notify_user] => [fetched_row] => [fetched_rel_row] => Array ( ) [layout_def] => [force_load_details] => [optimistic_lock] => [number_formatting_done] => [process_field_encrypted] => [acltype] => module [additional_meta_fields] => Array ( ) [notify_inworkflow] => [name] => [description] => [date_entered] => [date_modified] => [modified_user_id] => [assigned_user_id] => [created_by] => [created_by_name] => [modified_by_name] => [importable] => [special_notification] => [in_workflow] => [tracker_visibility] => 1 [listview_inner_join] => Array ( ) [in_import] => [in_save] => [logicHookDepth] => [max_logic_depth:protected] => 10 [loaded_relationships:protected] => Array ( ) [is_updated_dependent_fields:protected] => [required_fields] => Array ( [id] => 1 [email_address] => 1 [email_address_caps] => 1 ) [added_custom_field_defs] => 1 [invalid_email] => 0 [opt_out] => 0 [index] => 8 ) [new_schema] => 1 [createLocaleFormattedName] => 1 [email_addresses] => [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22922 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [new_with_id] => [disable_vardefs] => [new_assigned_user_name] => [processed_dates_times] => Array ( [id] => 1 [user_name] => 1 [user_hash] => 1 [system_generated_password] => 1 [pwd_last_changed] => 1 [authenticate_id] => 1 [sugar_login] => 1 [first_name] => 1 [last_name] => 1 [full_name] => 1 [name] => 1 [is_admin] => 1 [external_auth_only] => 1 [receive_notifications] => 1 [description] => 1 [date_entered] => 1 [date_modified] => 1 [modified_user_id] => 1 [modified_by_name] => 1 [created_by] => 1 [created_by_name] => 1 [title] => 1 [photo] => 1 [department] => 1 [phone_home] => 1 [phone_mobile] => 1 [phone_work] => 1 [phone_other] => 1 [phone_fax] => 1 [status] => 1 [address_street] => 1 [address_city] => 1 [address_state] => 1 [address_country] => 1 [address_postalcode] => 1 [UserType] => 1 [deleted] => 1 [portal_only] => 1 [show_on_employees] => 1 [employee_status] => 1 [messenger_id] => 1 [messenger_type] => 1 [calls] => 1 [meetings] => 1 [contacts_sync] => 1 [reports_to_id] => 1 [reports_to_name] => 1 [reports_to_link] => 1 [reportees] => 1 [email1] => 1 [email_addresses] => 1 [email_addresses_primary] => 1 [email_link_type] => 1 [aclroles] => 1 [is_group] => 1 [c_accept_status_fields] => 1 [m_accept_status_fields] => 1 [accept_status_id] => 1 [accept_status_name] => 1 [prospect_lists] => 1 [emails_users] => 1 [eapm] => 1 [oauth_tokens] => 1 [project_resource] => 1 [project_users_1] => 1 [am_projecttemplates_resources] => 1 [am_projecttemplates_users_1] => 1 [SecurityGroups] => 1 [securitygroup_noninher_fields] => 1 [securitygroup_noninherit_id] => 1 [securitygroup_noninheritable] => 1 [securitygroup_primary_group] => 1 ) [process_save_dates] => 1 [save_from_post] => 1 [duplicates_found] => [deleted] => 0 [update_date_modified] => 1 [update_modified_by] => 1 [update_date_entered] => [set_created_by] => 1 [ungreedy_count] => [module_name] => Users [field_name_map] => Array ( [id] => Array ( [name] => id [vname] => LBL_ID [type] => id [required] => 1 ) [user_name] => Array ( [name] => user_name [vname] => LBL_USER_NAME [type] => user_name [dbType] => varchar [len] => 60 [importable] => required [required] => 1 [studio] => Array ( [no_duplicate] => 1 [editview] => [detailview] => 1 [quickcreate] => [basic_search] => [advanced_search] => ) ) [user_hash] => Array ( [name] => user_hash [vname] => LBL_USER_HASH [type] => varchar [len] => 255 [reportable] => [importable] => false [sensitive] => 1 [studio] => Array ( [no_duplicate] => 1 [listview] => [searchview] => ) ) [system_generated_password] => Array ( [name] => system_generated_password [vname] => LBL_SYSTEM_GENERATED_PASSWORD [type] => bool [required] => 1 [reportable] => [massupdate] => [studio] => Array ( [listview] => [searchview] => [editview] => [quickcreate] => ) ) [pwd_last_changed] => Array ( [name] => pwd_last_changed [vname] => LBL_PSW_MODIFIED [type] => datetime [required] => [massupdate] => [studio] => Array ( [formula] => ) ) [authenticate_id] => Array ( [name] => authenticate_id [vname] => LBL_AUTHENTICATE_ID [type] => varchar [len] => 100 [reportable] => [importable] => false [studio] => Array ( [listview] => [searchview] => [related] => ) ) [sugar_login] => Array ( [name] => sugar_login [vname] => LBL_SUGAR_LOGIN [type] => bool [default] => 1 [reportable] => [massupdate] => [importable] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [first_name] => Array ( [name] => first_name [vname] => LBL_FIRST_NAME [dbType] => varchar [type] => name [len] => 30 ) [last_name] => Array ( [name] => last_name [vname] => LBL_LAST_NAME [dbType] => varchar [type] => name [len] => 30 [importable] => required [required] => 1 ) [full_name] => Array ( [name] => full_name [rname] => full_name [vname] => LBL_NAME [type] => name [fields] => Array ( [0] => first_name [1] => last_name ) [source] => non-db [sort_on] => last_name [sort_on2] => first_name [db_concat_fields] => Array ( [0] => first_name [1] => last_name ) [len] => 510 [studio] => Array ( [formula] => ) ) [name] => Array ( [name] => name [rname] => name [vname] => LBL_NAME [type] => varchar [source] => non-db [len] => 510 [db_concat_fields] => Array ( [0] => first_name [1] => last_name ) [importable] => false ) [is_admin] => Array ( [name] => is_admin [vname] => LBL_IS_ADMIN [type] => bool [default] => 0 [studio] => Array ( [listview] => [searchview] => [related] => ) ) [external_auth_only] => Array ( [name] => external_auth_only [vname] => LBL_EXT_AUTHENTICATE [type] => bool [reportable] => [massupdate] => [default] => 0 [studio] => Array ( [listview] => [searchview] => [related] => ) ) [receive_notifications] => Array ( [name] => receive_notifications [vname] => LBL_RECEIVE_NOTIFICATIONS [type] => bool [default] => 1 [massupdate] => [studio] => ) [description] => Array ( [name] => description [vname] => LBL_DESCRIPTION [type] => text ) [date_entered] => Array ( [name] => date_entered [vname] => LBL_DATE_ENTERED [type] => datetime [required] => 1 [studio] => Array ( [editview] => [quickcreate] => ) ) [date_modified] => Array ( [name] => date_modified [vname] => LBL_DATE_MODIFIED [type] => datetime [required] => 1 [studio] => Array ( [editview] => [quickcreate] => ) ) [modified_user_id] => Array ( [name] => modified_user_id [rname] => user_name [id_name] => modified_user_id [vname] => LBL_MODIFIED_BY_ID [type] => assigned_user_name [table] => users [isnull] => false [dbType] => id ) [modified_by_name] => Array ( [name] => modified_by_name [vname] => LBL_MODIFIED_BY [type] => varchar [source] => non-db [studio] => ) [created_by] => Array ( [name] => created_by [rname] => user_name [id_name] => modified_user_id [vname] => LBL_ASSIGNED_TO [type] => assigned_user_name [table] => users [isnull] => false [dbType] => id [studio] => ) [created_by_name] => Array ( [name] => created_by_name [vname] => LBL_CREATED_BY_NAME [type] => varchar [source] => non-db [importable] => false ) [title] => Array ( [name] => title [vname] => LBL_TITLE [type] => varchar [len] => 50 ) [photo] => Array ( [name] => photo [vname] => LBL_PHOTO [type] => image [massupdate] => [comments] => [help] => [importable] => [reportable] => 1 [len] => 255 [dbType] => varchar [width] => 160 [height] => 160 ) [department] => Array ( [name] => department [vname] => LBL_DEPARTMENT [type] => varchar [len] => 50 ) [phone_home] => Array ( [name] => phone_home [vname] => LBL_HOME_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_mobile] => Array ( [name] => phone_mobile [vname] => LBL_MOBILE_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_work] => Array ( [name] => phone_work [vname] => LBL_WORK_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_other] => Array ( [name] => phone_other [vname] => LBL_OTHER_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_fax] => Array ( [name] => phone_fax [vname] => LBL_FAX_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [status] => Array ( [name] => status [vname] => LBL_STATUS [type] => enum [len] => 100 [options] => user_status_dom [importable] => required [required] => 1 ) [address_street] => Array ( [name] => address_street [vname] => LBL_ADDRESS_STREET [type] => varchar [len] => 150 ) [address_city] => Array ( [name] => address_city [vname] => LBL_ADDRESS_CITY [type] => varchar [len] => 100 ) [address_state] => Array ( [name] => address_state [vname] => LBL_ADDRESS_STATE [type] => varchar [len] => 100 ) [address_country] => Array ( [name] => address_country [vname] => LBL_ADDRESS_COUNTRY [type] => varchar [len] => 100 ) [address_postalcode] => Array ( [name] => address_postalcode [vname] => LBL_ADDRESS_POSTALCODE [type] => varchar [len] => 20 ) [UserType] => Array ( [name] => UserType [vname] => LBL_USER_TYPE [type] => enum [len] => 50 [options] => user_type_dom [source] => non-db [import] => [reportable] => [studio] => Array ( [formula] => ) ) [deleted] => Array ( [name] => deleted [vname] => LBL_DELETED [type] => bool [required] => [reportable] => ) [portal_only] => Array ( [name] => portal_only [vname] => LBL_PORTAL_ONLY_USER [type] => bool [massupdate] => [default] => 0 [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [show_on_employees] => Array ( [name] => show_on_employees [vname] => LBL_SHOW_ON_EMPLOYEES [type] => bool [massupdate] => 1 [importable] => 1 [default] => 1 [studio] => Array ( [formula] => ) ) [employee_status] => Array ( [name] => employee_status [vname] => LBL_EMPLOYEE_STATUS [type] => varchar [function] => Array ( [name] => getEmployeeStatusOptions [returns] => html [include] => modules/Employees/EmployeeStatus.php ) [len] => 100 ) [messenger_id] => Array ( [name] => messenger_id [vname] => LBL_MESSENGER_ID [type] => varchar [len] => 100 ) [messenger_type] => Array ( [name] => messenger_type [vname] => LBL_MESSENGER_TYPE [type] => enum [options] => messenger_type_dom [len] => 100 ) [calls] => Array ( [name] => calls [type] => link [relationship] => calls_users [source] => non-db [vname] => LBL_CALLS ) [meetings] => Array ( [name] => meetings [type] => link [relationship] => meetings_users [source] => non-db [vname] => LBL_MEETINGS ) [contacts_sync] => Array ( [name] => contacts_sync [type] => link [relationship] => contacts_users [source] => non-db [vname] => LBL_CONTACTS_SYNC [reportable] => ) [reports_to_id] => Array ( [name] => reports_to_id [vname] => LBL_REPORTS_TO_ID [type] => id [required] => ) [reports_to_name] => Array ( [name] => reports_to_name [rname] => last_name [id_name] => reports_to_id [vname] => LBL_REPORTS_TO_NAME [type] => relate [isnull] => true [module] => Users [table] => users [link] => reports_to_link [reportable] => [source] => non-db [duplicate_merge] => disabled [side] => right ) [reports_to_link] => Array ( [name] => reports_to_link [type] => link [relationship] => user_direct_reports [link_type] => one [side] => right [source] => non-db [vname] => LBL_REPORTS_TO ) [reportees] => Array ( [name] => reportees [type] => link [relationship] => user_direct_reports [link_type] => many [side] => left [source] => non-db [vname] => LBL_REPORTS_TO [reportable] => ) [email1] => Array ( [name] => email1 [vname] => LBL_EMAIL [type] => varchar [function] => Array ( [name] => getEmailAddressWidget [returns] => html ) [source] => non-db [group] => email1 [merge_filter] => enabled [required] => 1 ) [email_addresses] => Array ( [name] => email_addresses [type] => link [relationship] => users_email_addresses [module] => EmailAddress [bean_name] => EmailAddress [source] => non-db [vname] => LBL_EMAIL_ADDRESSES [reportable] => [required] => 1 ) [email_addresses_primary] => Array ( [name] => email_addresses_primary [type] => link [relationship] => users_email_addresses_primary [source] => non-db [vname] => LBL_EMAIL_ADDRESS_PRIMARY [duplicate_merge] => disabled [required] => 1 ) [email_link_type] => Array ( [name] => email_link_type [vname] => LBL_EMAIL_LINK_TYPE [type] => enum [options] => dom_email_link_type [importable] => [reportable] => [source] => non-db [studio] => ) [aclroles] => Array ( [name] => aclroles [type] => link [relationship] => acl_roles_users [source] => non-db [side] => right [vname] => LBL_ROLES ) [is_group] => Array ( [name] => is_group [vname] => LBL_GROUP_USER [type] => bool [massupdate] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [c_accept_status_fields] => Array ( [name] => c_accept_status_fields [rname] => id [relationship_fields] => Array ( [id] => accept_status_id [accept_status] => accept_status_name ) [vname] => LBL_LIST_ACCEPT_STATUS [type] => relate [link] => calls [link_type] => relationship_info [source] => non-db [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [m_accept_status_fields] => Array ( [name] => m_accept_status_fields [rname] => id [relationship_fields] => Array ( [id] => accept_status_id [accept_status] => accept_status_name ) [vname] => LBL_LIST_ACCEPT_STATUS [type] => relate [link] => meetings [link_type] => relationship_info [source] => non-db [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [accept_status_id] => Array ( [name] => accept_status_id [type] => varchar [source] => non-db [vname] => LBL_LIST_ACCEPT_STATUS [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [accept_status_name] => Array ( [name] => accept_status_name [type] => enum [source] => non-db [vname] => LBL_LIST_ACCEPT_STATUS [options] => dom_meeting_accept_status [massupdate] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [prospect_lists] => Array ( [name] => prospect_lists [type] => link [relationship] => prospect_list_users [module] => ProspectLists [source] => non-db [vname] => LBL_PROSPECT_LIST ) [emails_users] => Array ( [name] => emails_users [type] => link [relationship] => emails_users_rel [module] => Emails [source] => non-db [vname] => LBL_EMAILS ) [eapm] => Array ( [name] => eapm [type] => link [relationship] => eapm_assigned_user [vname] => LBL_ASSIGNED_TO_USER [source] => non-db ) [oauth_tokens] => Array ( [name] => oauth_tokens [type] => link [relationship] => oauthtokens_assigned_user [vname] => LBL_OAUTH_TOKENS [link_type] => one [module] => OAuthTokens [bean_name] => OAuthToken [source] => non-db [side] => left ) [project_resource] => Array ( [name] => project_resource [type] => link [relationship] => projects_users_resources [source] => non-db [vname] => LBL_PROJECTS ) [project_users_1] => Array ( [name] => project_users_1 [type] => link [relationship] => project_users_1 [source] => non-db [module] => Project [bean_name] => Project [vname] => LBL_PROJECT_USERS_1_FROM_PROJECT_TITLE ) [am_projecttemplates_resources] => Array ( [name] => am_projecttemplates_resources [type] => link [relationship] => am_projecttemplates_users_resources [source] => non-db [vname] => LBL_PROJECTS ) [am_projecttemplates_users_1] => Array ( [name] => am_projecttemplates_users_1 [type] => link [relationship] => am_projecttemplates_users_1 [source] => non-db [module] => AM_ProjectTemplates [bean_name] => AM_ProjectTemplates [vname] => LBL_PROJECT_USERS_1_FROM_PROJECT_TITLE ) [SecurityGroups] => Array ( [name] => SecurityGroups [type] => link [relationship] => securitygroups_users [source] => non-db [module] => SecurityGroups [bean_name] => SecurityGroup [vname] => LBL_SECURITYGROUPS ) [securitygroup_noninher_fields] => Array ( [name] => securitygroup_noninher_fields [rname] => id [relationship_fields] => Array ( [id] => securitygroup_noninherit_id [noninheritable] => securitygroup_noninheritable [primary_group] => securitygroup_primary_group ) [vname] => LBL_USER_NAME [type] => relate [link] => SecurityGroups [link_type] => relationship_info [source] => non-db [Importable] => [duplicate_merge] => disabled ) [securitygroup_noninherit_id] => Array ( [name] => securitygroup_noninherit_id [type] => varchar [source] => non-db [vname] => LBL_securitygroup_noninherit_id ) [securitygroup_noninheritable] => Array ( [name] => securitygroup_noninheritable [type] => bool [source] => non-db [vname] => LBL_SECURITYGROUP_NONINHERITABLE ) [securitygroup_primary_group] => Array ( [name] => securitygroup_primary_group [type] => bool [source] => non-db [vname] => LBL_PRIMARY_GROUP ) ) [field_defs] => Array ( [id] => Array ( [name] => id [vname] => LBL_ID [type] => id [required] => 1 ) [user_name] => Array ( [name] => user_name [vname] => LBL_USER_NAME [type] => user_name [dbType] => varchar [len] => 60 [importable] => required [required] => 1 [studio] => Array ( [no_duplicate] => 1 [editview] => [detailview] => 1 [quickcreate] => [basic_search] => [advanced_search] => ) ) [user_hash] => Array ( [name] => user_hash [vname] => LBL_USER_HASH [type] => varchar [len] => 255 [reportable] => [importable] => false [sensitive] => 1 [studio] => Array ( [no_duplicate] => 1 [listview] => [searchview] => ) ) [system_generated_password] => Array ( [name] => system_generated_password [vname] => LBL_SYSTEM_GENERATED_PASSWORD [type] => bool [required] => 1 [reportable] => [massupdate] => [studio] => Array ( [listview] => [searchview] => [editview] => [quickcreate] => ) ) [pwd_last_changed] => Array ( [name] => pwd_last_changed [vname] => LBL_PSW_MODIFIED [type] => datetime [required] => [massupdate] => [studio] => Array ( [formula] => ) ) [authenticate_id] => Array ( [name] => authenticate_id [vname] => LBL_AUTHENTICATE_ID [type] => varchar [len] => 100 [reportable] => [importable] => false [studio] => Array ( [listview] => [searchview] => [related] => ) ) [sugar_login] => Array ( [name] => sugar_login [vname] => LBL_SUGAR_LOGIN [type] => bool [default] => 1 [reportable] => [massupdate] => [importable] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [first_name] => Array ( [name] => first_name [vname] => LBL_FIRST_NAME [dbType] => varchar [type] => name [len] => 30 ) [last_name] => Array ( [name] => last_name [vname] => LBL_LAST_NAME [dbType] => varchar [type] => name [len] => 30 [importable] => required [required] => 1 ) [full_name] => Array ( [name] => full_name [rname] => full_name [vname] => LBL_NAME [type] => name [fields] => Array ( [0] => first_name [1] => last_name ) [source] => non-db [sort_on] => last_name [sort_on2] => first_name [db_concat_fields] => Array ( [0] => first_name [1] => last_name ) [len] => 510 [studio] => Array ( [formula] => ) ) [name] => Array ( [name] => name [rname] => name [vname] => LBL_NAME [type] => varchar [source] => non-db [len] => 510 [db_concat_fields] => Array ( [0] => first_name [1] => last_name ) [importable] => false ) [is_admin] => Array ( [name] => is_admin [vname] => LBL_IS_ADMIN [type] => bool [default] => 0 [studio] => Array ( [listview] => [searchview] => [related] => ) ) [external_auth_only] => Array ( [name] => external_auth_only [vname] => LBL_EXT_AUTHENTICATE [type] => bool [reportable] => [massupdate] => [default] => 0 [studio] => Array ( [listview] => [searchview] => [related] => ) ) [receive_notifications] => Array ( [name] => receive_notifications [vname] => LBL_RECEIVE_NOTIFICATIONS [type] => bool [default] => 1 [massupdate] => [studio] => ) [description] => Array ( [name] => description [vname] => LBL_DESCRIPTION [type] => text ) [date_entered] => Array ( [name] => date_entered [vname] => LBL_DATE_ENTERED [type] => datetime [required] => 1 [studio] => Array ( [editview] => [quickcreate] => ) ) [date_modified] => Array ( [name] => date_modified [vname] => LBL_DATE_MODIFIED [type] => datetime [required] => 1 [studio] => Array ( [editview] => [quickcreate] => ) ) [modified_user_id] => Array ( [name] => modified_user_id [rname] => user_name [id_name] => modified_user_id [vname] => LBL_MODIFIED_BY_ID [type] => assigned_user_name [table] => users [isnull] => false [dbType] => id ) [modified_by_name] => Array ( [name] => modified_by_name [vname] => LBL_MODIFIED_BY [type] => varchar [source] => non-db [studio] => ) [created_by] => Array ( [name] => created_by [rname] => user_name [id_name] => modified_user_id [vname] => LBL_ASSIGNED_TO [type] => assigned_user_name [table] => users [isnull] => false [dbType] => id [studio] => ) [created_by_name] => Array ( [name] => created_by_name [vname] => LBL_CREATED_BY_NAME [type] => varchar [source] => non-db [importable] => false ) [title] => Array ( [name] => title [vname] => LBL_TITLE [type] => varchar [len] => 50 ) [photo] => Array ( [name] => photo [vname] => LBL_PHOTO [type] => image [massupdate] => [comments] => [help] => [importable] => [reportable] => 1 [len] => 255 [dbType] => varchar [width] => 160 [height] => 160 ) [department] => Array ( [name] => department [vname] => LBL_DEPARTMENT [type] => varchar [len] => 50 ) [phone_home] => Array ( [name] => phone_home [vname] => LBL_HOME_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_mobile] => Array ( [name] => phone_mobile [vname] => LBL_MOBILE_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_work] => Array ( [name] => phone_work [vname] => LBL_WORK_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_other] => Array ( [name] => phone_other [vname] => LBL_OTHER_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_fax] => Array ( [name] => phone_fax [vname] => LBL_FAX_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [status] => Array ( [name] => status [vname] => LBL_STATUS [type] => enum [len] => 100 [options] => user_status_dom [importable] => required [required] => 1 ) [address_street] => Array ( [name] => address_street [vname] => LBL_ADDRESS_STREET [type] => varchar [len] => 150 ) [address_city] => Array ( [name] => address_city [vname] => LBL_ADDRESS_CITY [type] => varchar [len] => 100 ) [address_state] => Array ( [name] => address_state [vname] => LBL_ADDRESS_STATE [type] => varchar [len] => 100 ) [address_country] => Array ( [name] => address_country [vname] => LBL_ADDRESS_COUNTRY [type] => varchar [len] => 100 ) [address_postalcode] => Array ( [name] => address_postalcode [vname] => LBL_ADDRESS_POSTALCODE [type] => varchar [len] => 20 ) [UserType] => Array ( [name] => UserType [vname] => LBL_USER_TYPE [type] => enum [len] => 50 [options] => user_type_dom [source] => non-db [import] => [reportable] => [studio] => Array ( [formula] => ) ) [deleted] => Array ( [name] => deleted [vname] => LBL_DELETED [type] => bool [required] => [reportable] => ) [portal_only] => Array ( [name] => portal_only [vname] => LBL_PORTAL_ONLY_USER [type] => bool [massupdate] => [default] => 0 [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [show_on_employees] => Array ( [name] => show_on_employees [vname] => LBL_SHOW_ON_EMPLOYEES [type] => bool [massupdate] => 1 [importable] => 1 [default] => 1 [studio] => Array ( [formula] => ) ) [employee_status] => Array ( [name] => employee_status [vname] => LBL_EMPLOYEE_STATUS [type] => varchar [function] => Array ( [name] => getEmployeeStatusOptions [returns] => html [include] => modules/Employees/EmployeeStatus.php ) [len] => 100 ) [messenger_id] => Array ( [name] => messenger_id [vname] => LBL_MESSENGER_ID [type] => varchar [len] => 100 ) [messenger_type] => Array ( [name] => messenger_type [vname] => LBL_MESSENGER_TYPE [type] => enum [options] => messenger_type_dom [len] => 100 ) [calls] => Array ( [name] => calls [type] => link [relationship] => calls_users [source] => non-db [vname] => LBL_CALLS ) [meetings] => Array ( [name] => meetings [type] => link [relationship] => meetings_users [source] => non-db [vname] => LBL_MEETINGS ) [contacts_sync] => Array ( [name] => contacts_sync [type] => link [relationship] => contacts_users [source] => non-db [vname] => LBL_CONTACTS_SYNC [reportable] => ) [reports_to_id] => Array ( [name] => reports_to_id [vname] => LBL_REPORTS_TO_ID [type] => id [required] => ) [reports_to_name] => Array ( [name] => reports_to_name [rname] => last_name [id_name] => reports_to_id [vname] => LBL_REPORTS_TO_NAME [type] => relate [isnull] => true [module] => Users [table] => users [link] => reports_to_link [reportable] => [source] => non-db [duplicate_merge] => disabled [side] => right ) [reports_to_link] => Array ( [name] => reports_to_link [type] => link [relationship] => user_direct_reports [link_type] => one [side] => right [source] => non-db [vname] => LBL_REPORTS_TO ) [reportees] => Array ( [name] => reportees [type] => link [relationship] => user_direct_reports [link_type] => many [side] => left [source] => non-db [vname] => LBL_REPORTS_TO [reportable] => ) [email1] => Array ( [name] => email1 [vname] => LBL_EMAIL [type] => varchar [function] => Array ( [name] => getEmailAddressWidget [returns] => html ) [source] => non-db [group] => email1 [merge_filter] => enabled [required] => 1 ) [email_addresses] => Array ( [name] => email_addresses [type] => link [relationship] => users_email_addresses [module] => EmailAddress [bean_name] => EmailAddress [source] => non-db [vname] => LBL_EMAIL_ADDRESSES [reportable] => [required] => 1 ) [email_addresses_primary] => Array ( [name] => email_addresses_primary [type] => link [relationship] => users_email_addresses_primary [source] => non-db [vname] => LBL_EMAIL_ADDRESS_PRIMARY [duplicate_merge] => disabled [required] => 1 ) [email_link_type] => Array ( [name] => email_link_type [vname] => LBL_EMAIL_LINK_TYPE [type] => enum [options] => dom_email_link_type [importable] => [reportable] => [source] => non-db [studio] => ) [aclroles] => Array ( [name] => aclroles [type] => link [relationship] => acl_roles_users [source] => non-db [side] => right [vname] => LBL_ROLES ) [is_group] => Array ( [name] => is_group [vname] => LBL_GROUP_USER [type] => bool [massupdate] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [c_accept_status_fields] => Array ( [name] => c_accept_status_fields [rname] => id [relationship_fields] => Array ( [id] => accept_status_id [accept_status] => accept_status_name ) [vname] => LBL_LIST_ACCEPT_STATUS [type] => relate [link] => calls [link_type] => relationship_info [source] => non-db [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [m_accept_status_fields] => Array ( [name] => m_accept_status_fields [rname] => id [relationship_fields] => Array ( [id] => accept_status_id [accept_status] => accept_status_name ) [vname] => LBL_LIST_ACCEPT_STATUS [type] => relate [link] => meetings [link_type] => relationship_info [source] => non-db [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [accept_status_id] => Array ( [name] => accept_status_id [type] => varchar [source] => non-db [vname] => LBL_LIST_ACCEPT_STATUS [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [accept_status_name] => Array ( [name] => accept_status_name [type] => enum [source] => non-db [vname] => LBL_LIST_ACCEPT_STATUS [options] => dom_meeting_accept_status [massupdate] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [prospect_lists] => Array ( [name] => prospect_lists [type] => link [relationship] => prospect_list_users [module] => ProspectLists [source] => non-db [vname] => LBL_PROSPECT_LIST ) [emails_users] => Array ( [name] => emails_users [type] => link [relationship] => emails_users_rel [module] => Emails [source] => non-db [vname] => LBL_EMAILS ) [eapm] => Array ( [name] => eapm [type] => link [relationship] => eapm_assigned_user [vname] => LBL_ASSIGNED_TO_USER [source] => non-db ) [oauth_tokens] => Array ( [name] => oauth_tokens [type] => link [relationship] => oauthtokens_assigned_user [vname] => LBL_OAUTH_TOKENS [link_type] => one [module] => OAuthTokens [bean_name] => OAuthToken [source] => non-db [side] => left ) [project_resource] => Array ( [name] => project_resource [type] => link [relationship] => projects_users_resources [source] => non-db [vname] => LBL_PROJECTS ) [project_users_1] => Array ( [name] => project_users_1 [type] => link [relationship] => project_users_1 [source] => non-db [module] => Project [bean_name] => Project [vname] => LBL_PROJECT_USERS_1_FROM_PROJECT_TITLE ) [am_projecttemplates_resources] => Array ( [name] => am_projecttemplates_resources [type] => link [relationship] => am_projecttemplates_users_resources [source] => non-db [vname] => LBL_PROJECTS ) [am_projecttemplates_users_1] => Array ( [name] => am_projecttemplates_users_1 [type] => link [relationship] => am_projecttemplates_users_1 [source] => non-db [module] => AM_ProjectTemplates [bean_name] => AM_ProjectTemplates [vname] => LBL_PROJECT_USERS_1_FROM_PROJECT_TITLE ) [SecurityGroups] => Array ( [name] => SecurityGroups [type] => link [relationship] => securitygroups_users [source] => non-db [module] => SecurityGroups [bean_name] => SecurityGroup [vname] => LBL_SECURITYGROUPS ) [securitygroup_noninher_fields] => Array ( [name] => securitygroup_noninher_fields [rname] => id [relationship_fields] => Array ( [id] => securitygroup_noninherit_id [noninheritable] => securitygroup_noninheritable [primary_group] => securitygroup_primary_group ) [vname] => LBL_USER_NAME [type] => relate [link] => SecurityGroups [link_type] => relationship_info [source] => non-db [Importable] => [duplicate_merge] => disabled ) [securitygroup_noninherit_id] => Array ( [name] => securitygroup_noninherit_id [type] => varchar [source] => non-db [vname] => LBL_securitygroup_noninherit_id ) [securitygroup_noninheritable] => Array ( [name] => securitygroup_noninheritable [type] => bool [source] => non-db [vname] => LBL_SECURITYGROUP_NONINHERITABLE ) [securitygroup_primary_group] => Array ( [name] => securitygroup_primary_group [type] => bool [source] => non-db [vname] => LBL_PRIMARY_GROUP ) ) [custom_fields] => DynamicField Object ( [use_existing_labels] => [base_path] => custom/Extension/modules/Users/Ext/Vardefs [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22923 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [bean] => User Object *RECURSION* [module] => Users ) [column_fields] => Array ( [0] => id [1] => user_name [2] => user_hash [3] => system_generated_password [4] => pwd_last_changed [5] => authenticate_id [6] => sugar_login [7] => first_name [8] => last_name [9] => full_name [10] => name [11] => is_admin [12] => external_auth_only [13] => receive_notifications [14] => description [15] => date_entered [16] => date_modified [17] => modified_user_id [18] => modified_by_name [19] => created_by [20] => created_by_name [21] => title [22] => photo [23] => department [24] => phone_home [25] => phone_mobile [26] => phone_work [27] => phone_other [28] => phone_fax [29] => status [30] => address_street [31] => address_city [32] => address_state [33] => address_country [34] => address_postalcode [35] => UserType [36] => deleted [37] => portal_only [38] => show_on_employees [39] => employee_status [40] => messenger_id [41] => messenger_type [42] => calls [43] => meetings [44] => contacts_sync [45] => reports_to_id [46] => reports_to_name [47] => reports_to_link [48] => reportees [49] => email1 [50] => email_addresses [51] => email_addresses_primary [52] => email_link_type [53] => aclroles [54] => is_group [55] => c_accept_status_fields [56] => m_accept_status_fields [57] => accept_status_id [58] => accept_status_name [59] => prospect_lists [60] => emails_users [61] => eapm [62] => oauth_tokens [63] => project_resource [64] => project_users_1 [65] => am_projecttemplates_resources [66] => am_projecttemplates_users_1 [67] => SecurityGroups [68] => securitygroup_noninher_fields [69] => securitygroup_noninherit_id [70] => securitygroup_noninheritable [71] => securitygroup_primary_group ) [list_fields] => Array ( ) [relationship_fields] => Array ( ) [current_notify_user] => [fetched_row] => Array ( [id] => 883a0b73-6be5-2d01-bf82-591eada7827d [user_name] => JoeBloggs [user_hash] => $1$vGfBvXQ8$EnJOP.V0US/hFIHxe.NJx1 [system_generated_password] => 0 [pwd_last_changed] => 2017-06-01 15:13:00 [authenticate_id] => [sugar_login] => 1 [first_name] => Joe [last_name] => Bloggs [is_admin] => 1 [external_auth_only] => 0 [receive_notifications] => 1 [description] => [date_entered] => 2017-05-19 08:31:27 [date_modified] => 2017-06-01 15:13:57 [modified_user_id] => 883a0b73-6be5-2d01-bf82-591eada7827d [created_by] => 1 [title] => Customer Service Team Leader [photo] => [department] => [phone_home] => [phone_mobile] => [phone_work] => [phone_other] => [phone_fax] => [status] => Active [address_street] => [address_city] => [address_state] => [address_country] => [address_postalcode] => [deleted] => 0 [portal_only] => 0 [show_on_employees] => 1 [employee_status] => Active [messenger_id] => [messenger_type] => [reports_to_id] => [is_group] => 0 [email1] => Joe.Bloggs@example.com ) [fetched_rel_row] => Array ( ) [layout_def] => [force_load_details] => [optimistic_lock] => [disable_custom_fields] => [number_formatting_done] => [process_field_encrypted] => [acltype] => module [additional_meta_fields] => Array ( ) [notify_inworkflow] => [assigned_user_id] => [special_notification] => [in_workflow] => [tracker_visibility] => 1 [listview_inner_join] => Array ( ) [in_import] => [in_save] => [logicHookDepth] => Array ( [before_retrieve] => 0 [after_retrieve] => 0 ) [max_logic_depth:protected] => 10 [loaded_relationships:protected] => Array ( [0] => reports_to_link ) [is_updated_dependent_fields:protected] => [required_fields] => Array ( [id] => 1 [user_name] => 1 [system_generated_password] => 1 [last_name] => 1 [date_entered] => 1 [date_modified] => 1 [status] => 1 [email1] => 1 [email_addresses] => 1 [email_addresses_primary] => 1 ) [added_custom_field_defs] => 1 [acl_fields] => 1 [sugar_login] => 1 [external_auth_only] => 0 [show_on_employees] => 1 [system_generated_password] => 0 [pwd_last_changed] => 01/06/2017 15:13 [authenticate_id] => [UserType] => [calls] => [meetings] => [contacts_sync] => [reports_to_link] => Link2 Object ( [relationship:protected] => One2MBeanRelationship Object ( [type] => one-to-many [def:protected] => Array ( [name] => user_direct_reports [lhs_module] => Users [lhs_table] => users [lhs_key] => id [rhs_module] => Users [rhs_table] => users [rhs_key] => reports_to_id [relationship_type] => one-to-many ) [lhsLink:protected] => reportees [rhsLink:protected] => reports_to_link [ignore_role_filter:protected] => [self_referencing:protected] => [name] => user_direct_reports [selfReferencing] => 1 [lhsLinkDef] => Array ( [name] => reportees [type] => link [relationship] => user_direct_reports [link_type] => many [side] => left [source] => non-db [vname] => LBL_REPORTS_TO [reportable] => ) [rhsLinkDef] => Array ( [name] => reports_to_link [type] => link [relationship] => user_direct_reports [link_type] => one [side] => right [source] => non-db [vname] => LBL_REPORTS_TO ) ) [focus:protected] => User Object *RECURSION* [def:protected] => Array ( [name] => reports_to_link [type] => link [relationship] => user_direct_reports [link_type] => one [side] => right [source] => non-db [vname] => LBL_REPORTS_TO ) [name:protected] => reports_to_link [beans:protected] => [rows:protected] => Array ( ) [loaded:protected] => 1 [relationship_fields:protected] => Array ( ) [tempBeans:protected] => Array ( ) ) [reportees] => [email_addresses_primary] => [email_link_type] => [aclroles] => [c_accept_status_fields] => [m_accept_status_fields] => [accept_status_id] => [accept_status_name] => [prospect_lists] => [emails_users] => [eapm] => [oauth_tokens] => [project_resource] => [project_users_1] => [am_projecttemplates_resources] => [am_projecttemplates_users_1] => [SecurityGroups] => [securitygroup_noninher_fields] => [securitygroup_noninherit_id] => [securitygroup_noninheritable] => [securitygroup_primary_group] => [relDepth] => 0 [email_opt_out] => 0 [invalid_email] => 0 ) User Object ( [name] => Administrator [full_name] => Administrator [id] => 1 [user_name] => admin [user_hash] => $1$I4MMdqc5$RHx5Gkzx2N3vsYC8uRtCi0 [salutation] => [first_name] => [last_name] => Administrator [date_entered] => 19/05/2017 08:27 [date_modified] => 19/05/2017 08:27 [modified_user_id] => 1 [created_by] => [created_by_name] => [modified_by_name] => Administrator [description] => [phone_home] => [phone_mobile] => [phone_work] => [phone_other] => [phone_fax] => [email1] => Joe.Bloggs@example.com [email2] => [address_street] => [address_city] => [address_state] => [address_postalcode] => [address_country] => [status] => Active [title] => Administrator [photo] => [portal_only] => 0 [department] => [authenticated] => [error_string] => [is_admin] => 1 [employee_status] => Active [messenger_id] => [messenger_type] => [is_group] => 0 [accept_status] => [team_id] => [receive_notifications] => 1 [reports_to_name] => [reports_to_id] => [team_exists] => [table_name] => users [module_dir] => Users [object_name] => User [user_preferences] => [importable] => 1 [_userPreferenceFocus] => UserPreference Object ( [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22924 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [field_name_map] => Array ( [id] => Array ( [name] => id [vname] => LBL_NAME [type] => id [required] => 1 [reportable] => ) [category] => Array ( [name] => category [type] => varchar [len] => 50 ) [deleted] => Array ( [name] => deleted [type] => bool [default] => 0 [required] => ) [date_entered] => Array ( [name] => date_entered [type] => datetime [required] => 1 ) [date_modified] => Array ( [name] => date_modified [type] => datetime [required] => 1 ) [assigned_user_id] => Array ( [name] => assigned_user_id [rname] => user_name [id_name] => assigned_user_id [type] => assigned_user_name [table] => users [required] => 1 [dbType] => id ) [assigned_user_name] => Array ( [name] => assigned_user_name [vname] => LBL_ASSIGNED_TO_NAME [type] => varchar [reportable] => [massupdate] => [source] => non-db [table] => users ) [contents] => Array ( [name] => contents [type] => longtext [vname] => LBL_DESCRIPTION [isnull] => 1 ) ) [id] => [date_entered] => [date_modified] => [assigned_user_id] => [assigned_user_name] => [name] => [category] => [contents] => [deleted] => 0 [object_name] => UserPreference [table_name] => user_preferences [disable_row_level_security] => 1 [module_dir] => UserPreferences [field_defs] => Array ( [id] => Array ( [name] => id [vname] => LBL_NAME [type] => id [required] => 1 [reportable] => ) [category] => Array ( [name] => category [type] => varchar [len] => 50 ) [deleted] => Array ( [name] => deleted [type] => bool [default] => 0 [required] => ) [date_entered] => Array ( [name] => date_entered [type] => datetime [required] => 1 ) [date_modified] => Array ( [name] => date_modified [type] => datetime [required] => 1 ) [assigned_user_id] => Array ( [name] => assigned_user_id [rname] => user_name [id_name] => assigned_user_id [type] => assigned_user_name [table] => users [required] => 1 [dbType] => id ) [assigned_user_name] => Array ( [name] => assigned_user_name [vname] => LBL_ASSIGNED_TO_NAME [type] => varchar [reportable] => [massupdate] => [source] => non-db [table] => users ) [contents] => Array ( [name] => contents [type] => longtext [vname] => LBL_DESCRIPTION [isnull] => 1 ) ) [field_defs_map] => Array ( ) [new_schema] => 1 [_userFocus:protected] => User Object *RECURSION* [new_with_id] => [disable_vardefs] => [new_assigned_user_name] => [processed_dates_times] => Array ( ) [process_save_dates] => 1 [save_from_post] => 1 [duplicates_found] => [update_date_modified] => 1 [update_modified_by] => 1 [update_date_entered] => [set_created_by] => 1 [ungreedy_count] => [module_name] => UserPreferences [custom_fields] => DynamicField Object ( [use_existing_labels] => [base_path] => custom/Extension/modules/UserPreferences/Ext/Vardefs [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22925 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [bean] => UserPreference Object *RECURSION* [module] => UserPreferences ) [column_fields] => Array ( [0] => id [1] => category [2] => deleted [3] => date_entered [4] => date_modified [5] => assigned_user_id [6] => assigned_user_name [7] => contents ) [list_fields] => Array ( ) [additional_column_fields] => Array ( ) [relationship_fields] => Array ( ) [current_notify_user] => [fetched_row] => [fetched_rel_row] => Array ( ) [layout_def] => [force_load_details] => [optimistic_lock] => [disable_custom_fields] => [number_formatting_done] => [process_field_encrypted] => [acltype] => module [additional_meta_fields] => Array ( ) [notify_inworkflow] => [description] => [modified_user_id] => [created_by] => [created_by_name] => [modified_by_name] => [importable] => [special_notification] => [in_workflow] => [tracker_visibility] => [listview_inner_join] => Array ( ) [in_import] => [in_save] => [logicHookDepth] => [max_logic_depth:protected] => 10 [loaded_relationships:protected] => Array ( ) [is_updated_dependent_fields:protected] => [required_fields] => Array ( [id] => 1 [date_entered] => 1 [date_modified] => 1 [assigned_user_id] => 1 ) [added_custom_field_defs] => 1 ) [encodeFields] => Array ( [0] => first_name [1] => last_name [2] => description ) [additional_column_fields] => Array ( [0] => reports_to_name ) [emailAddress] => SugarEmailAddress Object ( [table_name] => email_addresses [module_name] => EmailAddresses [module_dir] => EmailAddresses [object_name] => EmailAddress [regex] => /^(?:['\.\-\+&#!$\*=\?\^_`\{\}~\/\w]+)@(?:(?:\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})|\w+(?:[\.-]*\w+)*(?:\.[\w-]{2,})+)$/ [disable_custom_fields] => 1 [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22926 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [smarty] => [addresses] => Array ( [0] => Array ( [email_address] => Joe.Bloggs@example.com [email_address_caps] => Joe.Bloggs@example.COM [invalid_email] => 0 [opt_out] => 0 [date_created] => 2017-05-19 08:27:38 [date_modified] => 2017-05-19 08:27:38 [id] => 13818802-c058-cb51-d689-591eac172764 [email_address_id] => 139b37a9-bcec-6da3-bad1-591eaccd0b72 [bean_id] => 1 [bean_module] => Users [primary_address] => 1 [reply_to_address] => 0 [deleted] => 0 ) ) [view] => [stateBeforeWorkflow:SugarEmailAddress:private] => [email_address] => [id] => [new_with_id] => [disable_vardefs] => [new_assigned_user_name] => [processed_dates_times] => Array ( ) [process_save_dates] => 1 [save_from_post] => 1 [duplicates_found] => [deleted] => 0 [update_date_modified] => 1 [update_modified_by] => 1 [update_date_entered] => [set_created_by] => 1 [ungreedy_count] => [field_name_map] => Array ( [id] => Array ( [name] => id [type] => id [vname] => LBL_EMAIL_ADDRESS_ID [required] => 1 ) [email_address] => Array ( [name] => email_address [type] => varchar [vname] => LBL_EMAIL_ADDRESS [length] => 100 [required] => 1 ) [email_address_caps] => Array ( [name] => email_address_caps [type] => varchar [vname] => LBL_EMAIL_ADDRESS_CAPS [length] => 100 [required] => 1 [reportable] => ) [invalid_email] => Array ( [name] => invalid_email [type] => bool [default] => 0 [vname] => LBL_INVALID_EMAIL ) [opt_out] => Array ( [name] => opt_out [type] => bool [default] => 0 [vname] => LBL_OPT_OUT ) [date_created] => Array ( [name] => date_created [type] => datetime [vname] => LBL_DATE_CREATE ) [date_modified] => Array ( [name] => date_modified [type] => datetime [vname] => LBL_DATE_MODIFIED ) [deleted] => Array ( [name] => deleted [type] => bool [default] => 0 [vname] => LBL_DELETED ) ) [field_defs] => Array ( [id] => Array ( [name] => id [type] => id [vname] => LBL_EMAIL_ADDRESS_ID [required] => 1 ) [email_address] => Array ( [name] => email_address [type] => varchar [vname] => LBL_EMAIL_ADDRESS [length] => 100 [required] => 1 ) [email_address_caps] => Array ( [name] => email_address_caps [type] => varchar [vname] => LBL_EMAIL_ADDRESS_CAPS [length] => 100 [required] => 1 [reportable] => ) [invalid_email] => Array ( [name] => invalid_email [type] => bool [default] => 0 [vname] => LBL_INVALID_EMAIL ) [opt_out] => Array ( [name] => opt_out [type] => bool [default] => 0 [vname] => LBL_OPT_OUT ) [date_created] => Array ( [name] => date_created [type] => datetime [vname] => LBL_DATE_CREATE ) [date_modified] => Array ( [name] => date_modified [type] => datetime [vname] => LBL_DATE_MODIFIED ) [deleted] => Array ( [name] => deleted [type] => bool [default] => 0 [vname] => LBL_DELETED ) ) [custom_fields] => [column_fields] => Array ( [0] => id [1] => email_address [2] => email_address_caps [3] => invalid_email [4] => opt_out [5] => date_created [6] => date_modified [7] => deleted ) [list_fields] => Array ( ) [additional_column_fields] => Array ( ) [relationship_fields] => Array ( ) [current_notify_user] => [fetched_row] => [fetched_rel_row] => Array ( ) [layout_def] => [force_load_details] => [optimistic_lock] => [number_formatting_done] => [process_field_encrypted] => [acltype] => module [additional_meta_fields] => Array ( ) [notify_inworkflow] => [name] => [description] => [date_entered] => [date_modified] => [modified_user_id] => [assigned_user_id] => [created_by] => [created_by_name] => [modified_by_name] => [importable] => [special_notification] => [in_workflow] => [tracker_visibility] => 1 [listview_inner_join] => Array ( ) [in_import] => [in_save] => [logicHookDepth] => [max_logic_depth:protected] => 10 [loaded_relationships:protected] => Array ( ) [is_updated_dependent_fields:protected] => [required_fields] => Array ( [id] => 1 [email_address] => 1 [email_address_caps] => 1 ) [added_custom_field_defs] => 1 [invalid_email] => 0 [opt_out] => 0 [index] => 2 ) [new_schema] => 1 [createLocaleFormattedName] => 1 [email_addresses] => [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22927 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [new_with_id] => [disable_vardefs] => [new_assigned_user_name] => [processed_dates_times] => Array ( [id] => 1 [user_name] => 1 [user_hash] => 1 [system_generated_password] => 1 [pwd_last_changed] => 1 [authenticate_id] => 1 [sugar_login] => 1 [first_name] => 1 [last_name] => 1 [full_name] => 1 [name] => 1 [is_admin] => 1 [external_auth_only] => 1 [receive_notifications] => 1 [description] => 1 [date_entered] => 1 [date_modified] => 1 [modified_user_id] => 1 [modified_by_name] => 1 [created_by] => 1 [created_by_name] => 1 [title] => 1 [photo] => 1 [department] => 1 [phone_home] => 1 [phone_mobile] => 1 [phone_work] => 1 [phone_other] => 1 [phone_fax] => 1 [status] => 1 [address_street] => 1 [address_city] => 1 [address_state] => 1 [address_country] => 1 [address_postalcode] => 1 [UserType] => 1 [deleted] => 1 [portal_only] => 1 [show_on_employees] => 1 [employee_status] => 1 [messenger_id] => 1 [messenger_type] => 1 [calls] => 1 [meetings] => 1 [contacts_sync] => 1 [reports_to_id] => 1 [reports_to_name] => 1 [reports_to_link] => 1 [reportees] => 1 [email1] => 1 [email_addresses] => 1 [email_addresses_primary] => 1 [email_link_type] => 1 [aclroles] => 1 [is_group] => 1 [c_accept_status_fields] => 1 [m_accept_status_fields] => 1 [accept_status_id] => 1 [accept_status_name] => 1 [prospect_lists] => 1 [emails_users] => 1 [eapm] => 1 [oauth_tokens] => 1 [project_resource] => 1 [project_users_1] => 1 [am_projecttemplates_resources] => 1 [am_projecttemplates_users_1] => 1 [SecurityGroups] => 1 [securitygroup_noninher_fields] => 1 [securitygroup_noninherit_id] => 1 [securitygroup_noninheritable] => 1 [securitygroup_primary_group] => 1 ) [process_save_dates] => 1 [save_from_post] => 1 [duplicates_found] => [deleted] => 0 [update_date_modified] => 1 [update_modified_by] => 1 [update_date_entered] => [set_created_by] => 1 [ungreedy_count] => [module_name] => Users [field_name_map] => Array ( [id] => Array ( [name] => id [vname] => LBL_ID [type] => id [required] => 1 ) [user_name] => Array ( [name] => user_name [vname] => LBL_USER_NAME [type] => user_name [dbType] => varchar [len] => 60 [importable] => required [required] => 1 [studio] => Array ( [no_duplicate] => 1 [editview] => [detailview] => 1 [quickcreate] => [basic_search] => [advanced_search] => ) ) [user_hash] => Array ( [name] => user_hash [vname] => LBL_USER_HASH [type] => varchar [len] => 255 [reportable] => [importable] => false [sensitive] => 1 [studio] => Array ( [no_duplicate] => 1 [listview] => [searchview] => ) ) [system_generated_password] => Array ( [name] => system_generated_password [vname] => LBL_SYSTEM_GENERATED_PASSWORD [type] => bool [required] => 1 [reportable] => [massupdate] => [studio] => Array ( [listview] => [searchview] => [editview] => [quickcreate] => ) ) [pwd_last_changed] => Array ( [name] => pwd_last_changed [vname] => LBL_PSW_MODIFIED [type] => datetime [required] => [massupdate] => [studio] => Array ( [formula] => ) ) [authenticate_id] => Array ( [name] => authenticate_id [vname] => LBL_AUTHENTICATE_ID [type] => varchar [len] => 100 [reportable] => [importable] => false [studio] => Array ( [listview] => [searchview] => [related] => ) ) [sugar_login] => Array ( [name] => sugar_login [vname] => LBL_SUGAR_LOGIN [type] => bool [default] => 1 [reportable] => [massupdate] => [importable] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [first_name] => Array ( [name] => first_name [vname] => LBL_FIRST_NAME [dbType] => varchar [type] => name [len] => 30 ) [last_name] => Array ( [name] => last_name [vname] => LBL_LAST_NAME [dbType] => varchar [type] => name [len] => 30 [importable] => required [required] => 1 ) [full_name] => Array ( [name] => full_name [rname] => full_name [vname] => LBL_NAME [type] => name [fields] => Array ( [0] => first_name [1] => last_name ) [source] => non-db [sort_on] => last_name [sort_on2] => first_name [db_concat_fields] => Array ( [0] => first_name [1] => last_name ) [len] => 510 [studio] => Array ( [formula] => ) ) [name] => Array ( [name] => name [rname] => name [vname] => LBL_NAME [type] => varchar [source] => non-db [len] => 510 [db_concat_fields] => Array ( [0] => first_name [1] => last_name ) [importable] => false ) [is_admin] => Array ( [name] => is_admin [vname] => LBL_IS_ADMIN [type] => bool [default] => 0 [studio] => Array ( [listview] => [searchview] => [related] => ) ) [external_auth_only] => Array ( [name] => external_auth_only [vname] => LBL_EXT_AUTHENTICATE [type] => bool [reportable] => [massupdate] => [default] => 0 [studio] => Array ( [listview] => [searchview] => [related] => ) ) [receive_notifications] => Array ( [name] => receive_notifications [vname] => LBL_RECEIVE_NOTIFICATIONS [type] => bool [default] => 1 [massupdate] => [studio] => ) [description] => Array ( [name] => description [vname] => LBL_DESCRIPTION [type] => text ) [date_entered] => Array ( [name] => date_entered [vname] => LBL_DATE_ENTERED [type] => datetime [required] => 1 [studio] => Array ( [editview] => [quickcreate] => ) ) [date_modified] => Array ( [name] => date_modified [vname] => LBL_DATE_MODIFIED [type] => datetime [required] => 1 [studio] => Array ( [editview] => [quickcreate] => ) ) [modified_user_id] => Array ( [name] => modified_user_id [rname] => user_name [id_name] => modified_user_id [vname] => LBL_MODIFIED_BY_ID [type] => assigned_user_name [table] => users [isnull] => false [dbType] => id ) [modified_by_name] => Array ( [name] => modified_by_name [vname] => LBL_MODIFIED_BY [type] => varchar [source] => non-db [studio] => ) [created_by] => Array ( [name] => created_by [rname] => user_name [id_name] => modified_user_id [vname] => LBL_ASSIGNED_TO [type] => assigned_user_name [table] => users [isnull] => false [dbType] => id [studio] => ) [created_by_name] => Array ( [name] => created_by_name [vname] => LBL_CREATED_BY_NAME [type] => varchar [source] => non-db [importable] => false ) [title] => Array ( [name] => title [vname] => LBL_TITLE [type] => varchar [len] => 50 ) [photo] => Array ( [name] => photo [vname] => LBL_PHOTO [type] => image [massupdate] => [comments] => [help] => [importable] => [reportable] => 1 [len] => 255 [dbType] => varchar [width] => 160 [height] => 160 ) [department] => Array ( [name] => department [vname] => LBL_DEPARTMENT [type] => varchar [len] => 50 ) [phone_home] => Array ( [name] => phone_home [vname] => LBL_HOME_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_mobile] => Array ( [name] => phone_mobile [vname] => LBL_MOBILE_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_work] => Array ( [name] => phone_work [vname] => LBL_WORK_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_other] => Array ( [name] => phone_other [vname] => LBL_OTHER_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_fax] => Array ( [name] => phone_fax [vname] => LBL_FAX_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [status] => Array ( [name] => status [vname] => LBL_STATUS [type] => enum [len] => 100 [options] => user_status_dom [importable] => required [required] => 1 ) [address_street] => Array ( [name] => address_street [vname] => LBL_ADDRESS_STREET [type] => varchar [len] => 150 ) [address_city] => Array ( [name] => address_city [vname] => LBL_ADDRESS_CITY [type] => varchar [len] => 100 ) [address_state] => Array ( [name] => address_state [vname] => LBL_ADDRESS_STATE [type] => varchar [len] => 100 ) [address_country] => Array ( [name] => address_country [vname] => LBL_ADDRESS_COUNTRY [type] => varchar [len] => 100 ) [address_postalcode] => Array ( [name] => address_postalcode [vname] => LBL_ADDRESS_POSTALCODE [type] => varchar [len] => 20 ) [UserType] => Array ( [name] => UserType [vname] => LBL_USER_TYPE [type] => enum [len] => 50 [options] => user_type_dom [source] => non-db [import] => [reportable] => [studio] => Array ( [formula] => ) ) [deleted] => Array ( [name] => deleted [vname] => LBL_DELETED [type] => bool [required] => [reportable] => ) [portal_only] => Array ( [name] => portal_only [vname] => LBL_PORTAL_ONLY_USER [type] => bool [massupdate] => [default] => 0 [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [show_on_employees] => Array ( [name] => show_on_employees [vname] => LBL_SHOW_ON_EMPLOYEES [type] => bool [massupdate] => 1 [importable] => 1 [default] => 1 [studio] => Array ( [formula] => ) ) [employee_status] => Array ( [name] => employee_status [vname] => LBL_EMPLOYEE_STATUS [type] => varchar [function] => Array ( [name] => getEmployeeStatusOptions [returns] => html [include] => modules/Employees/EmployeeStatus.php ) [len] => 100 ) [messenger_id] => Array ( [name] => messenger_id [vname] => LBL_MESSENGER_ID [type] => varchar [len] => 100 ) [messenger_type] => Array ( [name] => messenger_type [vname] => LBL_MESSENGER_TYPE [type] => enum [options] => messenger_type_dom [len] => 100 ) [calls] => Array ( [name] => calls [type] => link [relationship] => calls_users [source] => non-db [vname] => LBL_CALLS ) [meetings] => Array ( [name] => meetings [type] => link [relationship] => meetings_users [source] => non-db [vname] => LBL_MEETINGS ) [contacts_sync] => Array ( [name] => contacts_sync [type] => link [relationship] => contacts_users [source] => non-db [vname] => LBL_CONTACTS_SYNC [reportable] => ) [reports_to_id] => Array ( [name] => reports_to_id [vname] => LBL_REPORTS_TO_ID [type] => id [required] => ) [reports_to_name] => Array ( [name] => reports_to_name [rname] => last_name [id_name] => reports_to_id [vname] => LBL_REPORTS_TO_NAME [type] => relate [isnull] => true [module] => Users [table] => users [link] => reports_to_link [reportable] => [source] => non-db [duplicate_merge] => disabled [side] => right ) [reports_to_link] => Array ( [name] => reports_to_link [type] => link [relationship] => user_direct_reports [link_type] => one [side] => right [source] => non-db [vname] => LBL_REPORTS_TO ) [reportees] => Array ( [name] => reportees [type] => link [relationship] => user_direct_reports [link_type] => many [side] => left [source] => non-db [vname] => LBL_REPORTS_TO [reportable] => ) [email1] => Array ( [name] => email1 [vname] => LBL_EMAIL [type] => varchar [function] => Array ( [name] => getEmailAddressWidget [returns] => html ) [source] => non-db [group] => email1 [merge_filter] => enabled [required] => 1 ) [email_addresses] => Array ( [name] => email_addresses [type] => link [relationship] => users_email_addresses [module] => EmailAddress [bean_name] => EmailAddress [source] => non-db [vname] => LBL_EMAIL_ADDRESSES [reportable] => [required] => 1 ) [email_addresses_primary] => Array ( [name] => email_addresses_primary [type] => link [relationship] => users_email_addresses_primary [source] => non-db [vname] => LBL_EMAIL_ADDRESS_PRIMARY [duplicate_merge] => disabled [required] => 1 ) [email_link_type] => Array ( [name] => email_link_type [vname] => LBL_EMAIL_LINK_TYPE [type] => enum [options] => dom_email_link_type [importable] => [reportable] => [source] => non-db [studio] => ) [aclroles] => Array ( [name] => aclroles [type] => link [relationship] => acl_roles_users [source] => non-db [side] => right [vname] => LBL_ROLES ) [is_group] => Array ( [name] => is_group [vname] => LBL_GROUP_USER [type] => bool [massupdate] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [c_accept_status_fields] => Array ( [name] => c_accept_status_fields [rname] => id [relationship_fields] => Array ( [id] => accept_status_id [accept_status] => accept_status_name ) [vname] => LBL_LIST_ACCEPT_STATUS [type] => relate [link] => calls [link_type] => relationship_info [source] => non-db [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [m_accept_status_fields] => Array ( [name] => m_accept_status_fields [rname] => id [relationship_fields] => Array ( [id] => accept_status_id [accept_status] => accept_status_name ) [vname] => LBL_LIST_ACCEPT_STATUS [type] => relate [link] => meetings [link_type] => relationship_info [source] => non-db [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [accept_status_id] => Array ( [name] => accept_status_id [type] => varchar [source] => non-db [vname] => LBL_LIST_ACCEPT_STATUS [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [accept_status_name] => Array ( [name] => accept_status_name [type] => enum [source] => non-db [vname] => LBL_LIST_ACCEPT_STATUS [options] => dom_meeting_accept_status [massupdate] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [prospect_lists] => Array ( [name] => prospect_lists [type] => link [relationship] => prospect_list_users [module] => ProspectLists [source] => non-db [vname] => LBL_PROSPECT_LIST ) [emails_users] => Array ( [name] => emails_users [type] => link [relationship] => emails_users_rel [module] => Emails [source] => non-db [vname] => LBL_EMAILS ) [eapm] => Array ( [name] => eapm [type] => link [relationship] => eapm_assigned_user [vname] => LBL_ASSIGNED_TO_USER [source] => non-db ) [oauth_tokens] => Array ( [name] => oauth_tokens [type] => link [relationship] => oauthtokens_assigned_user [vname] => LBL_OAUTH_TOKENS [link_type] => one [module] => OAuthTokens [bean_name] => OAuthToken [source] => non-db [side] => left ) [project_resource] => Array ( [name] => project_resource [type] => link [relationship] => projects_users_resources [source] => non-db [vname] => LBL_PROJECTS ) [project_users_1] => Array ( [name] => project_users_1 [type] => link [relationship] => project_users_1 [source] => non-db [module] => Project [bean_name] => Project [vname] => LBL_PROJECT_USERS_1_FROM_PROJECT_TITLE ) [am_projecttemplates_resources] => Array ( [name] => am_projecttemplates_resources [type] => link [relationship] => am_projecttemplates_users_resources [source] => non-db [vname] => LBL_PROJECTS ) [am_projecttemplates_users_1] => Array ( [name] => am_projecttemplates_users_1 [type] => link [relationship] => am_projecttemplates_users_1 [source] => non-db [module] => AM_ProjectTemplates [bean_name] => AM_ProjectTemplates [vname] => LBL_PROJECT_USERS_1_FROM_PROJECT_TITLE ) [SecurityGroups] => Array ( [name] => SecurityGroups [type] => link [relationship] => securitygroups_users [source] => non-db [module] => SecurityGroups [bean_name] => SecurityGroup [vname] => LBL_SECURITYGROUPS ) [securitygroup_noninher_fields] => Array ( [name] => securitygroup_noninher_fields [rname] => id [relationship_fields] => Array ( [id] => securitygroup_noninherit_id [noninheritable] => securitygroup_noninheritable [primary_group] => securitygroup_primary_group ) [vname] => LBL_USER_NAME [type] => relate [link] => SecurityGroups [link_type] => relationship_info [source] => non-db [Importable] => [duplicate_merge] => disabled ) [securitygroup_noninherit_id] => Array ( [name] => securitygroup_noninherit_id [type] => varchar [source] => non-db [vname] => LBL_securitygroup_noninherit_id ) [securitygroup_noninheritable] => Array ( [name] => securitygroup_noninheritable [type] => bool [source] => non-db [vname] => LBL_SECURITYGROUP_NONINHERITABLE ) [securitygroup_primary_group] => Array ( [name] => securitygroup_primary_group [type] => bool [source] => non-db [vname] => LBL_PRIMARY_GROUP ) ) [field_defs] => Array ( [id] => Array ( [name] => id [vname] => LBL_ID [type] => id [required] => 1 ) [user_name] => Array ( [name] => user_name [vname] => LBL_USER_NAME [type] => user_name [dbType] => varchar [len] => 60 [importable] => required [required] => 1 [studio] => Array ( [no_duplicate] => 1 [editview] => [detailview] => 1 [quickcreate] => [basic_search] => [advanced_search] => ) ) [user_hash] => Array ( [name] => user_hash [vname] => LBL_USER_HASH [type] => varchar [len] => 255 [reportable] => [importable] => false [sensitive] => 1 [studio] => Array ( [no_duplicate] => 1 [listview] => [searchview] => ) ) [system_generated_password] => Array ( [name] => system_generated_password [vname] => LBL_SYSTEM_GENERATED_PASSWORD [type] => bool [required] => 1 [reportable] => [massupdate] => [studio] => Array ( [listview] => [searchview] => [editview] => [quickcreate] => ) ) [pwd_last_changed] => Array ( [name] => pwd_last_changed [vname] => LBL_PSW_MODIFIED [type] => datetime [required] => [massupdate] => [studio] => Array ( [formula] => ) ) [authenticate_id] => Array ( [name] => authenticate_id [vname] => LBL_AUTHENTICATE_ID [type] => varchar [len] => 100 [reportable] => [importable] => false [studio] => Array ( [listview] => [searchview] => [related] => ) ) [sugar_login] => Array ( [name] => sugar_login [vname] => LBL_SUGAR_LOGIN [type] => bool [default] => 1 [reportable] => [massupdate] => [importable] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [first_name] => Array ( [name] => first_name [vname] => LBL_FIRST_NAME [dbType] => varchar [type] => name [len] => 30 ) [last_name] => Array ( [name] => last_name [vname] => LBL_LAST_NAME [dbType] => varchar [type] => name [len] => 30 [importable] => required [required] => 1 ) [full_name] => Array ( [name] => full_name [rname] => full_name [vname] => LBL_NAME [type] => name [fields] => Array ( [0] => first_name [1] => last_name ) [source] => non-db [sort_on] => last_name [sort_on2] => first_name [db_concat_fields] => Array ( [0] => first_name [1] => last_name ) [len] => 510 [studio] => Array ( [formula] => ) ) [name] => Array ( [name] => name [rname] => name [vname] => LBL_NAME [type] => varchar [source] => non-db [len] => 510 [db_concat_fields] => Array ( [0] => first_name [1] => last_name ) [importable] => false ) [is_admin] => Array ( [name] => is_admin [vname] => LBL_IS_ADMIN [type] => bool [default] => 0 [studio] => Array ( [listview] => [searchview] => [related] => ) ) [external_auth_only] => Array ( [name] => external_auth_only [vname] => LBL_EXT_AUTHENTICATE [type] => bool [reportable] => [massupdate] => [default] => 0 [studio] => Array ( [listview] => [searchview] => [related] => ) ) [receive_notifications] => Array ( [name] => receive_notifications [vname] => LBL_RECEIVE_NOTIFICATIONS [type] => bool [default] => 1 [massupdate] => [studio] => ) [description] => Array ( [name] => description [vname] => LBL_DESCRIPTION [type] => text ) [date_entered] => Array ( [name] => date_entered [vname] => LBL_DATE_ENTERED [type] => datetime [required] => 1 [studio] => Array ( [editview] => [quickcreate] => ) ) [date_modified] => Array ( [name] => date_modified [vname] => LBL_DATE_MODIFIED [type] => datetime [required] => 1 [studio] => Array ( [editview] => [quickcreate] => ) ) [modified_user_id] => Array ( [name] => modified_user_id [rname] => user_name [id_name] => modified_user_id [vname] => LBL_MODIFIED_BY_ID [type] => assigned_user_name [table] => users [isnull] => false [dbType] => id ) [modified_by_name] => Array ( [name] => modified_by_name [vname] => LBL_MODIFIED_BY [type] => varchar [source] => non-db [studio] => ) [created_by] => Array ( [name] => created_by [rname] => user_name [id_name] => modified_user_id [vname] => LBL_ASSIGNED_TO [type] => assigned_user_name [table] => users [isnull] => false [dbType] => id [studio] => ) [created_by_name] => Array ( [name] => created_by_name [vname] => LBL_CREATED_BY_NAME [type] => varchar [source] => non-db [importable] => false ) [title] => Array ( [name] => title [vname] => LBL_TITLE [type] => varchar [len] => 50 ) [photo] => Array ( [name] => photo [vname] => LBL_PHOTO [type] => image [massupdate] => [comments] => [help] => [importable] => [reportable] => 1 [len] => 255 [dbType] => varchar [width] => 160 [height] => 160 ) [department] => Array ( [name] => department [vname] => LBL_DEPARTMENT [type] => varchar [len] => 50 ) [phone_home] => Array ( [name] => phone_home [vname] => LBL_HOME_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_mobile] => Array ( [name] => phone_mobile [vname] => LBL_MOBILE_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_work] => Array ( [name] => phone_work [vname] => LBL_WORK_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_other] => Array ( [name] => phone_other [vname] => LBL_OTHER_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [phone_fax] => Array ( [name] => phone_fax [vname] => LBL_FAX_PHONE [type] => phone [dbType] => varchar [len] => 50 ) [status] => Array ( [name] => status [vname] => LBL_STATUS [type] => enum [len] => 100 [options] => user_status_dom [importable] => required [required] => 1 ) [address_street] => Array ( [name] => address_street [vname] => LBL_ADDRESS_STREET [type] => varchar [len] => 150 ) [address_city] => Array ( [name] => address_city [vname] => LBL_ADDRESS_CITY [type] => varchar [len] => 100 ) [address_state] => Array ( [name] => address_state [vname] => LBL_ADDRESS_STATE [type] => varchar [len] => 100 ) [address_country] => Array ( [name] => address_country [vname] => LBL_ADDRESS_COUNTRY [type] => varchar [len] => 100 ) [address_postalcode] => Array ( [name] => address_postalcode [vname] => LBL_ADDRESS_POSTALCODE [type] => varchar [len] => 20 ) [UserType] => Array ( [name] => UserType [vname] => LBL_USER_TYPE [type] => enum [len] => 50 [options] => user_type_dom [source] => non-db [import] => [reportable] => [studio] => Array ( [formula] => ) ) [deleted] => Array ( [name] => deleted [vname] => LBL_DELETED [type] => bool [required] => [reportable] => ) [portal_only] => Array ( [name] => portal_only [vname] => LBL_PORTAL_ONLY_USER [type] => bool [massupdate] => [default] => 0 [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [show_on_employees] => Array ( [name] => show_on_employees [vname] => LBL_SHOW_ON_EMPLOYEES [type] => bool [massupdate] => 1 [importable] => 1 [default] => 1 [studio] => Array ( [formula] => ) ) [employee_status] => Array ( [name] => employee_status [vname] => LBL_EMPLOYEE_STATUS [type] => varchar [function] => Array ( [name] => getEmployeeStatusOptions [returns] => html [include] => modules/Employees/EmployeeStatus.php ) [len] => 100 ) [messenger_id] => Array ( [name] => messenger_id [vname] => LBL_MESSENGER_ID [type] => varchar [len] => 100 ) [messenger_type] => Array ( [name] => messenger_type [vname] => LBL_MESSENGER_TYPE [type] => enum [options] => messenger_type_dom [len] => 100 ) [calls] => Array ( [name] => calls [type] => link [relationship] => calls_users [source] => non-db [vname] => LBL_CALLS ) [meetings] => Array ( [name] => meetings [type] => link [relationship] => meetings_users [source] => non-db [vname] => LBL_MEETINGS ) [contacts_sync] => Array ( [name] => contacts_sync [type] => link [relationship] => contacts_users [source] => non-db [vname] => LBL_CONTACTS_SYNC [reportable] => ) [reports_to_id] => Array ( [name] => reports_to_id [vname] => LBL_REPORTS_TO_ID [type] => id [required] => ) [reports_to_name] => Array ( [name] => reports_to_name [rname] => last_name [id_name] => reports_to_id [vname] => LBL_REPORTS_TO_NAME [type] => relate [isnull] => true [module] => Users [table] => users [link] => reports_to_link [reportable] => [source] => non-db [duplicate_merge] => disabled [side] => right ) [reports_to_link] => Array ( [name] => reports_to_link [type] => link [relationship] => user_direct_reports [link_type] => one [side] => right [source] => non-db [vname] => LBL_REPORTS_TO ) [reportees] => Array ( [name] => reportees [type] => link [relationship] => user_direct_reports [link_type] => many [side] => left [source] => non-db [vname] => LBL_REPORTS_TO [reportable] => ) [email1] => Array ( [name] => email1 [vname] => LBL_EMAIL [type] => varchar [function] => Array ( [name] => getEmailAddressWidget [returns] => html ) [source] => non-db [group] => email1 [merge_filter] => enabled [required] => 1 ) [email_addresses] => Array ( [name] => email_addresses [type] => link [relationship] => users_email_addresses [module] => EmailAddress [bean_name] => EmailAddress [source] => non-db [vname] => LBL_EMAIL_ADDRESSES [reportable] => [required] => 1 ) [email_addresses_primary] => Array ( [name] => email_addresses_primary [type] => link [relationship] => users_email_addresses_primary [source] => non-db [vname] => LBL_EMAIL_ADDRESS_PRIMARY [duplicate_merge] => disabled [required] => 1 ) [email_link_type] => Array ( [name] => email_link_type [vname] => LBL_EMAIL_LINK_TYPE [type] => enum [options] => dom_email_link_type [importable] => [reportable] => [source] => non-db [studio] => ) [aclroles] => Array ( [name] => aclroles [type] => link [relationship] => acl_roles_users [source] => non-db [side] => right [vname] => LBL_ROLES ) [is_group] => Array ( [name] => is_group [vname] => LBL_GROUP_USER [type] => bool [massupdate] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [c_accept_status_fields] => Array ( [name] => c_accept_status_fields [rname] => id [relationship_fields] => Array ( [id] => accept_status_id [accept_status] => accept_status_name ) [vname] => LBL_LIST_ACCEPT_STATUS [type] => relate [link] => calls [link_type] => relationship_info [source] => non-db [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [m_accept_status_fields] => Array ( [name] => m_accept_status_fields [rname] => id [relationship_fields] => Array ( [id] => accept_status_id [accept_status] => accept_status_name ) [vname] => LBL_LIST_ACCEPT_STATUS [type] => relate [link] => meetings [link_type] => relationship_info [source] => non-db [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [accept_status_id] => Array ( [name] => accept_status_id [type] => varchar [source] => non-db [vname] => LBL_LIST_ACCEPT_STATUS [importable] => false [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [accept_status_name] => Array ( [name] => accept_status_name [type] => enum [source] => non-db [vname] => LBL_LIST_ACCEPT_STATUS [options] => dom_meeting_accept_status [massupdate] => [studio] => Array ( [listview] => [searchview] => [formula] => ) ) [prospect_lists] => Array ( [name] => prospect_lists [type] => link [relationship] => prospect_list_users [module] => ProspectLists [source] => non-db [vname] => LBL_PROSPECT_LIST ) [emails_users] => Array ( [name] => emails_users [type] => link [relationship] => emails_users_rel [module] => Emails [source] => non-db [vname] => LBL_EMAILS ) [eapm] => Array ( [name] => eapm [type] => link [relationship] => eapm_assigned_user [vname] => LBL_ASSIGNED_TO_USER [source] => non-db ) [oauth_tokens] => Array ( [name] => oauth_tokens [type] => link [relationship] => oauthtokens_assigned_user [vname] => LBL_OAUTH_TOKENS [link_type] => one [module] => OAuthTokens [bean_name] => OAuthToken [source] => non-db [side] => left ) [project_resource] => Array ( [name] => project_resource [type] => link [relationship] => projects_users_resources [source] => non-db [vname] => LBL_PROJECTS ) [project_users_1] => Array ( [name] => project_users_1 [type] => link [relationship] => project_users_1 [source] => non-db [module] => Project [bean_name] => Project [vname] => LBL_PROJECT_USERS_1_FROM_PROJECT_TITLE ) [am_projecttemplates_resources] => Array ( [name] => am_projecttemplates_resources [type] => link [relationship] => am_projecttemplates_users_resources [source] => non-db [vname] => LBL_PROJECTS ) [am_projecttemplates_users_1] => Array ( [name] => am_projecttemplates_users_1 [type] => link [relationship] => am_projecttemplates_users_1 [source] => non-db [module] => AM_ProjectTemplates [bean_name] => AM_ProjectTemplates [vname] => LBL_PROJECT_USERS_1_FROM_PROJECT_TITLE ) [SecurityGroups] => Array ( [name] => SecurityGroups [type] => link [relationship] => securitygroups_users [source] => non-db [module] => SecurityGroups [bean_name] => SecurityGroup [vname] => LBL_SECURITYGROUPS ) [securitygroup_noninher_fields] => Array ( [name] => securitygroup_noninher_fields [rname] => id [relationship_fields] => Array ( [id] => securitygroup_noninherit_id [noninheritable] => securitygroup_noninheritable [primary_group] => securitygroup_primary_group ) [vname] => LBL_USER_NAME [type] => relate [link] => SecurityGroups [link_type] => relationship_info [source] => non-db [Importable] => [duplicate_merge] => disabled ) [securitygroup_noninherit_id] => Array ( [name] => securitygroup_noninherit_id [type] => varchar [source] => non-db [vname] => LBL_securitygroup_noninherit_id ) [securitygroup_noninheritable] => Array ( [name] => securitygroup_noninheritable [type] => bool [source] => non-db [vname] => LBL_SECURITYGROUP_NONINHERITABLE ) [securitygroup_primary_group] => Array ( [name] => securitygroup_primary_group [type] => bool [source] => non-db [vname] => LBL_PRIMARY_GROUP ) ) [custom_fields] => DynamicField Object ( [use_existing_labels] => [base_path] => custom/Extension/modules/Users/Ext/Vardefs [db] => MysqliManager Object ( [dbType] => mysql [variant] => mysqli [priority] => 10 [label] => LBL_MYSQLI [backendFunctions:protected] => Array ( [free_result] => mysqli_free_result [close] => mysqli_close [row_count] => mysqli_num_rows [affected_row_count] => mysqli_affected_rows ) [dbName] => MySQL [maxNameLengths:protected] => Array ( [table] => 64 [column] => 64 [index] => 64 [alias] => 256 ) [type_map:protected] => Array ( [int] => int [double] => double [float] => float [uint] => int unsigned [ulong] => bigint unsigned [long] => bigint [short] => smallint [varchar] => varchar [text] => text [longtext] => longtext [date] => date [enum] => varchar [relate] => varchar [multienum] => text [html] => text [longhtml] => longtext [datetime] => datetime [datetimecombo] => datetime [time] => time [bool] => bool [tinyint] => tinyint [char] => char [blob] => blob [longblob] => longblob [currency] => decimal(26,6) [decimal] => decimal [decimal2] => decimal [id] => char(36) [url] => varchar [encrypt] => varchar [file] => varchar [decimal_tpl] => decimal(%d, %d) ) [capabilities:protected] => Array ( [affected_rows] => 1 [select_rows] => 1 [inline_keys] => 1 [create_user] => 1 [fulltext] => 1 [collation] => 1 [create_db] => 1 [disable_keys] => 1 ) [database] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.18 [server_version] => 50718 [stat] => Uptime: 149935 Threads: 1 Questions: 22928 Slow queries: 0 Opens: 2951 Flush tables: 1 Open tables: 1496 Queries per second avg: 0.152 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1117 [warning_count] => 0 ) [dieOnError:protected] => [encode:protected] => 1 [query_time:protected] => 0.00023508071899414 [last_error:protected] => [lastResult:protected] => [preparedTokens:protected] => Array ( ) [timedate:protected] => TimeDate Object ( [dbDayFormat] => Y-m-d [dbTimeFormat] => H:i:s [now:protected] => SugarDateTime Object ( [formats:protected] => Array ( [sec] => s [min] => i [hour] => G [zhour] => H [day] => j [zday] => d [days_in_month] => t [day_of_week] => w [day_of_year] => z [week] => W [month] => n [zmonth] => m [year] => Y [am_pm] => A [hour_12] => g ) [var_gets:protected] => Array ( [24_hour] => hour [day_of_week] => day_of_week_long [day_of_week_short] => day_of_week_short [month_name] => month_long [hour] => hour_12 ) [_strings:protected] => [date] => 2017-06-02 09:05:37.000000 [timezone_type] => 3 [timezone] => UTC ) [user:protected] => [current_user_id:protected] => 1 [current_user_tz:protected] => DateTimeZone Object ( [timezone_type] => 3 [timezone] => UTC ) [time_separator:protected] => [always_db:protected] => [allow_cache] => 1 [date_expressions:protected] => Array ( [yesterday] => Array ( [0] => -1 day [1] => -1 day ) [today] => Array ( [0] => [1] => ) [tomorrow] => Array ( [0] => +1 day [1] => +1 day ) [last_7_days] => Array ( [0] => -6 days [1] => ) [next_7_days] => Array ( [0] => [1] => +6 days ) [last_30_days] => Array ( [0] => -29 days [1] => ) [next_30_days] => Array ( [0] => [1] => +29 days ) ) ) [log:protected] => LoggerManager Object ( [_level:LoggerManager:private] => debug ) [type_class:protected] => Array ( [int] => int [double] => float [float] => float [uint] => int [ulong] => bigint [long] => bigint [short] => int [date] => date [datetime] => date [datetimecombo] => date [time] => time [bool] => bool [tinyint] => int [currency] => float [decimal] => float [decimal2] => float ) [options:protected] => Array ( [persistent] => 1 [autofree] => [debug] => 0 [ssl] => ) [standardQueries:protected] => Array ( [ALTER TABLE] => verifyAlterTable [DROP TABLE] => verifyDropTable [CREATE TABLE] => verifyCreateTable [INSERT INTO] => verifyInsertInto [UPDATE] => verifyUpdate [DELETE FROM] => verifyDeleteFrom ) [helper] => MysqliManager Object *RECURSION* [connectOptions] => Array ( [db_host_name] => localhost [db_host_instance] => SQLEXPRESS [db_user_name] => root [db_password] => xxxxxxxx [db_name] => suitecrm [db_type] => mysql [db_port] => [db_manager] => MysqliManager ) [count_id] => 1 [references] => 62 [lastsql] => SELECT * FROM outbound_email WHERE id = 'c3bb44c3-d803-4d18-a9d9-591eacabc7fc' ) [bean] => User Object *RECURSION* [module] => Users ) [column_fields] => Array ( [0] => id [1] => user_name [2] => user_hash [3] => system_generated_password [4] => pwd_last_changed [5] => authenticate_id [6] => sugar_login [7] => first_name [8] => last_name [9] => full_name [10] => name [11] => is_admin [12] => external_auth_only [13] => receive_notifications [14] => description [15] => date_entered [16] => date_modified [17] => modified_user_id [18] => modified_by_name [19] => created_by [20] => created_by_name [21] => title [22] => photo [23] => department [24] => phone_home [25] => phone_mobile [26] => phone_work [27] => phone_other [28] => phone_fax [29] => status [30] => address_street [31] => address_city [32] => address_state [33] => address_country [34] => address_postalcode [35] => UserType [36] => deleted [37] => portal_only [38] => show_on_employees [39] => employee_status [40] => messenger_id [41] => messenger_type [42] => calls [43] => meetings [44] => contacts_sync [45] => reports_to_id [46] => reports_to_name [47] => reports_to_link [48] => reportees [49] => email1 [50] => email_addresses [51] => email_addresses_primary [52] => email_link_type [53] => aclroles [54] => is_group [55] => c_accept_status_fields [56] => m_accept_status_fields [57] => accept_status_id [58] => accept_status_name [59] => prospect_lists [60] => emails_users [61] => eapm [62] => oauth_tokens [63] => project_resource [64] => project_users_1 [65] => am_projecttemplates_resources [66] => am_projecttemplates_users_1 [67] => SecurityGroups [68] => securitygroup_noninher_fields [69] => securitygroup_noninherit_id [70] => securitygroup_noninheritable [71] => securitygroup_primary_group ) [list_fields] => Array ( ) [relationship_fields] => Array ( ) [current_notify_user] => [fetched_row] => Array ( [id] => 1 [user_name] => admin [user_hash] => $1$I4MMdqc5$RHx5Gkzx2N3vsYC8uRtCi0 [system_generated_password] => 0 [pwd_last_changed] => [authenticate_id] => [sugar_login] => 1 [first_name] => [last_name] => Administrator [is_admin] => 1 [external_auth_only] => 0 [receive_notifications] => 1 [description] => [date_entered] => 2017-05-19 08:27:38 [date_modified] => 2017-05-19 08:27:38 [modified_user_id] => 1 [created_by] => [title] => Administrator [photo] => [department] => [phone_home] => [phone_mobile] => [phone_work] => [phone_other] => [phone_fax] => [status] => Active [address_street] => [address_city] => [address_state] => [address_country] => [address_postalcode] => [deleted] => 0 [portal_only] => 0 [show_on_employees] => 1 [employee_status] => Active [messenger_id] => [messenger_type] => [reports_to_id] => [is_group] => 0 [email1] => Joe.Bloggs@example.com ) [fetched_rel_row] => Array ( ) [layout_def] => [force_load_details] => [optimistic_lock] => [disable_custom_fields] => [number_formatting_done] => [process_field_encrypted] => [acltype] => module [additional_meta_fields] => Array ( ) [notify_inworkflow] => [assigned_user_id] => [special_notification] => [in_workflow] => [tracker_visibility] => 1 [listview_inner_join] => Array ( ) [in_import] => [in_save] => [logicHookDepth] => Array ( [before_retrieve] => 0 [after_retrieve] => 0 ) [max_logic_depth:protected] => 10 [loaded_relationships:protected] => Array ( [0] => reports_to_link ) [is_updated_dependent_fields:protected] => [required_fields] => Array ( [id] => 1 [user_name] => 1 [system_generated_password] => 1 [last_name] => 1 [date_entered] => 1 [date_modified] => 1 [status] => 1 [email1] => 1 [email_addresses] => 1 [email_addresses_primary] => 1 ) [added_custom_field_defs] => 1 [acl_fields] => 1 [sugar_login] => 1 [external_auth_only] => 0 [show_on_employees] => 1 [system_generated_password] => 0 [pwd_last_changed] => [authenticate_id] => [UserType] => [calls] => [meetings] => [contacts_sync] => [reports_to_link] => Link2 Object ( [relationship:protected] => One2MBeanRelationship Object ( [type] => one-to-many [def:protected] => Array ( [name] => user_direct_reports [lhs_module] => Users [lhs_table] => users [lhs_key] => id [rhs_module] => Users [rhs_table] => users [rhs_key] => reports_to_id [relationship_type] => one-to-many ) [lhsLink:protected] => reportees [rhsLink:protected] => reports_to_link [ignore_role_filter:protected] => [self_referencing:protected] => [name] => user_direct_reports [selfReferencing] => 1 [lhsLinkDef] => Array ( [name] => reportees [type] => link [relationship] => user_direct_reports [link_type] => many [side] => left [source] => non-db [vname] => LBL_REPORTS_TO [reportable] => ) [rhsLinkDef] => Array ( [name] => reports_to_link [type] => link [relationship] => user_direct_reports [link_type] => one [side] => right [source] => non-db [vname] => LBL_REPORTS_TO ) ) [focus:protected] => User Object *RECURSION* [def:protected] => Array ( [name] => reports_to_link [type] => link [relationship] => user_direct_reports [link_type] => one [side] => right [source] => non-db [vname] => LBL_REPORTS_TO ) [name:protected] => reports_to_link [beans:protected] => [rows:protected] => Array ( ) [loaded:protected] => 1 [relationship_fields:protected] => Array ( ) [tempBeans:protected] => Array ( ) ) [reportees] => [email_addresses_primary] => [email_link_type] => [aclroles] => [c_accept_status_fields] => [m_accept_status_fields] => [accept_status_id] => [accept_status_name] => [prospect_lists] => [emails_users] => [eapm] => [oauth_tokens] => [project_resource] => [project_users_1] => [am_projecttemplates_resources] => [am_projecttemplates_users_1] => [SecurityGroups] => [securitygroup_noninher_fields] => [securitygroup_noninherit_id] => [securitygroup_noninheritable] => [securitygroup_primary_group] => [relDepth] => 0 [email_opt_out] => 0 [invalid_email] => 0 ) This error is also reported below the above output:
Catchable fatal error: Argument 1 passed to TimeDate::asUser() must be an instance of DateTime, boolean given, called in /Users/atadmin/Sites/suitecrm/modules/Calls/Call.php on line 560 and defined in /Users/atadmin/Sites/suitecrm/include/TimeDate.php on line 592
Ok, thanks.
You can remove that logging line from that place.
Now, a few lines below, where it says:
// Assumes $call dates are in user format
$calldate = $timedate->fromDb($call->date_start);
$xOffset = $timedate->asUser($calldate, $notifyUser).' '.$timedate->userTimezoneSuffix($calldate, $notifyUser);
Add a logging line in the middle:
// Assumes $call dates are in user format
$calldate = $timedate->fromDb($call->date_start);
$GLOBALS['log']->fatal(print_r($call->date_start) . "---------------" . print_r($calldate));
$xOffset = $timedate->asUser($calldate, $notifyUser).' '.$timedate->userTimezoneSuffix($calldate, $notifyUser);
If you can find a way to post the results with line endings and indentation, that would be great. If not, just do it like you did before. I hope these objects are simpler and smaller, so it shouldn’t make much difference.
Sorry for all this work, we’re doing the manual version of remote debugging, it’s a bit cumbersome. But I’m hoping with this we can get the bug fixed for good.
No problem, just be glad to hopefully have it sorted.
Now reporting the following error:
Catchable fatal error: Argument 1 passed to TimeDate::asUser() must be an instance of DateTime, boolean given, called in /Users/atadmin/Sites/suitecrm/modules/Calls/Call.php on line 563 and defined in /Users/atadmin/Sites/suitecrm/include/TimeDate.php on line 592
Hhmm that’s strange, are you sure you added it in the right place?
It should be before the line that throws the error, which is this one
$xOffset = $timedate->asUser($calldate, $notifyUser).' '.$timedate->userTimezoneSuffix($calldate, $notifyUser);That call to asUser is the one that’s giving the error (if I’m not mistaken).
So we should see an extra message before that in the log…
Yes it’s as follows:
// Assumes $call dates are in user format
$calldate = $timedate->fromDb($call->date_start);
$GLOBALS['log']->fatal(print_r($call->date_start) . '---------------' . print_r($calldate));
$xOffset = $timedate->asUser($calldate, $notifyUser).' '.$timedate->userTimezoneSuffix($calldate, $notifyUser);
Upload the calls.php file via text file here so we can look.
Sometimes there is a lag in the logs, maybe the error being thrown in the line immediately after erases the previous message. But this is far-fetched.
And makes this debugging more difficult…
For some reason I can’t upload file so have hosted here:
Your file seems correct. I have no idea why it doesn’t give the expected message.
Let’s try a few different things:
Try it on this other demo
https://www.softaculous.com/demos/SuiteCRM
The main difference is that they sign you in as an admin, so it might let you do a more similar simulation of your error, exactly like you do in your system.
This is bug in a date-related function. Can you please check your PHP’s date_timezone configs?
Do you have anything in your logs about timezones or dates, even if it is just a notice?
