EVOLUTION-NINJA

Edit File: log-2026-05-21.log

ERROR - 2026-05-21 12:20:51 --> mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) #7 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/vst/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2026-05-21 12:20:51 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' [Method: POST, Route: ae/get-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 5 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 6 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 7 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 8 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:20:51 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 7 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 8 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 9 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 10 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:20:51 --> [Caused by] mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 8 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 9 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 10 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 11 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) ERROR - 2026-05-21 12:32:20 --> mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) #7 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/vst/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2026-05-21 12:32:20 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' [Method: POST, Route: ae/get-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 5 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 6 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 7 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 8 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:32:20 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 7 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 8 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 9 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 10 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:32:20 --> [Caused by] mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 8 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 9 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 10 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 11 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) ERROR - 2026-05-21 12:32:24 --> mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) #7 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/vst/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2026-05-21 12:32:24 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' [Method: POST, Route: ae/get-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 5 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 6 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 7 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 8 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:32:24 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 7 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 8 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 9 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 10 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:32:24 --> [Caused by] mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 8 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 9 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 10 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 11 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) ERROR - 2026-05-21 12:34:10 --> mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) #7 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/vst/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2026-05-21 12:34:10 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' [Method: POST, Route: ae/get-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 5 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 6 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 7 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 8 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:34:10 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 7 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 8 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 9 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 10 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:34:10 --> [Caused by] mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEController.php(172): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 8 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 9 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 10 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 11 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) ERROR - 2026-05-21 12:37:14 --> mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEController.php(171): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) #7 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/vst/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2026-05-21 12:37:14 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' [Method: POST, Route: ae/get-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEController.php(171): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 5 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 6 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 7 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 8 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:37:14 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEController.php(171): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 7 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 8 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 9 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 10 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-21 12:37:14 --> [Caused by] mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `c`.`farmer_name`, `d`.`name` as `dealer_name`, `p`.`model_name`, `c`.`paid_amount` as `farmer_paid`, COALESCE(pay_sum.cumulative_subsidy_paid, 0) as total_subsidy_paid_till_date, `pay_details`.`paid_farmer_share`, `pay_details`.`farmer_share_utr_no`, `pay_details`.`farmer_payment_date`, `pay_details`.`subsidy_share_utr_no`, `pay_details`.`subsidy_payment_date` FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_code` = `c`.`dealer_id` LEFT JOIN `products` `p` ON `p`.`product_id` = `a`.`product_id` LEFT JOIN (SELECT `transaction_id`, SUM(total_amount) as cumulative_subsidy_paid FROM `ae_payments` WHERE `payment_for` = \'subsidy_share\' GROUP BY `transaction_id`) pay_sum ON `pay_sum`.`transaction_id` = `a`.`id` LEFT JOIN (SELECT `transaction_id`, `farmer_share_utr_no`, `farmer_payment_date`, `subsidy_share_utr_no`, `subsidy_payment_date`, `fsn_return_utr_no`, `farmer_share` as `paid_farmer_share` FROM `ae_payments` ORDER BY `id` DESC) pay_details ON `pay_details`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEController.php(171): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEController->getReport() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) 8 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 9 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 10 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 11 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) ERROR - 2026-05-21 12:39:47 --> mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEController.php(173): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) #7 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/vst/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} ERROR - 2026-05-21 12:39:47 --> [DataTables API Error] Unknown column 'fsn_return_utr_no' in 'field list' Line: 688 ERROR - 2026-05-21 12:40:56 --> mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEController.php(173): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) #7 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/vst/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} ERROR - 2026-05-21 12:40:56 --> [DataTables API Error] Unknown column 'fsn_return_utr_no' in 'field list' Line: 688 ERROR - 2026-05-21 12:41:10 --> mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEController.php(173): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) #7 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/vst/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} ERROR - 2026-05-21 12:41:10 --> [DataTables API Error] Unknown column 'fsn_return_utr_no' in 'field list' Line: 688 ERROR - 2026-05-21 12:41:47 --> mysqli_sql_exception: Unknown column 'fsn_return_utr_no' in 'field list' in /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `a`.*, `...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `a`.*, `...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `a`.*, `...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `a`.*, `...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEController.php(173): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEController)) #7 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/vst/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} ERROR - 2026-05-21 12:41:47 --> [DataTables API Error] Unknown column 'fsn_return_utr_no' in 'field list' Line: 688