[2026-06-20 00:02:45] [error] [Logger.php:160] [IP:::1] [USER:1] Route dispatch failed: POST /customers/10010/verify-doc: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'verified_by' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:161
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(161): PDO->prepare('UPDATE `documen...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\CustomerController.php(637): Database->update('documents', Array, 'id = ? AND cust...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): CustomerController->verifyDocument('10010')
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(35): Router->callAction('CustomerControl...', 'verifyDocument', Array)
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('POST', '/customers/1001...')
#5 {main}
[2026-06-20 00:03:29] [error] [Logger.php:160] [IP:::1] [USER:1] Route dispatch failed: POST /customers/10010/verify-doc: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'verified_by' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:161
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(161): PDO->prepare('UPDATE `documen...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\CustomerController.php(637): Database->update('documents', Array, 'id = ? AND cust...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): CustomerController->verifyDocument('10010')
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(35): Router->callAction('CustomerControl...', 'verifyDocument', Array)
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('POST', '/customers/1001...')
#5 {main}
[2026-06-20 12:42:01] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT id, amou...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(120): Database->query('SELECT id, amou...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 12:42:03] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT id, amou...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(120): Database->query('SELECT id, amou...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 13:50:50] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT id, amou...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(120): Database->query('SELECT id, amou...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 13:51:14] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT id, amou...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(120): Database->query('SELECT id, amou...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 13:51:15] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT id, amou...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(120): Database->query('SELECT id, amou...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 13:51:23] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT id, amou...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(120): Database->query('SELECT id, amou...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 13:51:28] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT id, amou...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(120): Database->query('SELECT id, amou...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 14:23:45] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.loan_amount' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(163): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 14:24:28] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.loan_amount' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(163): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 14:24:30] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.loan_amount' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(163): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 14:24:30] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.loan_amount' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(163): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 14:24:31] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.loan_amount' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(163): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 14:24:32] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/dashboard: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.loan_amount' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(163): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->dashboard()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'dashboard')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/officer/dashbo...')
#5 {main}
[2026-06-20 20:19:32] [error] [Logger.php:160] [IP:::1] [USER:1] Route dispatch failed: GET /accounting/npa: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.due_date' in 'where clause' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:131
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(131): PDO->prepare('SELECT COUNT(*)...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\AccountingController.php(430): Database->queryValue('SELECT COUNT(*)...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): AccountingController->npaReport()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('AccountingContr...', 'npaReport')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/accounting/npa')
#5 {main}
[2026-06-20 20:30:34] [error] [Logger.php:160] [IP:::1] [USER:1] Route dispatch failed: GET /accounting/npa: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.due_date' in 'where clause' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:131
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(131): PDO->prepare('SELECT COUNT(*)...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\AccountingController.php(430): Database->queryValue('SELECT COUNT(*)...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): AccountingController->npaReport()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('AccountingContr...', 'npaReport')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/accounting/npa')
#5 {main}
[2026-06-20 20:32:34] [error] [Logger.php:160] [IP:::1] [USER:1] Route dispatch failed: GET /accounting/npa: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.balance' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\AccountingController.php(434): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): AccountingController->npaReport()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('AccountingContr...', 'npaReport')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/accounting/npa')
#5 {main}
[2026-06-20 20:32:35] [error] [Logger.php:160] [IP:::1] [USER:1] Route dispatch failed: GET /accounting/npa: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.balance' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\AccountingController.php(434): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): AccountingController->npaReport()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('AccountingContr...', 'npaReport')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/accounting/npa')
#5 {main}
[2026-06-20 20:45:00] [error] [Logger.php:160] [IP:::1] [USER:1] Route dispatch failed: GET /accounting/npa: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.balance' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\AccountingController.php(435): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): AccountingController->npaReport()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('AccountingContr...', 'npaReport')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/accounting/npa')
#5 {main}
[2026-06-20 20:45:01] [error] [Logger.php:160] [IP:::1] [USER:1] Route dispatch failed: GET /accounting/npa: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.balance' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\AccountingController.php(435): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): AccountingController->npaReport()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('AccountingContr...', 'npaReport')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/accounting/npa')
#5 {main}
[2026-06-20 23:59:43] [error] [Logger.php:160] [IP:::1] [USER:1] Route dispatch failed: GET /accounting/npa: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'l.balance' in 'field list' in C:\xampp\htdocs\ai_admin\app\Models\Database.php:108
#0 C:\xampp\htdocs\ai_admin\app\Models\Database.php(108): PDO->prepare('SELECT l.id, l....')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\AccountingController.php(435): Database->query('SELECT l.id, l....', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): AccountingController->npaReport()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('AccountingContr...', 'npaReport')
#4 C:\xampp\htdocs\ai_admin\public\index.php(285): Router->dispatch('GET', '/accounting/npa')
#5 {main}
