EVOLUTION-NINJA

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

CRITICAL - 2026-05-22 06:33:53 --> TypeError: Unsupported operand types: string * int [Method: POST, Route: save-ae-calculator] in APPPATH/Controllers/ProductController.php on line 453. 1 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\ProductController->saveAECalculator() 2 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\ProductController)) 3 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 4 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 5 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 6 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2026-05-22 06:33:59 --> TypeError: Unsupported operand types: string * int [Method: POST, Route: save-ae-calculator] in APPPATH/Controllers/ProductController.php on line 453. 1 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\ProductController->saveAECalculator() 2 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\ProductController)) 3 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 4 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 5 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 6 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) ERROR - 2026-05-22 13:12:44 --> mysqli_sql_exception: Column 'photo' cannot be null 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('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #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-22 13:12:44 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null [Method: POST, Route: create-customer-submit] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 13:12:44 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435764_1779435764_5b93a8cc600a4ae2728d.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:44\', \'Admin\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435764_1779435764_5b93a8cc600a4ae2728d.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:44\', \'Admin\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 13:12:44 --> [Caused by] mysqli_sql_exception: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435764_1779435764_5b93a8cc600a4ae2728d.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:44\', \'Admin\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435764_1779435764_5b93a8cc600a4ae2728d.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:44\', \'Admin\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435764_1779435764_5b93a8cc600a4ae2728d.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:44\', \'Admin\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 13:12:45 --> mysqli_sql_exception: Column 'photo' cannot be null 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('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #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-22 13:12:45 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null [Method: POST, Route: create-customer-submit] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 13:12:45 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435765_1779435765_f1e20c76333c673da77c.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:45\', \'Admin\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435765_1779435765_f1e20c76333c673da77c.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:45\', \'Admin\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 13:12:45 --> [Caused by] mysqli_sql_exception: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435765_1779435765_f1e20c76333c673da77c.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:45\', \'Admin\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435765_1779435765_f1e20c76333c673da77c.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:45\', \'Admin\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'MYS49250526002\', \'Harshitha D/o of Nagesh\', \'100000\', \'KR Nagar\', \'KR Nagar, Mysore\', \'MYS4925\', \'Mahesh\', \'General\', \'2134345656\', \'213455\', \'23rt564\', \'f54566666\', \'4536hyt\', \'RID0526003\', \'10000\', \'10000\', NULL, \'FID12345678900\', \'Har/23\', \'3234err\', \'1234erer\', NULL, \'N/A\', NULL, \'1779435765_1779435765_f1e20c76333c673da77c.jpeg\', \'Chain Cutter\', \'44\', \'200000.00\', \'17.650000\', \'170000.00\', \'2026-05-22 13:12:45\', \'Admin\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 08:05:04 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() #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-22 08:05:04 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:05:04 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:05:04 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:05:12 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() #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-22 08:05:12 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:05:12 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:05:12 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:05:34 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() #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-22 08:05:34 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:05:34 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:05:34 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:06:51 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() #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-22 08:06:51 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:06:51 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:06:51 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:08:19 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() #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-22 08:08:19 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:08:19 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:08:19 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:08:54 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() #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-22 08:08:54 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:08:54 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:08:54 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:09:00 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() #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-22 08:09:00 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:09:00 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:09:00 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(461): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:10:00 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', 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->getConsolidatedData() #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-22 08:10:00 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', [], false) 2 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:10:00 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', [], false) 4 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:10:00 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', [], false) 5 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:10:09 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', 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->getConsolidatedData() #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-22 08:10:09 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', [], false) 2 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:10:09 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', [], false) 4 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:10:09 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', [], false) 5 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:10:15 --> mysqli_sql_exception: Unknown column 't.dealer_code' 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 `t`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dea...', 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->getConsolidatedData() #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-22 08:10:15 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', [], false) 2 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:10:15 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', [], false) 4 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:10:15 --> [Caused by] mysqli_sql_exception: Unknown column 't.dealer_code' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `t`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, `t`.`subsidy_amount`, `t`.`ae_commission` FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id`', [], false) 5 APPPATH/Controllers/AEReportController.php(472): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:12:53 --> mysqli_sql_exception: Unknown column 'd.dealer_name' in 'on clause' 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 `d`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `d`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `d`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `d`.`dea...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(464): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() #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-22 08:12:53 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'd.dealer_name' in 'on clause' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(464): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:12:53 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'd.dealer_name' in 'on clause' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(464): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:12:53 --> [Caused by] mysqli_sql_exception: Unknown column 'd.dealer_name' in 'on clause' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(464): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:15:14 --> mysqli_sql_exception: Unknown column 'd.dealer_name' in 'on clause' 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 `d`.`dea...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `d`.`dea...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `d`.`dea...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `d`.`dea...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/AEReportController.php(464): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() #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-22 08:15:14 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'd.dealer_name' in 'on clause' [Method: POST, Route: ae/get-consolidated-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 2 APPPATH/Controllers/AEReportController.php(464): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:15:14 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'd.dealer_name' in 'on clause' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 4 APPPATH/Controllers/AEReportController.php(464): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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-22 08:15:14 --> [Caused by] mysqli_sql_exception: Unknown column 'd.dealer_name' in 'on clause' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `d`.`dealer_code`, `t`.`dealer_name`, `c`.`farmer_id`, `c`.`farmer_name`, `t`.`rc_price`, `t`.`farmer_share`, COALESCE(p.total_farmer_paid, 0) as farmer_paid, (t.farmer_share - COALESCE(p.total_farmer_paid, 0)) as farmer_balance, `t`.`subsidy_amount`, `t`.`ae_commission`, COALESCE(p.total_subsidy_paid, 0) as subsidy_paid, ((t.subsidy_amount - t.ae_commission) - COALESCE(p.total_subsidy_paid, 0)) as subsidy_balance FROM `ae_transactions` `t` LEFT JOIN `create_customer` `c` ON `c`.`id` = `t`.`customer_id` LEFT JOIN `dealers` `d` ON `d`.`dealer_name` = `t`.`dealer_name` LEFT JOIN ( SELECT transaction_id, SUM(CASE WHEN payment_for = "farmer_share" THEN total_amount ELSE 0 END) as total_farmer_paid, SUM(CASE WHEN payment_for = "subsidy_share" THEN total_amount ELSE 0 END) as total_subsidy_paid FROM ae_payments GROUP BY transaction_id ) p ON `p`.`transaction_id` = `t`.`id`', [], false) 5 APPPATH/Controllers/AEReportController.php(464): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\AEReportController->getConsolidatedData() 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)) CRITICAL - 2026-05-22 09:31:21 --> ErrorException: Cannot redeclare App\Controllers\AEReportController::exportConsolidatedExcel() [Method: GET, Route: ae/consolidated-report] in APPPATH/Controllers/AEReportController.php on line 466. 1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler() ERROR - 2026-05-22 17:57:24 --> mysqli_sql_exception: Column 'photo' cannot be null 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('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #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-22 17:57:24 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null [Method: POST, Route: create-customer-submit] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:24 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452844_1779452844_f417f774f943458c6276.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:24\', \'Admin\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452844_1779452844_f417f774f943458c6276.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:24\', \'Admin\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:24 --> [Caused by] mysqli_sql_exception: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452844_1779452844_f417f774f943458c6276.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:24\', \'Admin\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452844_1779452844_f417f774f943458c6276.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:24\', \'Admin\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452844_1779452844_f417f774f943458c6276.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:24\', \'Admin\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:26 --> mysqli_sql_exception: Column 'photo' cannot be null 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('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #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-22 17:57:26 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null [Method: POST, Route: create-customer-submit] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:26 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452846_1779452846_e6e14fbd87c5aaba3819.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:26\', \'Admin\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452846_1779452846_e6e14fbd87c5aaba3819.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:26\', \'Admin\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:26 --> [Caused by] mysqli_sql_exception: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452846_1779452846_e6e14fbd87c5aaba3819.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:26\', \'Admin\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452846_1779452846_e6e14fbd87c5aaba3819.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:26\', \'Admin\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452846_1779452846_e6e14fbd87c5aaba3819.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:26\', \'Admin\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:27 --> mysqli_sql_exception: Column 'photo' cannot be null 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('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #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-22 17:57:27 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null [Method: POST, Route: create-customer-submit] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:27 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452847_1779452847_eaf03387ffcd0893cc1b.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:27\', \'Admin\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452847_1779452847_eaf03387ffcd0893cc1b.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:27\', \'Admin\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:27 --> [Caused by] mysqli_sql_exception: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452847_1779452847_eaf03387ffcd0893cc1b.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:27\', \'Admin\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452847_1779452847_eaf03387ffcd0893cc1b.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:27\', \'Admin\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452847_1779452847_eaf03387ffcd0893cc1b.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:27\', \'Admin\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:35 --> mysqli_sql_exception: Column 'photo' cannot be null 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('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #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-22 17:57:35 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null [Method: POST, Route: create-customer-submit] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:35 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452855_1779452855_ee2bb8facf708309a34c.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:35\', \'Admin\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452855_1779452855_ee2bb8facf708309a34c.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:35\', \'Admin\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:35 --> [Caused by] mysqli_sql_exception: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452855_1779452855_ee2bb8facf708309a34c.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:35\', \'Admin\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452855_1779452855_ee2bb8facf708309a34c.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:35\', \'Admin\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452855_1779452855_ee2bb8facf708309a34c.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:35\', \'Admin\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:36 --> mysqli_sql_exception: Column 'photo' cannot be null 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('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/vst/app/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() #6 /home/injayblues/public_html/vst/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #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-22 17:57:36 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null [Method: POST, Route: create-customer-submit] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:36 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452856_1779452856_b92119b1243ffc6fa5c9.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:36\', \'Admin\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452856_1779452856_b92119b1243ffc6fa5c9.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:36\', \'Admin\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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-22 17:57:36 --> [Caused by] mysqli_sql_exception: Column 'photo' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452856_1779452856_b92119b1243ffc6fa5c9.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:36\', \'Admin\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452856_1779452856_b92119b1243ffc6fa5c9.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:36\', \'Admin\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (\'HAS18180526001\', \'ukfy\', \'56897\', \'Hagaribommanahalli\', \'Hagaribommanahalli\', \'HAS1818\', \'Lekhana\', \'General\', \'\', \'876666\', \'7499780\', \'789\', \'7687u\', \'RID0526005\', \'78888\', \'67887\', NULL, \'\', \'6777u8hygb\', \'22222\', \'11111\', NULL, \'N/A\', NULL, \'1779452856_1779452856_b92119b1243ffc6fa5c9.jpeg\', \'Brush Cutter\', \'42\', \'150000.00\', \'15.380000\', \'130000.00\', \'2026-05-22 17:57:36\', \'Admin\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_customer` (`farmer_id`, `farmer_name`, `share_amount`, `taluk`, `address`, `dealer_id`, `dealer_name`, `category`, `phone_no`, `pin_code`, `part_no`, `hsn_code`, `vin_no`, `recipient_id`, `central_gov_share`, `state_gov_share`, `gstin`, `fid_no`, `unique_code`, `engine_no`, `chasis_no`, `utr_no`, `aadhar_no`, `photo`, `invoice_file`, `product_type`, `product_id`, `rc_price`, `gst_percent`, `basic_price`, `created_at`, `created_by`) VALUES (:farmer_id:, :farmer_name:, :share_amount:, :taluk:, :address:, :dealer_id:, :dealer_name:, :category:, :phone_no:, :pin_code:, :part_no:, :hsn_code:, :vin_no:, :recipient_id:, :central_gov_share:, :state_gov_share:, :gstin:, :fid_no:, :unique_code:, :engine_no:, :chasis_no:, :utr_no:, :aadhar_no:, :photo:, :invoice_file:, :product_type:, :product_id:, :rc_price:, :gst_percent:, :basic_price:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(415): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_customer_submit() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) 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))