[2026-03-02 21:26:08] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-02 21:26:09] Query failed: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION kasazqgd_NoGo_POS.getClientName does not exist
SQL: SELECT 
        so.id,
        so.order_number,
        so.order_date,
        so.total_amount,
        so.payment_status,
        so.payment_method,
        b.branch_name,
        u.username as cashier,
        CASE 
            WHEN so.client_id IS NOT NULL THEN getClientName(so.client_id)
            ELSE so.client_name
        END as customer_name
     FROM sales_orders so
     JOIN branches b ON so.branch_id = b.id
     JOIN users u ON so.created_by = u.id
     WHERE so.payment_status != 'Cancelled'
     ORDER BY so.order_date DESC
     LIMIT 15
[2026-03-02 21:33:30] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 21:35:10] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 21:36:00] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 21:39:15] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-02 21:39:15] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 21:45:52] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-02 21:45:56] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 22:01:03] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 22:06:05] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 22:11:14] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 22:16:17] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 22:50:37] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-02 22:50:41] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 22:51:46] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 22:56:57] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'al.table_affected' in 'SELECT'
SQL: SELECT u.username, al.action, al.table_affected, al.created_at 
     FROM audit_logs al
     JOIN users u ON al.performed_by = u.id
     WHERE al.table_affected IN ('products', 'product_pricing')
     ORDER BY al.created_at DESC
     LIMIT 10
[2026-03-02 22:57:01] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'al.table_affected' in 'SELECT'
SQL: SELECT u.username, al.action, al.table_affected, al.created_at 
     FROM audit_logs al
     JOIN users u ON al.performed_by = u.id
     WHERE al.table_affected IN ('products', 'product_pricing')
     ORDER BY al.created_at DESC
     LIMIT 10
[2026-03-02 22:57:02] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'al.table_affected' in 'SELECT'
SQL: SELECT u.username, al.action, al.table_affected, al.created_at 
     FROM audit_logs al
     JOIN users u ON al.performed_by = u.id
     WHERE al.table_affected IN ('products', 'product_pricing')
     ORDER BY al.created_at DESC
     LIMIT 10
[2026-03-02 22:57:03] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 22:57:04] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'al.table_affected' in 'SELECT'
SQL: SELECT u.username, al.action, al.table_affected, al.created_at 
     FROM audit_logs al
     JOIN users u ON al.performed_by = u.id
     WHERE al.table_affected IN ('products', 'product_pricing')
     ORDER BY al.created_at DESC
     LIMIT 10
[2026-03-02 22:57:06] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'al.table_affected' in 'SELECT'
SQL: SELECT u.username, al.action, al.table_affected, al.created_at 
     FROM audit_logs al
     JOIN users u ON al.performed_by = u.id
     WHERE al.table_affected IN ('products', 'product_pricing')
     ORDER BY al.created_at DESC
     LIMIT 10
[2026-03-02 22:57:09] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'al.table_affected' in 'SELECT'
SQL: SELECT u.username, al.action, al.table_affected, al.created_at 
     FROM audit_logs al
     JOIN users u ON al.performed_by = u.id
     WHERE al.table_affected IN ('products', 'product_pricing')
     ORDER BY al.created_at DESC
     LIMIT 10
[2026-03-02 22:57:10] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'al.table_affected' in 'SELECT'
SQL: SELECT u.username, al.action, al.table_affected, al.created_at 
     FROM audit_logs al
     JOIN users u ON al.performed_by = u.id
     WHERE al.table_affected IN ('products', 'product_pricing')
     ORDER BY al.created_at DESC
     LIMIT 10
[2026-03-02 23:05:02] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-02 23:05:02] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'remember_token_expires' in 'SET'
SQL: UPDATE `users` SET remember_token = ?, remember_token_expires = ? WHERE id = ?
[2026-03-02 23:05:35] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 23:06:05] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 23:07:00] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 23:07:55] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 23:08:05] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 23:08:55] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 23:18:36] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-02 23:18:41] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'al.created_at' in 'SELECT'
SQL: SELECT u.username, al.action, al.table_name, al.created_at 
     FROM audit_logs al
     LEFT JOIN users u ON al.performed_by = u.id
     WHERE al.table_name IN ('products', 'product_pricing')
     ORDER BY al.created_at DESC
     LIMIT 10
[2026-03-03 08:11:34] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-03 08:11:35] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 09:29:07] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 09:34:11] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 10:29:28] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-03 10:29:29] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 11:30:03] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-03 11:30:04] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 20:02:30] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-03 20:02:31] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 20:51:44] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-03 20:51:45] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 20:52:20] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 20:52:47] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-03 20:52:48] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 21:05:37] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-03 21:14:29] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-04 11:52:45] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-04 11:52:45] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'remember_token_expires' in 'SET'
SQL: UPDATE `users` SET remember_token = ?, remember_token_expires = ? WHERE id = ?
[2026-03-04 11:52:59] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-04 22:36:26] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-04 22:36:26] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-04 22:40:13] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-05 00:07:31] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-05 00:07:31] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-05 00:10:16] Query failed: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `kasazqgd_NoGo_POS`.`stock_movements`.`reference_id` at row 1
SQL: INSERT INTO `stock_movements` (`branch_id`, `product_id`, `movement_type`, `quantity`, `unit_cost`, `reference_type`, `reference_id`, `notes`, `performed_by`, `performed_at`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-05 00:10:45] Query failed: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `kasazqgd_NoGo_POS`.`stock_movements`.`reference_id` at row 1
SQL: INSERT INTO `stock_movements` (`branch_id`, `product_id`, `movement_type`, `quantity`, `unit_cost`, `reference_type`, `reference_id`, `notes`, `performed_by`, `performed_at`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-05 00:13:16] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-05 00:13:54] Query failed: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `kasazqgd_NoGo_POS`.`stock_movements`.`reference_id` at row 1
SQL: INSERT INTO `stock_movements` (`branch_id`, `product_id`, `movement_type`, `quantity`, `unit_cost`, `reference_type`, `reference_id`, `notes`, `performed_by`, `performed_at`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-05 10:16:42] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-05 10:16:43] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-05 10:17:20] Query failed: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `kasazqgd_NoGo_POS`.`stock_movements`.`reference_id` at row 1
SQL: INSERT INTO `stock_movements` (`branch_id`, `product_id`, `movement_type`, `quantity`, `unit_cost`, `reference_type`, `reference_id`, `notes`, `performed_by`, `performed_at`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-07 21:12:54] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-07 21:12:55] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-07 21:49:33] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-07 23:29:24] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-07 23:46:16] Query failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'performed_by' cannot be null
SQL: UPDATE `branch_inventory` SET quantity_on_hand = ? WHERE id = ?
[2026-03-07 23:48:53] Query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kasazqgd_NoGo_POS.purchase_order_items' doesn't exist
SQL: SELECT 
        po.*,
        s.supplier_name,
        s.supplier_code,
        s.contact_person,
        s.phone_primary as supplier_phone,
        b.branch_name,
        b.branch_code,
        u.username as created_by_name,
        CONCAT(u.first_name, ' ', u.surname) as created_by_fullname,
        ru.username as received_by_name,
        COUNT(poi.id) as item_count,
        COALESCE(SUM(poi.quantity), 0) as total_quantity
     FROM purchase_orders po
     JOIN suppliers s ON po.supplier_id = s.id
     JOIN branches b ON po.branch_id = b.id
     LEFT JOIN users u ON po.created_by = u.id
     LEFT JOIN users ru ON po.received_by = ru.id
     LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
     WHERE 1=1 AND DATE(po.order_date) BETWEEN ? AND ?
     GROUP BY po.id
     ORDER BY po.order_date DESC, po.id DESC
     LIMIT 100
[2026-03-07 23:57:23] Query failed: SQLSTATE[42S22]: Column not found: 1247 Reference 'on_time_deliveries' not supported (reference to group function)
SQL: SELECT 
        s.id,
        s.supplier_name,
        COUNT(CASE WHEN po.status = 'Received' AND po.received_date <= po.expected_delivery_date THEN 1 END) as on_time_deliveries,
        COUNT(CASE WHEN po.status = 'Received' AND po.received_date > po.expected_delivery_date THEN 1 END) as late_deliveries,
        COUNT(CASE WHEN po.status = 'Received' THEN 1 END) as total_received,
        AVG(CASE WHEN po.status = 'Received' THEN DATEDIFF(po.received_date, po.order_date) END) as avg_lead_time_days
     FROM suppliers s
     LEFT JOIN purchase_orders po ON s.id = po.supplier_id 
        AND po.status = 'Received'
        AND po.order_date >= DATE_SUB(CURDATE(), INTERVAL 180 DAY)
     WHERE s.is_active = 1
     GROUP BY s.id, s.supplier_name
     HAVING total_received > 0
     ORDER BY (on_time_deliveries / total_received) DESC
     LIMIT 10
[2026-03-08 00:01:49] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-08 00:40:27] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-08 01:08:05] Query failed: SQLSTATE[HY000]: General error: 1906 The value specified for generated column 'total_amount' in table 'sales_orders' has been ignored
SQL: INSERT INTO `sales_orders` (`order_number`, `branch_id`, `session_id`, `client_id`, `client_name`, `client_phone`, `order_type`, `payment_status`, `fulfillment_status`, `order_date`, `subtotal`, `discount_type`, `discount_value`, `tax_amount`, `total_amount`, `amount_paid`, `payment_method`, `payment_reference`, `mobile_money_number`, `card_last_four`, `cheque_number`, `bank_name`, `notes`, `created_by`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-08 01:08:16] Query failed: SQLSTATE[HY000]: General error: 1906 The value specified for generated column 'total_amount' in table 'sales_orders' has been ignored
SQL: INSERT INTO `sales_orders` (`order_number`, `branch_id`, `session_id`, `client_id`, `client_name`, `client_phone`, `order_type`, `payment_status`, `fulfillment_status`, `order_date`, `subtotal`, `discount_type`, `discount_value`, `tax_amount`, `total_amount`, `amount_paid`, `payment_method`, `payment_reference`, `mobile_money_number`, `card_last_four`, `cheque_number`, `bank_name`, `notes`, `created_by`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-08 01:39:53] Query failed: SQLSTATE[HY000]: General error: 1906 The value specified for generated column 'total_amount' in table 'sales_orders' has been ignored
SQL: INSERT INTO `sales_orders` (`order_number`, `branch_id`, `session_id`, `client_id`, `client_name`, `client_phone`, `client_email`, `order_type`, `payment_status`, `fulfillment_status`, `order_date`, `subtotal`, `discount_type`, `discount_value`, `tax_amount`, `total_amount`, `amount_paid`, `payment_method`, `payment_reference`, `mobile_money_number`, `card_last_four`, `cheque_number`, `bank_name`, `notes`, `created_by`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-08 01:40:04] Query failed: SQLSTATE[HY000]: General error: 1906 The value specified for generated column 'total_amount' in table 'sales_orders' has been ignored
SQL: INSERT INTO `sales_orders` (`order_number`, `branch_id`, `session_id`, `client_id`, `client_name`, `client_phone`, `client_email`, `order_type`, `payment_status`, `fulfillment_status`, `order_date`, `subtotal`, `discount_type`, `discount_value`, `tax_amount`, `total_amount`, `amount_paid`, `payment_method`, `payment_reference`, `mobile_money_number`, `card_last_four`, `cheque_number`, `bank_name`, `notes`, `created_by`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-08 01:40:13] Query failed: SQLSTATE[HY000]: General error: 1906 The value specified for generated column 'total_amount' in table 'sales_orders' has been ignored
SQL: INSERT INTO `sales_orders` (`order_number`, `branch_id`, `session_id`, `client_id`, `client_name`, `client_phone`, `client_email`, `order_type`, `payment_status`, `fulfillment_status`, `order_date`, `subtotal`, `discount_type`, `discount_value`, `tax_amount`, `total_amount`, `amount_paid`, `payment_method`, `payment_reference`, `mobile_money_number`, `card_last_four`, `cheque_number`, `bank_name`, `notes`, `created_by`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-08 01:40:24] Query failed: SQLSTATE[HY000]: General error: 1906 The value specified for generated column 'total_amount' in table 'sales_orders' has been ignored
SQL: INSERT INTO `sales_orders` (`order_number`, `branch_id`, `session_id`, `client_id`, `client_name`, `client_phone`, `client_email`, `order_type`, `payment_status`, `fulfillment_status`, `order_date`, `subtotal`, `discount_type`, `discount_value`, `tax_amount`, `total_amount`, `amount_paid`, `payment_method`, `payment_reference`, `mobile_money_number`, `card_last_four`, `cheque_number`, `bank_name`, `notes`, `created_by`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-08 21:32:02] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-09 18:00:47] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-10 08:49:14] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-10 18:18:02] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-10 18:51:42] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-10 18:51:42] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'remember_token_expires' in 'SET'
SQL: UPDATE `users` SET remember_token = ?, remember_token_expires = ? WHERE id = ?
[2026-03-10 18:52:32] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-10 18:53:16] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-10 18:58:16] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-10 19:02:24] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-10 19:30:45] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-10 19:30:46] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-10 19:40:24] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-10 19:50:57] Query failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'performed_by' cannot be null
SQL: UPDATE `branch_inventory` SET quantity_on_hand = ? WHERE id = ?
[2026-03-10 20:37:15] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-10 20:37:16] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-10 20:41:52] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-10 20:57:29] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-10 21:40:20] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-10 23:10:57] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-10 23:10:58] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 07:38:30] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-11 07:38:31] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 08:23:52] Query failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'performed_by' cannot be null
SQL: UPDATE `branch_inventory` SET quantity_on_hand = ? WHERE id = ?
[2026-03-11 12:56:09] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-11 12:56:10] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 14:58:50] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-11 14:58:50] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 14:59:07] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 15:00:00] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 15:05:02] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 15:19:34] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 15:35:28] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 15:35:42] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 16:03:40] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-11 16:03:41] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 16:07:55] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 17:12:49] Query failed: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'action' at row 1
SQL: INSERT INTO `audit_logs` (`table_name`, `record_id`, `action`, `old_data`, `new_data`, `ip_address`, `user_agent`, `performed_by`, `performed_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[2026-03-11 17:12:49] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
[2026-03-11 17:16:15] Query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'SELECT'
SQL: SELECT MAX(created_at) FROM audit_logs_archive
