[2025-07-05 05:45:44] Starting import_excel.php [2025-07-05 07:45:44] Config loaded [2025-07-05 07:45:44] PSR interfaces loaded [2025-07-05 07:45:44] DEBUG: Starting PHPSpreadsheet check [2025-07-05 07:45:44] DEBUG: PSR interfaces loaded directly: CacheInterface=yes, CacheException=yes, InvalidArgumentException=yes [2025-07-05 07:45:44] DEBUG: IOFactory file exists: yes - Path: /home/dannelcv/contact.dannel.co.za/backend/phpoffice/phpspreadsheet/IOFactory.php [2025-07-05 07:45:44] DEBUG: About to check if PhpOffice\PhpSpreadsheet\IOFactory class exists [2025-07-05 07:45:44] DEBUG: IOFactory class exists [2025-07-05 05:47:16] Starting import_excel.php [2025-07-05 07:47:16] Config loaded [2025-07-05 07:47:16] PSR interfaces loaded [2025-07-05 07:47:16] DEBUG: Starting PHPSpreadsheet check [2025-07-05 07:47:16] DEBUG: PSR interfaces loaded directly: CacheInterface=yes, CacheException=yes, InvalidArgumentException=yes [2025-07-05 07:47:16] DEBUG: IOFactory file exists: yes - Path: /home/dannelcv/contact.dannel.co.za/backend/phpoffice/phpspreadsheet/IOFactory.php [2025-07-05 07:47:16] DEBUG: About to check if PhpOffice\PhpSpreadsheet\IOFactory class exists [2025-07-05 07:47:16] DEBUG: IOFactory class exists [2025-07-05 07:47:16] Server upload limits: 256MB [2025-07-05 07:47:16] Files array: Array ( [excel_file] => Array ( [name] => Customers.xls [full_path] => Customers.xls [type] => application/vnd.ms-excel [tmp_name] => /tmp/phpH0PI8F [error] => 0 [size] => 347648 ) ) [2025-07-05 07:47:16] Excel file upload details: Name=Customers.xls, Size=347648, Type=application/vnd.ms-excel, Error code=0 [2025-07-05 07:47:16] File extension: xls [2025-07-05 07:47:16] Reported size: 347648 bytes, Actual size: 347648 bytes [2025-07-05 07:47:16] Copied Excel file to temporary location: /tmp/excel_VlxVZv.xls [2025-07-05 07:47:16] Excel file size after copy: 347648 bytes [2025-07-05 07:47:16] Identifying Excel file type... [2025-07-05 07:47:16] Excel file type identified as: Xls [2025-07-05 07:47:16] Creating reader for Xls format [2025-07-05 07:47:16] Reader created successfully [2025-07-05 07:47:16] Loading spreadsheet from: /tmp/excel_VlxVZv.xls [2025-07-05 05:54:57] Starting import_excel.php [2025-07-05 07:54:57] Config loaded [2025-07-05 07:54:57] Loaded custom Composer\Pcre\Preg implementation [2025-07-05 07:54:57] PSR interfaces loaded [2025-07-05 07:54:57] DEBUG: Starting PHPSpreadsheet check [2025-07-05 07:54:57] DEBUG: PSR interfaces loaded directly: CacheInterface=yes, CacheException=yes, InvalidArgumentException=yes [2025-07-05 07:54:57] DEBUG: IOFactory file exists: yes - Path: /home/dannelcv/contact.dannel.co.za/backend/phpoffice/phpspreadsheet/IOFactory.php [2025-07-05 07:54:57] DEBUG: About to check if PhpOffice\PhpSpreadsheet\IOFactory class exists [2025-07-05 07:54:57] DEBUG: IOFactory class exists [2025-07-05 07:54:57] Server upload limits: 256MB [2025-07-05 07:54:57] Files array: Array ( [excel_file] => Array ( [name] => Customers.xls [full_path] => Customers.xls [type] => application/vnd.ms-excel [tmp_name] => /tmp/phpAtON0d [error] => 0 [size] => 347648 ) ) [2025-07-05 07:54:57] Excel file upload details: Name=Customers.xls, Size=347648, Type=application/vnd.ms-excel, Error code=0 [2025-07-05 07:54:57] File extension: xls [2025-07-05 07:54:57] Reported size: 347648 bytes, Actual size: 347648 bytes [2025-07-05 07:54:57] Copied Excel file to temporary location: /tmp/excel_9u121V.xls [2025-07-05 07:54:57] Excel file size after copy: 347648 bytes [2025-07-05 07:54:57] Identifying Excel file type... [2025-07-05 07:54:57] Excel file type identified as: Xls [2025-07-05 07:54:57] Creating reader for Xls format [2025-07-05 07:54:57] Reader created successfully [2025-07-05 07:54:57] Loading spreadsheet from: /tmp/excel_9u121V.xls [2025-07-05 07:54:58] Successfully loaded Excel file and worksheet: Worksheet [2025-07-08 09:32:37] Validating user: steven@support.ctecg.co.za [2025-07-08 09:32:37] Database connection error: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) [2025-07-08 09:32:37] User validation error: Database connection failed [2025-07-08 20:55:31] Validating user: steven@support.ctecg.co.za [2025-07-08 20:55:31] Database connection error: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) [2025-07-08 20:55:31] User validation error: Database connection failed [2025-07-08 21:03:36] Validating user: steven@support.ctecg.co.za [2025-07-08 21:03:36] User validated: steven@support.ctecg.co.za [2025-07-08 21:03:37] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 21:03:37] Found 0 clients [2025-07-08 21:05:18] Validating user: steven@support.ctecg.co.za [2025-07-08 21:05:18] User validated: steven@support.ctecg.co.za [2025-07-08 21:05:20] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 21:05:20] Found 0 clients [2025-07-08 21:07:22] Parsed clients import/update started by user: steven@support.ctecg.co.za with 1326 records [2025-07-08 21:07:23] Parsed import error for client 'WEELEE (PTY) LTD': SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'zip' at row 1 [2025-07-08 21:07:23] Parsed import completed - 1252 new records imported, 72 records updated, 2 errors [2025-07-08 21:07:29] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 21:07:30] Found 1252 clients [2025-07-08 21:07:53] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 21:07:53] Found 0 call logs [2025-07-08 21:08:15] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 21:08:15] Found 0 call logs [2025-07-08 21:08:19] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 21:08:19] Found 0 call logs [2025-07-08 21:08:38] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 21:08:38] Found 0 call logs [2025-07-08 21:08:40] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 21:08:40] Found 0 call logs [2025-07-08 21:09:05] Parsed clients import/update started by user: steven@support.ctecg.co.za with 1326 records [2025-07-08 21:09:06] Parsed import error for client 'WEELEE (PTY) LTD': SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'zip' at row 1 [2025-07-08 21:09:06] Parsed import completed - 0 new records imported, 1324 records updated, 2 errors [2025-07-08 21:13:40] Adding call log - Client: 1440, User: steven@support.ctecg.co.za, Payment Status: promised_payment [2025-07-08 21:13:40] Call log added successfully - ID: 1 [2025-07-08 21:26:35] Validating user: steven@cupport.ctecg.co.za [2025-07-08 21:26:35] New user created with ID: 5 [2025-07-08 21:26:35] User validated: steven@cupport.ctecg.co.za [2025-07-08 21:26:39] Fetching clients for user: steven@cupport.ctecg.co.za, search: [2025-07-08 21:26:39] Found 0 clients [2025-07-08 21:30:04] Validating user: steven@suppport.ctecg.co.za [2025-07-08 21:30:04] New user created with ID: 6 [2025-07-08 21:30:04] User validated: steven@suppport.ctecg.co.za [2025-07-08 21:30:04] Fetching clients for user: steven@suppport.ctecg.co.za, search: [2025-07-08 21:30:04] Found 0 clients [2025-07-08 21:36:47] Validating user: steven@support.ctecg.co.za [2025-07-08 21:36:47] User validated: steven@support.ctecg.co.za [2025-07-08 21:36:47] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 21:36:47] Found 1252 clients [2025-07-08 21:39:27] Validating user: steven@support.ctecg.co.za [2025-07-08 21:39:27] User validated: steven@support.ctecg.co.za [2025-07-08 21:39:27] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 21:39:27] Found 1252 clients [2025-07-08 21:49:16] Validating user: steven@support.ctecg.co.za [2025-07-08 21:49:16] User validated: steven@support.ctecg.co.za [2025-07-08 21:49:17] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 21:49:17] Found 1252 clients [2025-07-08 21:49:39] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 21:49:39] Found 1252 clients [2025-07-08 21:49:50] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 21:49:50] Found 1 call logs [2025-07-08 21:52:06] Validating user: steven@support.ctecg.co.za [2025-07-08 21:52:06] User validated: steven@support.ctecg.co.za [2025-07-08 21:52:07] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 21:52:07] Found 1252 clients [2025-07-08 21:52:19] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 21:52:19] Found 1 call logs [2025-07-08 21:55:19] Validating user: steven@support.ctecg.co.za [2025-07-08 21:55:19] User validated: steven@support.ctecg.co.za [2025-07-08 21:55:20] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 21:55:20] Found 1252 clients [2025-07-08 22:26:25] Validating user: steven@tt.com [2025-07-08 22:26:25] User validation failed: User steven@tt.com does not exist [2025-07-08 22:28:13] Validating user: steven@tt.com [2025-07-08 22:28:13] User validation failed: User steven@tt.com does not exist [2025-07-08 22:28:15] Validating user: steven@tt.com [2025-07-08 22:28:15] User validation failed: User steven@tt.com does not exist [2025-07-08 22:28:28] Validating user: test@tt.com [2025-07-08 22:28:28] User validation failed: User test@tt.com does not exist [2025-07-08 22:28:34] Validating user: test@tt.com [2025-07-08 22:28:34] User validation failed: User test@tt.com does not exist [2025-07-08 22:28:57] Validating user: steven@support.ctecg.co.za [2025-07-08 22:28:57] User validated: steven@support.ctecg.co.za [2025-07-08 22:28:57] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 22:28:57] Found 1252 clients [2025-07-08 22:29:08] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 22:29:08] Found 1 call logs [2025-07-08 22:29:38] Adding call log - Client: 1440, User: steven@support.ctecg.co.za, Payment Status: follow_up_needed [2025-07-08 22:29:38] Call log added successfully - ID: 2 [2025-07-08 22:29:38] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 22:29:38] Found 2 call logs [2025-07-08 22:29:41] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 22:29:41] Found 2 call logs [2025-07-08 22:31:00] Validating user: steven@support.ctecg.co.zas [2025-07-08 22:31:00] User validated: steven@support.ctecg.co.zas [2025-07-08 22:31:00] Fetching clients for user: steven@support.ctecg.co.zas, search: [2025-07-08 22:31:00] Found 0 clients [2025-07-08 22:32:08] Validating user: steven@support.ctecg.co.zas [2025-07-08 22:32:08] User validated: steven@support.ctecg.co.zas [2025-07-08 22:32:09] Fetching clients for user: steven@support.ctecg.co.zas, search: [2025-07-08 22:32:09] Found 0 clients [2025-07-08 22:32:39] Parsed clients import/update started by user: steven@support.ctecg.co.zas with 1326 records [2025-07-08 22:32:40] Parsed import error for client 'WEELEE (PTY) LTD': SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'zip' at row 1 [2025-07-08 22:32:40] Parsed import completed - 1252 new records imported, 72 records updated, 2 errors [2025-07-08 22:32:51] Fetching clients for user: steven@support.ctecg.co.zas, search: [2025-07-08 22:32:51] Found 1252 clients [2025-07-08 22:33:04] Fetching clients for user: steven@support.ctecg.co.zas, search: [2025-07-08 22:33:04] Found 1252 clients [2025-07-08 22:33:07] Fetching call logs for user: steven@support.ctecg.co.zas, client: 2692 [2025-07-08 22:33:07] Found 0 call logs [2025-07-08 22:33:23] Fetching call logs for user: steven@support.ctecg.co.zas, client: 2692 [2025-07-08 22:33:23] Found 0 call logs [2025-07-08 22:33:47] Validating user: steven@support.ctecg.co.za [2025-07-08 22:33:47] User validated: steven@support.ctecg.co.za [2025-07-08 22:33:47] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 22:33:47] Found 1252 clients [2025-07-08 22:33:55] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 22:33:55] Found 2 call logs [2025-07-08 22:33:59] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 22:33:59] Found 1252 clients [2025-07-08 22:50:58] Validating user: steven@support.ctecg.co.za [2025-07-08 22:50:58] User validated: steven@support.ctecg.co.za [2025-07-08 22:50:59] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 22:50:59] Found 1252 clients [2025-07-08 22:51:12] Fetching call logs for user: steven@support.ctecg.co.za, client: 1442 [2025-07-08 22:51:12] Found 0 call logs [2025-07-08 22:51:24] Fetching call logs for user: steven@support.ctecg.co.za, client: 1442 [2025-07-08 22:51:24] Found 0 call logs [2025-07-08 22:51:30] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 22:51:30] Found 1252 clients [2025-07-08 22:51:46] Validating user: steven@support.ctecg.co.zal [2025-07-08 22:51:46] User validation failed: User steven@support.ctecg.co.zal does not exist [2025-07-08 22:51:58] Validating user: steven@support.ctecg.co.za [2025-07-08 22:51:58] User validated: steven@support.ctecg.co.za [2025-07-08 22:51:58] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 22:51:59] Found 1252 clients [2025-07-08 22:58:21] Validating user: steven@support.ctecg.co.za [2025-07-08 22:58:21] User validated: steven@support.ctecg.co.za [2025-07-08 22:58:21] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 22:58:21] Found 1252 clients [2025-07-08 22:58:25] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 22:58:25] Found 2 call logs [2025-07-08 23:01:34] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 23:01:34] Found 2 call logs [2025-07-08 23:16:42] Validating user: steven@support.ctecg.co.za [2025-07-08 23:16:42] User validated: steven@support.ctecg.co.za [2025-07-08 23:16:43] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 23:16:43] Found 1252 clients [2025-07-08 23:16:45] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 23:16:45] Found 2 call logs [2025-07-08 23:19:01] Validating user: steven@support.ctecg.co.za [2025-07-08 23:19:01] User validated: steven@support.ctecg.co.za [2025-07-08 23:19:02] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 23:19:02] Found 1252 clients [2025-07-08 23:19:06] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 23:19:06] Found 2 call logs [2025-07-08 23:20:57] Validating user: steven@support.ctecg.co.za [2025-07-08 23:20:57] User validated: steven@support.ctecg.co.za [2025-07-08 23:20:57] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 23:20:57] Found 1252 clients [2025-07-08 23:20:59] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 23:20:59] Found 2 call logs [2025-07-08 23:23:22] Validating user: steven@support.ctecg.co.za [2025-07-08 23:23:22] User validated: steven@support.ctecg.co.za [2025-07-08 23:23:22] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 23:23:22] Found 1252 clients [2025-07-08 23:23:25] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 23:23:25] Found 2 call logs [2025-07-08 23:24:15] Validating user: steven@support.ctecg.co.za [2025-07-08 23:24:15] User validated: steven@support.ctecg.co.za [2025-07-08 23:24:15] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 23:24:15] Found 1252 clients [2025-07-08 23:24:17] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 23:24:17] Found 2 call logs [2025-07-08 23:24:38] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-08 23:24:38] Found 2 call logs [2025-07-08 23:24:39] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 23:24:39] Found 1252 clients [2025-07-08 23:27:12] Fetching call logs for user: steven@support.ctecg.co.za, client: 1454 [2025-07-08 23:27:12] Found 0 call logs [2025-07-08 23:27:25] Fetching call logs for user: steven@support.ctecg.co.za, client: 1454 [2025-07-08 23:27:25] Found 0 call logs [2025-07-08 23:27:26] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-08 23:27:26] Found 1252 clients [2025-07-09 08:23:04] Validating user: steven@support.ctecg.co.za [2025-07-09 08:23:04] User validated: steven@support.ctecg.co.za [2025-07-09 08:23:05] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 08:23:05] Found 1252 clients [2025-07-09 08:23:18] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:23:18] Found 2 call logs [2025-07-09 08:24:58] Adding call log - Client: 1440, User: steven@support.ctecg.co.za, Payment Status: paid [2025-07-09 08:24:58] Call log added successfully - ID: 3 [2025-07-09 08:25:00] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:25:00] Found 3 call logs [2025-07-09 08:25:03] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:25:03] Found 3 call logs [2025-07-09 08:25:16] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:25:16] Found 3 call logs [2025-07-09 08:25:25] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:25:25] Found 3 call logs [2025-07-09 08:25:29] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:25:29] Found 3 call logs [2025-07-09 08:25:58] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:25:58] Found 3 call logs [2025-07-09 08:26:02] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 08:26:02] Found 1252 clients [2025-07-09 08:26:45] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 08:26:45] Found 1252 clients [2025-07-09 08:27:29] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 08:27:29] Found 1252 clients [2025-07-09 08:42:06] Validating user: steven@support.ctecg.co.za [2025-07-09 08:42:06] User validated: steven@support.ctecg.co.za [2025-07-09 08:42:06] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 08:42:06] Found 1252 clients [2025-07-09 08:42:29] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:42:29] Found 3 call logs [2025-07-09 08:42:45] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:42:45] Found 3 call logs [2025-07-09 08:44:33] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 08:44:33] Found 3 call logs [2025-07-09 08:46:59] Validating user: steven@support.ctecg.co.za [2025-07-09 08:46:59] User validated: steven@support.ctecg.co.za [2025-07-09 08:46:59] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 08:46:59] Found 1252 clients [2025-07-09 09:01:52] Validating user: steven@support.ctecg.co.za [2025-07-09 09:01:52] User validated: steven@support.ctecg.co.za [2025-07-09 09:01:54] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 09:01:54] Found 1252 clients [2025-07-09 10:54:12] Validating user: steven@support.ctecg.co.za [2025-07-09 10:54:12] User validated: steven@support.ctecg.co.za [2025-07-09 10:54:12] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 10:54:12] Found 1252 clients [2025-07-09 10:54:15] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 10:54:15] Found 3 call logs [2025-07-09 10:56:10] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 10:56:10] Found 3 call logs [2025-07-09 10:56:21] Adding call log - Client: 1440, User: steven@support.ctecg.co.za, Payment Status: no_answer [2025-07-09 10:56:21] Call log added successfully - ID: 4 [2025-07-09 10:56:22] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 10:56:22] Found 4 call logs [2025-07-09 10:56:25] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 10:56:25] Found 4 call logs [2025-07-09 10:56:31] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 10:56:31] Found 4 call logs [2025-07-09 11:17:13] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 11:17:13] Found 4 call logs [2025-07-09 11:17:18] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 11:17:18] Found 1252 clients [2025-07-09 11:17:22] Fetching call logs for user: steven@support.ctecg.co.za, client: 1440 [2025-07-09 11:17:22] Found 4 call logs [2025-07-09 11:17:42] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 11:17:42] Found 1252 clients [2025-07-09 11:17:44] Fetching call logs for user: steven@support.ctecg.co.za, client: 1383 [2025-07-09 11:17:44] Found 0 call logs [2025-07-09 11:17:47] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 11:17:47] Found 1252 clients [2025-07-09 11:17:49] Fetching call logs for user: steven@support.ctecg.co.za, client: 1386 [2025-07-09 11:17:49] Found 0 call logs [2025-07-09 11:18:08] Fetching call logs for user: steven@support.ctecg.co.za, client: 1386 [2025-07-09 11:18:08] Found 0 call logs [2025-07-09 11:18:09] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 11:18:09] Found 1252 clients [2025-07-09 11:18:15] Fetching call logs for user: steven@support.ctecg.co.za, client: 1478 [2025-07-09 11:18:15] Found 0 call logs [2025-07-09 11:18:25] Fetching call logs for user: steven@support.ctecg.co.za, client: 1478 [2025-07-09 11:18:25] Found 0 call logs [2025-07-09 11:18:26] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 11:18:27] Found 1252 clients [2025-07-09 11:18:28] Fetching call logs for user: steven@support.ctecg.co.za, client: 1383 [2025-07-09 11:18:28] Found 0 call logs [2025-07-09 11:18:30] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 11:18:30] Found 1252 clients [2025-07-09 11:18:38] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 11:18:38] Found 1252 clients [2025-07-09 11:18:44] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 11:18:44] Found 1252 clients [2025-07-09 12:54:10] Validating user: caitlin@dannel.co.za [2025-07-09 12:54:10] User validated: caitlin@dannel.co.za [2025-07-09 12:54:10] Fetching clients for user: caitlin@dannel.co.za, search: [2025-07-09 12:54:10] Found 0 clients [2025-07-09 18:55:23] Validating user: steven@support.ctecg.co.za [2025-07-09 18:55:23] User validated: steven@support.ctecg.co.za [2025-07-09 18:55:24] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-09 18:55:24] Found 1252 clients [2025-07-09 18:55:34] Fetching call logs for user: steven@support.ctecg.co.za, client: 1386 [2025-07-09 18:55:34] Found 0 call logs [2025-07-11 16:17:31] Validating user: accounts@ctecg.co.za [2025-07-11 16:17:31] User validation failed: User accounts@ctecg.co.za does not exist [2025-07-11 16:17:45] Validating user: accounts@dannel.co.za [2025-07-11 16:17:45] User validated: accounts@dannel.co.za [2025-07-11 16:17:45] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-11 16:17:45] Found 0 clients [2025-07-11 16:17:54] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-11 16:17:54] Found 0 clients [2025-07-11 16:18:04] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-11 16:18:04] Found 0 clients [2025-07-11 16:33:01] Validating user: accounts@dannel.co.za [2025-07-11 16:33:01] User validated: accounts@dannel.co.za [2025-07-11 16:33:01] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-11 16:33:01] Found 0 clients [2025-07-11 16:33:20] Validating user: steven@support.ctecg.co.za [2025-07-11 16:33:20] User validated: steven@support.ctecg.co.za [2025-07-11 16:33:21] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-11 16:33:21] Found 1252 clients [2025-07-11 16:33:42] Validating user: calvin@dannel.co.za [2025-07-11 16:33:42] User validated: calvin@dannel.co.za [2025-07-11 16:33:43] Fetching clients for user: calvin@dannel.co.za, search: [2025-07-11 16:33:43] Found 0 clients [2025-07-11 16:40:47] Validating user: accounts@dannel.co.za [2025-07-11 16:40:47] User validated: accounts@dannel.co.za [2025-07-11 16:41:28] Validating user: accounts@dannel.co.za [2025-07-11 16:41:28] User validated: accounts@dannel.co.za [2025-07-11 16:41:29] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-11 16:41:29] Found 3756 clients [2025-07-11 16:41:35] Fetching call logs for user: accounts@dannel.co.za, client: 2692 [2025-07-11 18:13:26] Fetching call logs for user: accounts@dannel.co.za, client: 2692 [2025-07-11 18:13:27] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-11 18:13:27] Found 3756 clients [2025-07-14 21:52:48] Validating user: steven@support.ctecg.co.za [2025-07-14 21:52:48] User validated: steven@support.ctecg.co.za [2025-07-14 21:52:48] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-14 21:52:48] Found 3756 clients [2025-07-14 21:53:05] Validating user: calvin@dannel.co.za [2025-07-14 21:53:05] User validated: calvin@dannel.co.za [2025-07-14 21:53:05] Fetching clients for user: calvin@dannel.co.za, search: [2025-07-14 21:53:06] Found 3756 clients [2025-07-14 21:53:18] Fetching call logs for user: calvin@dannel.co.za, client: 1440 [2025-07-14 21:53:21] Fetching clients for user: calvin@dannel.co.za, search: [2025-07-14 21:53:21] Found 3756 clients [2025-07-14 21:53:34] Fetching clients for user: calvin@dannel.co.za, search: [2025-07-14 21:53:35] Found 3756 clients [2025-07-14 22:03:53] Fetching clients for user: calvin@dannel.co.za, search: [2025-07-14 22:03:53] Found 0 clients [2025-07-14 22:04:31] Parsed clients import/update started by user: calvin@dannel.co.za with 1326 records [2025-07-14 22:04:32] Parsed import error for client 'WEELEE (PTY) LTD': SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'zip' at row 1 [2025-07-14 22:04:32] Parsed import completed - 1324 new records imported, 0 records updated, 2 errors [2025-07-14 22:04:37] Fetching clients for user: calvin@dannel.co.za, search: [2025-07-14 22:04:37] Found 1324 clients [2025-07-14 22:04:56] Validating user: steven@support.ctecg.co.za [2025-07-14 22:04:57] User validated: steven@support.ctecg.co.za [2025-07-14 22:04:57] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-14 22:04:57] Found 1324 clients [2025-07-14 22:05:33] Parsed clients import/update started by user: steven@support.ctecg.co.za with 1326 records [2025-07-14 22:05:35] Parsed import error for client 'WEELEE (PTY) LTD': SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'zip' at row 1 [2025-07-14 22:05:35] Parsed import completed - 0 new records imported, 1324 records updated, 2 errors [2025-07-14 22:06:03] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-14 22:06:03] Found 1324 clients [2025-07-14 22:06:33] Validating user: accounts@dannel.co.za [2025-07-14 22:06:33] User validated: accounts@dannel.co.za [2025-07-14 22:06:33] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-14 22:06:33] Found 1324 clients [2025-07-14 22:06:45] Parsed clients import/update started by user: accounts@dannel.co.za with 1326 records [2025-07-14 22:06:46] Parsed import error for client 'WEELEE (PTY) LTD': SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'zip' at row 1 [2025-07-14 22:06:46] Parsed import completed - 0 new records imported, 1324 records updated, 2 errors [2025-07-22 11:51:18] Validating user: steven@support.ctecg.co.za [2025-07-22 11:51:18] User validated: steven@support.ctecg.co.za [2025-07-22 11:51:18] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-22 11:51:18] Found 1324 clients [2025-07-22 11:51:23] Fetching call logs for user: steven@support.ctecg.co.za, client: 18 [2025-07-22 11:53:11] Fetching call logs for user: steven@support.ctecg.co.za, client: 18 [2025-07-22 11:53:12] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-22 11:53:12] Found 1324 clients [2025-07-22 12:26:21] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-22 12:26:21] Found 1324 clients [2025-07-22 12:26:31] Fetching clients for user: steven@support.ctecg.co.za, search: [2025-07-22 12:26:31] Found 1324 clients [2025-07-24 16:10:58] Validating user: accounts@dannel.co.za [2025-07-24 16:10:59] User validated: accounts@dannel.co.za [2025-07-24 16:10:59] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-24 16:10:59] Found 1324 clients [2025-07-24 16:11:15] Fetching call logs for user: accounts@dannel.co.za, client: 18 [2025-07-24 16:11:16] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-24 16:11:17] Found 1324 clients [2025-07-24 16:11:27] Fetching call logs for user: accounts@dannel.co.za, client: 18 [2025-07-24 16:12:09] Adding call log - Client: 18, User: accounts@dannel.co.za, Payment Status: dispute [2025-07-24 16:12:09] Fetching call logs for user: accounts@dannel.co.za, client: 18 [2025-07-24 16:12:12] Fetching call logs for user: accounts@dannel.co.za, client: 18 [2025-07-24 16:12:28] Fetching call logs for user: accounts@dannel.co.za, client: 18 [2025-07-24 16:12:29] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-24 16:12:29] Found 1324 clients [2025-07-24 16:12:37] Fetching call logs for user: accounts@dannel.co.za, client: 136 [2025-07-24 16:13:32] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-24 16:13:32] Found 1324 clients [2025-07-24 16:13:46] Fetching call logs for user: accounts@dannel.co.za, client: 179 [2025-07-24 16:13:54] Fetching call logs for user: accounts@dannel.co.za, client: 179 [2025-07-24 16:14:01] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-24 16:14:01] Found 1324 clients [2025-07-24 16:14:34] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-24 16:14:34] Found 1324 clients [2025-07-24 16:14:41] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-24 16:14:41] Found 1324 clients [2025-07-24 16:14:43] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-24 16:14:43] Found 1324 clients [2025-07-24 16:57:31] Validating user: calvin@dannel.co.za [2025-07-24 16:57:31] User validated: calvin@dannel.co.za [2025-07-24 16:57:31] Fetching clients for user: calvin@dannel.co.za, search: [2025-07-24 16:57:31] Found 1324 clients [2025-07-24 16:57:36] Fetching call logs for user: calvin@dannel.co.za, client: 18 [2025-07-24 16:57:36] Found 0 call logs [2025-07-24 16:57:40] Fetching call logs for user: calvin@dannel.co.za, client: 18 [2025-07-24 16:57:40] Found 0 call logs [2025-07-24 16:57:42] Fetching call logs for user: calvin@dannel.co.za, client: 18 [2025-07-24 16:57:42] Found 0 call logs [2025-07-27 21:52:43] Starting import_excel.php [2025-07-27 23:52:43] Config loaded [2025-07-27 23:52:43] Loaded custom Composer\Pcre\Preg implementation [2025-07-27 23:52:43] PSR interfaces loaded [2025-07-27 21:52:46] Starting import_excel.php [2025-07-27 23:52:46] Config loaded [2025-07-27 23:52:46] Loaded custom Composer\Pcre\Preg implementation [2025-07-27 23:52:46] PSR interfaces loaded [2025-07-27 21:52:47] Starting import_excel.php [2025-07-27 23:52:47] Config loaded [2025-07-27 23:52:47] Loaded custom Composer\Pcre\Preg implementation [2025-07-27 23:52:47] PSR interfaces loaded [2025-07-27 21:53:53] Starting import_excel.php [2025-07-27 23:53:53] Config loaded [2025-07-27 23:53:53] Loaded custom Composer\Pcre\Preg implementation [2025-07-27 23:53:53] PSR interfaces loaded [2025-07-27 22:08:23] Starting import_excel.php [2025-07-28 00:08:23] Config loaded [2025-07-28 00:08:23] Loaded custom Composer\Pcre\Preg implementation [2025-07-28 00:08:23] PSR interfaces loaded [2025-07-27 22:08:26] Starting import_excel.php [2025-07-28 00:08:26] Config loaded [2025-07-28 00:08:26] Loaded custom Composer\Pcre\Preg implementation [2025-07-28 00:08:26] PSR interfaces loaded [2025-07-28 10:03:17] Validating user: accounts@dannel.co.za [2025-07-28 10:03:17] User validated: accounts@dannel.co.za [2025-07-28 10:03:17] Fetching clients for user: accounts@dannel.co.za, search: [2025-07-28 10:03:17] Found 1324 clients [2025-07-28 10:31:41] Fetching call logs for user: accounts@dannel.co.za, client: 135 [2025-07-28 10:31:48] Adding call log - Client: 135, User: accounts@dannel.co.za, Payment Status: no_answer [2025-07-28 10:31:49] Fetching call logs for user: accounts@dannel.co.za, client: 135 [2025-07-28 10:31:51] Fetching call logs for user: accounts@dannel.co.za, client: 135 [2025-07-28 10:31:52] Fetching call logs for user: accounts@dannel.co.za, client: 135 [2025-07-28 10:31:53] Fetching call logs for user: accounts@dannel.co.za, client: 135 [2025-07-28 10:31:54] Fetching call logs for user: accounts@dannel.co.za, client: 135 [2025-08-20 14:11:53] Validating user: accounts@dannel.co.za [2025-08-20 14:11:54] User validated: accounts@dannel.co.za [2025-08-20 14:11:55] Fetching clients for user: accounts@dannel.co.za, search: [2025-08-20 14:11:55] Found 1324 clients [2025-12-09 15:02:23] Starting import_excel.php [2025-12-09 17:02:23] Config loaded [2025-12-09 17:02:23] Loaded custom Composer\Pcre\Preg implementation [2025-12-09 17:02:23] PSR interfaces loaded [2025-12-11 07:54:02] Starting import_excel.php [2025-12-11 09:54:02] Config loaded [2025-12-11 09:54:02] Loaded custom Composer\Pcre\Preg implementation [2025-12-11 09:54:02] PSR interfaces loaded [2026-01-01 20:24:53] Starting import_excel.php [2026-01-01 22:24:53] Config loaded [2026-01-01 22:24:53] Loaded custom Composer\Pcre\Preg implementation [2026-01-01 22:24:53] PSR interfaces loaded [2026-01-01 20:46:22] Starting import_excel.php [2026-01-01 22:46:22] Config loaded [2026-01-01 22:46:22] Loaded custom Composer\Pcre\Preg implementation [2026-01-01 22:46:22] PSR interfaces loaded