[2026-07-18 17:53:50] [error] [Logger.php:160] [IP:::1] Route dispatch failed: POST /officer/loan-application/store: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' 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('INSERT INTO loa...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(363): Database->query('INSERT INTO loa...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->loanStore()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'loanStore')
#4 C:\xampp\htdocs\ai_admin\public\index.php(406): Router->dispatch('POST', '/officer/loan-a...')
#5 {main}
[2026-07-18 19:22:19] [error] [Logger.php:160] [IP:::1] Route dispatch failed: GET /officer/day-summary: 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 payment_...')
#1 C:\xampp\htdocs\ai_admin\app\Controllers\OfficerAppController.php(1038): Database->query('SELECT payment_...', Array)
#2 C:\xampp\htdocs\ai_admin\app\Core\Router.php(54): OfficerAppController->daySummary()
#3 C:\xampp\htdocs\ai_admin\app\Core\Router.php(24): Router->callAction('OfficerAppContr...', 'daySummary')
#4 C:\xampp\htdocs\ai_admin\public\index.php(406): Router->dispatch('GET', '/officer/day-su...')
#5 {main}
