Suite to Xero

by Business Fundamentals

SuiteCRM BI-Directional link to Xero Automated BI-DIRECTIONAL synch between SuiteCRM and Xero, synch most recent record. Accounts, Contacts, Invoice and Products, connect and forget. Synch based on your criteria. This module also gives you the ability to manually update Accounts/Contacts/Invoice records to/from Xero

Free 30 day trial
Try it Now

#1414 - Sync invoices from suite

Closed Feature created by jamesg Verified Purchase 6 years ago

We have successfully installed the modules for the Xero and SuitecrM integration and can sync accounts and get the invoices from Xero to Suitecrm. When sending invoice details from Suite it is however not updating on Xero and we just get a blank screen on Suite.

  1. MartyP member avatar

    Business Fundamentals Provider Affiliate

    6 years ago

    Hey James, setting up/installing the invoices functionality requires you run an Admin -> Repair -> Quick Repair and Rebuild. After you have run that function scroll to the bottom of the window and you should see a window with SQL in it. You MUST commit those changes to the database for the module to work/function properly.

    If you have already done this I'll need some more details from you to check/locate what is wrong. Couple of questions required

    What versions/platform are you running on? PHP, SuiteCRM, MySQL etc Do you have access to the installation files and platform config/log files?

    Sometimes when you get a blank page in Suite it can be related to the permissions set on your site files. Can you reset those files to the Suite defaults? Please see here: https://docs.suitecrm.com/admin/installation-guide/downloading--installing/ Can you attempt to send an invoice to Xero than search in your apache log file (if you're running apache server) and suitecrm log file for any errors that have xero in them and send them to me?

    Thanks for your time and patience

    • jamesg member avatar

      jamesg Verified Purchase

      6 years ago

      Hi There,

      Thanks for the feedback, here are the responses to your queries:

      Platform: OS: Ubuntu 16.04.2 LTS (GNU/Linux 4.4.0-81-generic x86_64) uname a: Linux SuiteCRM.azuka.co.za 4.4.0-81-generic #104-Ubuntu SMP Wed Jun 14 08:17:06 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux

      Apcahe: Apache/2.4.18

      MySQL: Server version: 5.7.19-0ubuntu0.16.04.1 (Ubuntu)

      PHP 7.0

      SuiteCRM: Version 7.8.3 Sugar Version 6.5.24 (Build 509)

      Quick Rebuild was commited after loading the modules, current output from quick rebuild and repair: Clearing Vardefs from cache...done Clearing language files from cache...done Clearing Template files from cache...done Clearing JS files from cache...done Clearing Vardefs from cache...done Clearing JS Language files from cache...done Clearing language files from cache...done Clearing SuiteCRM Dashlet files from cache...done Clearing SuiteCRM Feed Cache...done Clearing Smarty templates from cache...done Clearing Theme Cache...done Clearing XML files from cache...done Clearing Unified Search Cache...done Clearing External API Cache File...done Rebuilding Extensions... Rebuilding Include... Rebuilding Language...en_us Rebuilding ActionViewMap... Rebuilding ActionFileMap... Rebuilding ActionReMap... Rebuilding Administration... Rebuilding EntryPointRegistry... Rebuilding Extensions... Rebuilding FileAccessControlMap... Rebuilding Layoutdefs... Rebuilding GlobalLinks... Rebuilding LogicHooks... Rebuilding Menus... Rebuilding Include... Rebuilding ScheduledTasks... Rebuilding UserPage... Rebuilding Utils... Rebuilding Vardefs... Rebuilding JSGroupings... Rebuilding Actions... Rebuilding DC Actions... Rebuilding RelationshipsRebuilding TableDictionary... Updating the admin warning message... Rebuilding Audit Tables... ACLAction not Audit Enabled... ACLRole not Audit Enabled... Relationship not Audit Enabled... Audit table for Leads already exists. skipping... Audit table for Cases already exists. skipping... Audit table for Bugs already exists. skipping... User not Audit Enabled... CampaignLog not Audit Enabled... Project not Audit Enabled... Audit table for ProjectTasks already exists. skipping... Audit table for Campaigns already exists. skipping... ProspectList not Audit Enabled... Prospect not Audit Enabled... EmailMarketing not Audit Enabled... CampaignTracker not Audit Enabled... Release not Audit Enabled... EmailMan not Audit Enabled... Scheduler not Audit Enabled... SchedulersJob not Audit Enabled... Audit table for Contacts already exists. skipping... Audit table for Accounts already exists. skipping... Audit table for Opportunitys already exists. skipping... EmailTemplate not Audit Enabled... Note not Audit Enabled... Call not Audit Enabled... Email not Audit Enabled... Meeting not Audit Enabled... Task not Audit Enabled... User not Audit Enabled... Employee not Audit Enabled... Currency not Audit Enabled... Tracker not Audit Enabled... ImportMap not Audit Enabled... UsersLastImport not Audit Enabled... Administration not Audit Enabled... UpgradeHistory not Audit Enabled... vCal not Audit Enabled... Alert not Audit Enabled... Role not Audit Enabled... Document not Audit Enabled... DocumentRevision not Audit Enabled... FieldsMetaData not Audit Enabled... InboundEmail not Audit Enabled... SavedSearch not Audit Enabled... UserPreference not Audit Enabled... MergeRecord not Audit Enabled... EmailAddress not Audit Enabled... EmailText not Audit Enabled... Spots not Audit Enabled... AOBH_BusinessHours not Audit Enabled... SugarFeed not Audit Enabled... EAPM not Audit Enabled... OAuthKey not Audit Enabled... OAuthToken not Audit Enabled... Audit table for AM_ProjectTemplatess already exists. skipping... Audit table for AM_TaskTemplatess already exists. skipping... Favorites not Audit Enabled... Audit table for AOK_Knowledge_Base_Categoriess already exists. skipping... Audit table for AOK_KnowledgeBases already exists. skipping... Reminder not Audit Enabled... Reminder_Invitee not Audit Enabled... Audit table for FP_eventss already exists. skipping... Audit table for FP_Event_Locationss already exists. skipping... Audit table for AOD_IndexEvents already exists. skipping... Audit table for AOD_Indexs already exists. skipping... Audit table for AOP_Case_Eventss already exists. skipping... Audit table for AOP_Case_Updatess already exists. skipping... Audit table for AOR_Reports already exists. skipping... AOR_Field not Audit Enabled... AOR_Chart not Audit Enabled... AOR_Condition not Audit Enabled... AOR_Scheduled_Reports not Audit Enabled... Audit table for AOS_Contractss already exists. skipping... Audit table for AOS_Invoicess already exists. skipping... Audit table for AOS_PDF_Templatess already exists. skipping... Audit table for AOS_Product_Categoriess already exists. skipping... Audit table for AOS_Productss already exists. skipping... Audit table for AOS_Products_Quotess already exists. skipping... Audit table for AOS_Line_Item_Groupss already exists. skipping... Audit table for AOS_Quotess already exists. skipping... AOW_Action not Audit Enabled... Audit table for AOW_WorkFlows already exists. skipping... AOW_Processed not Audit Enabled... AOW_Condition not Audit Enabled... Audit table for jjwg_Mapss already exists. skipping... Audit table for jjwg_Markerss already exists. skipping... Audit table for jjwg_Areass already exists. skipping... Audit table for jjwg_Address_Caches already exists. skipping... Audit table for Calls_Reschedules already exists. skipping... Audit table for SecurityGroups already exists. skipping... Audit table for OutboundEmailAccountss already exists. skipping... TemplateSectionLine not Audit Enabled... Audit table for bfs_SuitetoXeros already exists. skipping... Done Database tables are synced with vardefs

      I do not see an option for uploading files so output from log files pasted into body: suitecrm log output during event: SUITECRM Log File

      Tue Sep 18 06:44:32 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: Configurator::after_ui_frame Tue Sep 18 06:44:32 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Creating new instance of hook class hooks without parameters Tue Sep 18 06:44:32 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Creating new instance of hook class AssignGroups without parameters Tue Sep 18 06:44:32 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: ::after_ui_footer Tue Sep 18 06:44:32 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Creating new instance of hook class AssignGroups without parameters Tue Sep 18 06:44:32 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: ::server_round_trip Tue Sep 18 06:44:32 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Calling MySQLi::disconnect() Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] current_language is: en_us Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Found cache backend SugarCacheZend Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Found cache backend SugarCacheMemcached Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Found cache backend SugarCacheFile Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Found cache backend SugarCacheMemcache Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Found cache backend SugarCacheRedis Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Found cache backend SugarCacheAPC Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Found cache backend SugarCacheMemory Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Using cache backend SugarCacheMemory, since 999 is less than 1000 Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Found cache backend SugarCacheWincache Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Found cache backend SugarCachesMash Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Found language file: en_us.lang.php Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Found extended language file: en_us.lang.ext.php Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Found custom language file: en_us.lang.php Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0 Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query Execution Time:0.0003209114074707 Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query:SELECT category, name, value FROM config Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query Execution Time:0.00026583671569824 Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query Execution Time:0.0001521110534668 Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '67210943-5a40-e57c-1332-58d3d1c88a24' Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query Execution Time:0.00015091896057129 Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Hook called: ::after_entry_point Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Including module specific hook file for custom/modules Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Including Ext hook file for custom/application Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Hook called: ::after_session_start Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] We have an authenticated user id: b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Hook called: Users::before_retrieve Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Including module specific hook file for custom/modules/Users Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND users.deleted=0 Tue Sep 18 06:44:34 2018 [16983][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND users.deleted=0 Start: 0 count: 1 Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND users.deleted=0 LIMIT 0,1 Tue Sep 18 06:44:34 2018 [16983][-none-][INFO] Query Execution Time:0.00020003318786621 Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00022101402282715 Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' and u1.deleted=0 Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00015592575073242 Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link). Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified, ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id WHERE ear.bean_module = 'Users' AND ear.bean_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00042891502380371 Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: Users::after_retrieve Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Current user is: adrianvh@azuka.co.za Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Current user is: adrianvh@azuka.co.za Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] setting cookie ck_login_id_20 to b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] setting cookie ck_login_language_20 to en_us Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] current_language is: en_us Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Found language file: en_us.lang.php Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Found extended language file: en_us.lang.ext.php Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Found custom language file: en_us.lang.php Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Performing action: action_get MODULE: Alerts Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] get_full_list: order_by = 'alerts.date_entered' and where = 'alerts.assigned_user_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND is_read != '1'' Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[Alert].load_relationships, Loading relationship (modified_user_link). Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[Alert].load_relationships, Loading relationship (created_by_link). Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[Alert].load_relationships, Loading relationship (assigned_user_link). Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_order_by: (alerts.date_entered) does not have a vardef entry. Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list_query: query is SELECT alerts.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod FROM alerts LEFT JOIN users jt0 ON alerts.modified_user_id=jt0.id AND jt0.deleted=0

      AND jt0.deleted=0 LEFT JOIN users jt1 ON alerts.created_by=jt1.id AND jt1.deleted=0

      AND jt1.deleted=0 LEFT JOIN users jt2 ON alerts.assigned_user_id=jt2.id AND jt2.deleted=0

      AND jt2.deleted=0 where (alerts.assigned_user_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND is_read != '1') AND alerts.deleted=0 Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query: SELECT alerts.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod FROM alerts LEFT JOIN users jt0 ON alerts.modified_user_id=jt0.id AND jt0.deleted=0

      AND jt0.deleted=0 LEFT JOIN users jt1 ON alerts.created_by=jt1.id AND jt1.deleted=0

      AND jt1.deleted=0 LEFT JOIN users jt2 ON alerts.assigned_user_id=jt2.id AND jt2.deleted=0

      AND jt2.deleted=0 where (alerts.assigned_user_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND is_read != '1') AND alerts.deleted=0 Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00039410591125488 Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list_query: result is mysqli_result Object ( [current_field] => 0 [field_count] => 22 [lengths] => [num_rows] => 0 [type] => 0 )

      Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: ::server_round_trip Tue Sep 18 06:44:34 2018 [16983][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Calling MySQLi::disconnect() Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] current_language is: en_us Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Found cache backend SugarCacheZend Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Found cache backend SugarCacheMemcached Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Found cache backend SugarCacheFile Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Found cache backend SugarCacheMemcache Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Found cache backend SugarCacheRedis Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Found cache backend SugarCacheAPC Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Found cache backend SugarCacheMemory Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Using cache backend SugarCacheMemory, since 999 is less than 1000 Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Found cache backend SugarCacheWincache Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Found cache backend SugarCachesMash Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Found language file: en_us.lang.php Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Found extended language file: en_us.lang.ext.php Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Found custom language file: en_us.lang.php Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0 Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query Execution Time:0.00024509429931641 Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query:SELECT category, name, value FROM config Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query Execution Time:0.00019598007202148 Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query Execution Time:0.00017905235290527 Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '67210943-5a40-e57c-1332-58d3d1c88a24' Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query Execution Time:0.00028419494628906 Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Hook called: ::after_entry_point Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Including module specific hook file for custom/modules Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Including Ext hook file for custom/application Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Hook called: ::after_session_start Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] We have an authenticated user id: b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Hook called: Users::before_retrieve Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Including module specific hook file for custom/modules/Users Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND users.deleted=0 Tue Sep 18 06:44:49 2018 [16987][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND users.deleted=0 Start: 0 count: 1 Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND users.deleted=0 LIMIT 0,1 Tue Sep 18 06:44:49 2018 [16987][-none-][INFO] Query Execution Time:0.00029802322387695 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00034594535827637 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' and u1.deleted=0 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00022506713867188 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link). Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified, ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id WHERE ear.bean_module = 'Users' AND ear.bean_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00043010711669922 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: Users::after_retrieve Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Current user is: adrianvh@azuka.co.za Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Current user is: adrianvh@azuka.co.za Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] setting cookie ck_login_id_20 to b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] setting cookie ck_login_language_20 to en_us Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] current_language is: en_us Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Found language file: en_us.lang.php Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Found extended language file: en_us.lang.ext.php Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Found custom language file: en_us.lang.php Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Using Action View Map:ajaxui Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image icon_Home_32.png not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image icon_Home_32.png not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] CSS File yui.css not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND deleted = 0 ORDER BY date_entered DESC Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00031208992004395 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Limit Query:SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND deleted = 0 AND visible = 1) Start: 0 count: 50 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND deleted = 0 AND visible = 1) LIMIT 0,50 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00049185752868652 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Tracker: retrieving 10 items Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create_Contact_Vcard.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create_Lead_Vcard.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Create_Email_Templates.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Email_Templates.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Diagnostics.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create_Person_Form.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Schedule_Meeting.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Schedule_Call.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Today.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Schedule_Call.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Schedule_Meeting.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Email_Templates.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Resource_Chart.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Project_Tasks.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Email_Templates.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Create_Email_Templates.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Email_Templates.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Diagnostics.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create_Person_Form.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Resource_Chart.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Project_Tasks.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View_Process_Audit.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List_Maps.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Quick_Radius_Map.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image List.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create_Security_Group.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Create.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image Add.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image View.gif not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][WARN] Image dashboard.png not found Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Loading Preferences DB adrianvh@azuka.co.za Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT contents FROM user_preferences WHERE assigned_user_id='b93a01dd-bd8a-9055-0cc8-590b47306d27' AND category = 'ETag' AND deleted = 0 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00035786628723145 Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: Home::after_ui_frame Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Creating new instance of hook class hooks without parameters Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Creating new instance of hook class AssignGroups without parameters Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: ::after_ui_footer Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Creating new instance of hook class AssignGroups without parameters Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: ::server_round_trip Tue Sep 18 06:44:49 2018 [16987][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Calling MySQLi::disconnect() Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] current_language is: en_us Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Found cache backend SugarCacheZend Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Found cache backend SugarCacheMemcached Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Found cache backend SugarCacheFile Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Found cache backend SugarCacheMemcache Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Found cache backend SugarCacheRedis Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Found cache backend SugarCacheAPC Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Found cache backend SugarCacheMemory Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Using cache backend SugarCacheMemory, since 999 is less than 1000 Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Found cache backend SugarCacheWincache Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Found cache backend SugarCachesMash Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Found language file: en_us.lang.php Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Found extended language file: en_us.lang.ext.php Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Found custom language file: en_us.lang.php Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0 Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query Execution Time:0.00023818016052246 Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query:SELECT category, name, value FROM config Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query Execution Time:0.00018501281738281 Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query Execution Time:0.0002591609954834 Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '67210943-5a40-e57c-1332-58d3d1c88a24' Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query Execution Time:0.00016093254089355 Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Hook called: ::after_entry_point Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Including module specific hook file for custom/modules Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Including Ext hook file for custom/application Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Hook called: ::after_session_start Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] We have an authenticated user id: b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Hook called: Users::before_retrieve Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Including module specific hook file for custom/modules/Users Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND users.deleted=0 Tue Sep 18 06:44:49 2018 [16985][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND users.deleted=0 Start: 0 count: 1 Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND users.deleted=0 LIMIT 0,1 Tue Sep 18 06:44:49 2018 [16985][-none-][INFO] Query Execution Time:0.00024604797363281 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00024890899658203 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' and u1.deleted=0 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00016498565673828 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link). Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified, ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id WHERE ear.bean_module = 'Users' AND ear.bean_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.0003049373626709 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: Users::after_retrieve Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Current user is: adrianvh@azuka.co.za Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Current user is: adrianvh@azuka.co.za Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] setting cookie ck_login_id_20 to b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] setting cookie ck_login_language_20 to en_us Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] current_language is: en_us Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Found language file: en_us.lang.php Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Found extended language file: en_us.lang.ext.php Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Found custom language file: en_us.lang.php Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Performing action: action_listview MODULE: AOS_Quotes Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] metadatafile=modules/AOS_Quotes/metadata/listviewdefs.php Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: Currencies::before_retrieve Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Retrieve Currency : SELECT currencies.* FROM currencies WHERE currencies.id = '' AND currencies.deleted=0 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Limit Query:SELECT currencies.* FROM currencies WHERE currencies.id = '' AND currencies.deleted=0 Start: 0 count: 1 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT currencies.* FROM currencies WHERE currencies.id = '' AND currencies.deleted=0 LIMIT 0,1 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00030994415283203 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT id, name FROM saved_search WHERE deleted = '0' AND assigned_user_id = 'b93a01dd-bd8a-9055-0cc8-590b47306d27' AND search_module = 'AOS_Quotes' ORDER BY name Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00053787231445312 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEPRECATED] Using row number in fetchByAssoc is not portable and no longer supported. Please fix your code. Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Loading Preferences DB adrianvh@azuka.co.za Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT contents FROM user_preferences WHERE assigned_user_id='b93a01dd-bd8a-9055-0cc8-590b47306d27' AND category = 'AOS_Quotes2_AOS_QUOTES' AND deleted = 0 Tue Sep 18 06:44:49 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00046181678771973 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[AOS_Quotes].load_relationships, Loading relationship (assigned_user_link). Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Limit Query: SELECT aos_quotes.id , aos_quotes.billing_contact_id , aos_quotes.billing_account_id , aos_quotes.assigned_user_id , aos_quotes.number , aos_quotes.name , aos_quotes.stage , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) billing_contact , jt1.name billing_account , aos_quotes.total_amount , aos_quotes.currency_id , aos_quotes.expiration , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, aos_quotes.date_entered , aos_quotes.created_by FROM aos_quotes LEFT JOIN aos_quotes_cstm ON aos_quotes.id = aos_quotes_cstm.id_c LEFT JOIN contacts jt0 ON aos_quotes.billing_contact_id = jt0.id AND jt0.deleted=0 LEFT JOIN accounts jt1 ON aos_quotes.billing_account_id = jt1.id AND jt1.deleted=0 LEFT JOIN users jt2 ON aos_quotes.assigned_user_id=jt2.id AND jt2.deleted=0

      AND jt2.deleted=0 where aos_quotes.deleted=0 ORDER BY aos_quotes.date_entered DESC Start: 0 count: 21 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query: SELECT aos_quotes.id , aos_quotes.billing_contact_id , aos_quotes.billing_account_id , aos_quotes.assigned_user_id , aos_quotes.number , aos_quotes.name , aos_quotes.stage , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) billing_contact , jt1.name billing_account , aos_quotes.total_amount , aos_quotes.currency_id , aos_quotes.expiration , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, aos_quotes.date_entered , aos_quotes.created_by FROM aos_quotes LEFT JOIN aos_quotes_cstm ON aos_quotes.id = aos_quotes_cstm.id_c LEFT JOIN contacts jt0 ON aos_quotes.billing_contact_id = jt0.id AND jt0.deleted=0 LEFT JOIN accounts jt1 ON aos_quotes.billing_account_id = jt1.id AND jt1.deleted=0 LEFT JOIN users jt2 ON aos_quotes.assigned_user_id=jt2.id AND jt2.deleted=0

      AND jt2.deleted=0 where aos_quotes.deleted=0 ORDER BY aos_quotes.date_entered DESC LIMIT 0,21 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00091004371643066 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: AOS_Quotes::process_record Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: AOS_Quotes::process_record Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: AOS_Quotes::after_ui_frame Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Creating new instance of hook class hooks without parameters Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Creating new instance of hook class AssignGroups without parameters Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecuritySuite: Get SecuritySuite Enabled Modules: SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = 'SecurityGroups' OR rhs_module='SecurityGroups') Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = 'SecurityGroups' OR rhs_module='SecurityGroups') Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.0005650520324707 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] get_list: order_by = 'name' and where = '' and limit = '-99' Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[SecurityGroup].load_relationships, Loading relationship (modified_user_link). Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[SecurityGroup].load_relationships, Loading relationship (created_by_link). Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[SecurityGroup].load_relationships, Loading relationship (assigned_user_link). Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[SecurityGroup].load_relationships, Loading relationship (users). Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_list_query: SELECT securitygroups.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' securitygroup_noninher_fields , ' ' user_id FROM securitygroups LEFT JOIN users jt0 ON securitygroups.modified_user_id=jt0.id AND jt0.deleted=0

      AND jt0.deleted=0 LEFT JOIN users jt1 ON securitygroups.created_by=jt1.id AND jt1.deleted=0

      AND jt1.deleted=0 LEFT JOIN users jt2 ON securitygroups.assigned_user_id=jt2.id AND jt2.deleted=0

      AND jt2.deleted=0 where securitygroups.deleted=0 ORDER BY securitygroups.name Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query: SELECT securitygroups.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' securitygroup_noninher_fields , ' ' user_id FROM securitygroups LEFT JOIN users jt0 ON securitygroups.modified_user_id=jt0.id AND jt0.deleted=0

      AND jt0.deleted=0 LEFT JOIN users jt1 ON securitygroups.created_by=jt1.id AND jt1.deleted=0

      AND jt1.deleted=0 LEFT JOIN users jt2 ON securitygroups.assigned_user_id=jt2.id AND jt2.deleted=0

      AND jt2.deleted=0 where securitygroups.deleted=0 ORDER BY securitygroups.name Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00063800811767578 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): id = 364b15b5-36be-0c39-cf14-59367695ad72 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): name = Sisense Leads Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): date_entered = 2017-06-06 09:32:39 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): date_modified = 2017-06-06 09:43:56 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): modified_user_id = b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): modified_by_name = adrianvh@azuka.co.za Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): created_by = b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): created_by_name = adrianvh@azuka.co.za Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): deleted = 0 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): assigned_user_id = b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): assigned_user_name = adrianvh@azuka.co.za Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): noninheritable = 0 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(364b15b5-36be-0c39-cf14-59367695ad72): securitygroup_noninher_fields =
      Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: SecurityGroups::process_record Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): id = 1eb33ea9-87df-60e6-f508-5982dc72da52 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): name = Smart Chatz Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): date_entered = 2017-08-03 08:18:24 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): date_modified = 2017-08-03 08:18:33 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): modified_user_id = b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): modified_by_name = adrianvh@azuka.co.za Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): created_by = b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): created_by_name = adrianvh@azuka.co.za Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): deleted = 0 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): assigned_user_id = b93a01dd-bd8a-9055-0cc8-590b47306d27 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): assigned_user_name = adrianvh@azuka.co.za Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): noninheritable = 0 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SecurityGroup(1eb33ea9-87df-60e6-f508-5982dc72da52): securitygroup_noninher_fields =
      Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: SecurityGroups::process_record Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query:SELECT meetings.id, name,reminder_time, description,location, status, parent_type, parent_id, date_start, assigned_user_id FROM meetings LEFT JOIN meetings_users ON meetings.id = meetings_users.meeting_id WHERE meetings_users.user_id ='b93a01dd-bd8a-9055-0cc8-590b47306d27' AND meetings_users.accept_status != 'decline' AND meetings.reminder_time != -1 AND meetings_users.deleted != 1 AND meetings.status = 'Planned' AND date_start >= '2018-09-18 04:44:49' AND date_start <= '2018-09-19 05:44:49' Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00038599967956543 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query: SELECT calls.id, name, reminder_time, description, date_start, status, parent_type, parent_id FROM calls LEFT JOIN calls_users ON calls.id = calls_users.call_id WHERE calls_users.user_id ='b93a01dd-bd8a-9055-0cc8-590b47306d27' AND calls_users.accept_status != 'decline' AND calls.reminder_time != -1 AND calls_users.deleted != 1 AND calls.status = 'Planned' AND date_start >= '2018-09-18 04:44:49' AND date_start <= '2018-09-19 05:44:49' Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00037407875061035 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] get_full_list: order_by = '' and where = 'reminders.popup = 1' Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[Reminder].load_relationships, Loading relationship (modified_user_link). Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[Reminder].load_relationships, Loading relationship (created_by_link). Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] SugarBean[Reminder].load_relationships, Loading relationship (assigned_user_link). Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list_query: query is SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

      AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0

      AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0

      AND jt2.deleted=0 where (reminders.popup = 1) AND reminders.deleted=0 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

      AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0

      AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0

      AND jt2.deleted=0 where (reminders.popup = 1) AND reminders.deleted=0 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][INFO] Query Execution Time:0.00049805641174316 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list_query: result is mysqli_result Object ( [current_field] => 0 [field_count] => 25 [lengths] => [num_rows] => 20 [type] => 0 )

      Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): id = 2bc09fbf-18c8-a111-dfb8-59cde85fc7a3 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): name = Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): date_entered = 2017-09-29 06:28:17 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): date_modified = 2017-09-29 06:29:01 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): modified_user_id = 1 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): modified_by_name = admin Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): created_by = 29cdbe3a-b119-417d-b430-5942245b06d8 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): created_by_name = shelterm Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): deleted = 0 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): assigned_user_id = Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): popup = 1 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): email = 1 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): email_sent = 1 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): timer_popup = 1800 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): timer_email = 3600 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): related_event_module = Calls Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(2bc09fbf-18c8-a111-dfb8-59cde85fc7a3): related_event_module_id = 7230523c-9f94-01ad-510a-59a870523634 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] Hook called: Reminders::process_record Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(3a460e46-1d79-40d1-b4d0-5a252fa6fb4f): id = 3a460e46-1d79-40d1-b4d0-5a252fa6fb4f Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(3a460e46-1d79-40d1-b4d0-5a252fa6fb4f): name = Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(3a460e46-1d79-40d1-b4d0-5a252fa6fb4f): date_entered = 2017-12-04 11:20:35 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(3a460e46-1d79-40d1-b4d0-5a252fa6fb4f): date_modified = 2017-12-04 11:21:01 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-bd8a-9055-0cc8-590b47306d27][DEBUG] process_full_list: Reminder(3a460e46-1d79-40d1-b4d0-5a252fa6fb4f): modified_user_id = 1 Tue Sep 18 06:44:50 2018 [16985][b93a01dd-b

  2. MartyP member avatar

    Business Fundamentals Provider Affiliate

    5 years ago

    Problem fixed

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • Supported Versions
  • 7.10.0 to 8.6.1
Read Our Review

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

The simplest way to work™. Glances integrates SuiteCRM with all your favorite workplace apps, acting as your go-to hub for real-time customer insights and personal tasks.

Featured

Xero Accounting SuiteCRM Integration

The synergy of Xero and SuiteCRM is a double bonanza, as SuiteCRM Xero Accounting Integration by Fynsis brings a seamless flow of data of customers from inside your CRM to the actual billing and invoicing system in useful handshake so the bills can be generated within CRM.

Rating
Integrations Productivity Sales Xero ACCOUNTING