EVOLUTION-NINJA

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

ERROR - 2026-05-16 10:06:31 --> mysqli_sql_exception: Unknown column 'ap.farmer_share_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(334): 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-16 10:06:31 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'ap.farmer_share_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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEController.php(334): 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-16 10:06:31 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'ap.farmer_share_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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEController.php(334): 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-16 10:06:31 --> [Caused by] mysqli_sql_exception: Unknown column 'ap.farmer_share_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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEController.php(334): 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-16 10:09:41 --> mysqli_sql_exception: Unknown column 'ap.farmer_share_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(334): 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-16 10:09:41 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'ap.farmer_share_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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEController.php(334): 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-16 10:09:41 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'ap.farmer_share_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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEController.php(334): 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-16 10:09:41 --> [Caused by] mysqli_sql_exception: Unknown column 'ap.farmer_share_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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEController.php(334): 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-16 10:12:32 --> mysqli_sql_exception: Unknown column 'ap.farmer_share_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(334): 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-16 10:12:32 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'ap.farmer_share_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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEController.php(334): 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-16 10:12:32 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'ap.farmer_share_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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEController.php(334): 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-16 10:12:32 --> [Caused by] mysqli_sql_exception: Unknown column 'ap.farmer_share_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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`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`, `ap`.`subsidy_amount` as `paid_subsidy`, `ap`.`farmer_share` as `paid_farmer_share`, `ap`.`farmer_share_utr_no`, `ap`.`farmer_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 `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEController.php(334): 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)) CRITICAL - 2026-05-16 18:13:56 --> ParseError: syntax error, unexpected token "public", expecting end of file [Method: GET, Route: AEReportController/exportFarmerExcel] in APPPATH/Controllers/AEReportController.php on line 549. 1 FCPATH/vendor/composer/ClassLoader.php(427): Composer\Autoload\{closure}('/home/injayblues/public_html/vst/vendor/composer/../../app/Controllers/AEReportController.php') 2 [internal function]: Composer\Autoload\ClassLoader->loadClass('App\\Controllers\\AEReportController') 3 SYSTEMPATH/CodeIgniter.php(887): class_exists('\\App\\Controllers\\AEReportController', true) 4 SYSTEMPATH/CodeIgniter.php(496): CodeIgniter\CodeIgniter->startController() 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))