EVOLUTION-NINJA
Edit File: log-2026-05-19.log
ERROR - 2026-05-19 04:39:02 --> mysqli_sql_exception: Unknown column '-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap.subsidy_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 `c`.`far...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`far...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`far...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`far...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(404): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) #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-19 04:39:02 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column '-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap.subsidy_share_utr_no' in 'field list' [Method: POST, Route: subsidy/get-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(404): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:39:02 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column '-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap.subsidy_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 `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(404): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:39:02 --> [Caused by] mysqli_sql_exception: Unknown column '-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap.subsidy_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 `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(404): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:39:04 --> mysqli_sql_exception: Unknown column '-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap.subsidy_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 `c`.`far...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`far...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`far...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`far...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(404): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) #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-19 04:39:04 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column '-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap.subsidy_share_utr_no' in 'field list' [Method: POST, Route: subsidy/get-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(404): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:39:04 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column '-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap.subsidy_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 `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(404): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:39:04 --> [Caused by] mysqli_sql_exception: Unknown column '-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap.subsidy_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 `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` as `farmer_code`, `c`.`farmer_name`, `c`.`dealer_name` as `dealer_name`, CONCAT(c.address, \', \', c.taluk) as farmer_address, `a`.`subsidy_amount`, `a`.`subsidy_utr`, `a`.`subsidy_date`, `a`.`rc_price` as `total_amt`, `a`.`tds`, `a`.`gst`, `d`.`tan_no`, `-- ✅ FIX 1: Grabs the available UTR column saved during payment submission ap`.`subsidy_share_utr_no` AS `subsidy_share_utr_no`, -- ✅ FIX 2: Corrected column name from \'subsidy_payment_date\' to match your save_payment array key ap.subsidy_payment_date AS subsidy_payment_date FROM `ae_transactions` `a` LEFT JOIN `create_customer` `c` ON `c`.`id` = `a`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`name` = `a`.`dealer_name` LEFT JOIN `ae_payments` `ap` ON `ap`.`transaction_id` = `a`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(404): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:50:26 --> mysqli_sql_exception: Table 'injayblues_vst_tractor.customers' doesn't exist 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 `c`.`far...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`far...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`far...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`far...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) #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-19 04:50:26 --> CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_vst_tractor.customers' doesn't exist [Method: POST, Route: subsidy/get-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:50:26 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_vst_tractor.customers' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:50:26 --> [Caused by] mysqli_sql_exception: Table 'injayblues_vst_tractor.customers' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:50:32 --> mysqli_sql_exception: Table 'injayblues_vst_tractor.customers' doesn't exist 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 `c`.`far...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`far...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`far...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`far...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) #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-19 04:50:32 --> CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_vst_tractor.customers' doesn't exist [Method: POST, Route: subsidy/get-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC', [], false) 2 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:50:32 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_vst_tractor.customers' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC', [], false) 4 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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-19 04:50:32 --> [Caused by] mysqli_sql_exception: Table 'injayblues_vst_tractor.customers' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `c`.`farmer_id` AS `farmer_code`, `c`.`farmer_name`, `a`.`dealer_name`, `c`.`address` AS `farmer_address`, `p`.`subsidy_amount`, `p`.`subsidy_share_utr_no`, `p`.`subsidy_payment_date`, `a`.`rc_price`, `a`.`subsidy_date` FROM `ae_transactions` `a` LEFT JOIN `ae_payments` `p` ON `p`.`customer_id` = `a`.`customer_id` AND `p`.`product_id` = `a`.`product_id` LEFT JOIN `customers` `c` ON `c`.`id` = `a`.`customer_id` ORDER BY `a`.`id` DESC', [], false) 5 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getReport() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AEReportController)) 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))