by Business Fundamentals

SuiteCRM connected to Xero
Create Accounts AND Invoices (ACCREC AND ACCPAY) in Xero from your Detail OR List views in SuiteCRM - no more double entry - Send all your SuiteCRM records to Xero - once there update them TO or FROM Xero, quick links created to those records

Free 30 day trial
Try it Now

#1414 - Sync invoices from suite

Closed Feature created by jamesg Verified Purchase a year 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

    a year 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

      a year 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

    6 months ago

    Problem fixed

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...