EVOLUTION-NINJA

Edit File: log-2025-04-26.log

ERROR - 2025-04-26 11:32:05 --> mysqli_sql_exception: Unknown column 'promoter_payments.promoter_id' in 'on clause' in /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `payment...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `payment...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `payment...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `payment...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Report.php(463): CodeIgniter\Database\BaseBuilder->get() #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Report->get_promoters_report() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report)) #7 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/greenpalaceherit/public_html/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2025-04-26 11:32:05 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'promoter_payments.promoter_id' in 'on clause' [Method: GET, Route: get-promoters-report] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `payments`.`promoter_id`, `payments`.`user_id`, `schemes`.`id` AS `scheme_id`, `schemes`.`scheme` AS `scheme_name`, `user`.`id` AS `user_id`, `user`.`promoter_id` AS `promoter`, `user`.`name`, SUM(payments.amount) AS total_amount, COUNT(payments.user_id) AS user_count FROM `payments` JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id` JOIN `user` ON `promoter_payments`.`promoter_id` = `user`.`id` WHERE `payments`.`created_at` >= :payments.created_at: AND `payments`.`created_at` <= :payments.created_at.1: GROUP BY `payments`.`promoter_id`', [...], false) 2 APPPATH/Controllers/Report.php(463): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_promoters_report() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report)) 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 - 2025-04-26 11:32:05 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'promoter_payments.promoter_id' in 'on clause' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `payments`.`promoter_id`, `payments`.`user_id`, `schemes`.`id` AS `scheme_id`, `schemes`.`scheme` AS `scheme_name`, `user`.`id` AS `user_id`, `user`.`promoter_id` AS `promoter`, `user`.`name`, SUM(payments.amount) AS total_amount, COUNT(payments.user_id) AS user_count FROM `payments` JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id` JOIN `user` ON `promoter_payments`.`promoter_id` = `user`.`id` WHERE `payments`.`created_at` >= \'2025-02-26\' AND `payments`.`created_at` <= \'2025-04-26\' GROUP BY `payments`.`promoter_id`') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `payments`.`promoter_id`, `payments`.`user_id`, `schemes`.`id` AS `scheme_id`, `schemes`.`scheme` AS `scheme_name`, `user`.`id` AS `user_id`, `user`.`promoter_id` AS `promoter`, `user`.`name`, SUM(payments.amount) AS total_amount, COUNT(payments.user_id) AS user_count FROM `payments` JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id` JOIN `user` ON `promoter_payments`.`promoter_id` = `user`.`id` WHERE `payments`.`created_at` >= \'2025-02-26\' AND `payments`.`created_at` <= \'2025-04-26\' GROUP BY `payments`.`promoter_id`') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `payments`.`promoter_id`, `payments`.`user_id`, `schemes`.`id` AS `scheme_id`, `schemes`.`scheme` AS `scheme_name`, `user`.`id` AS `user_id`, `user`.`promoter_id` AS `promoter`, `user`.`name`, SUM(payments.amount) AS total_amount, COUNT(payments.user_id) AS user_count FROM `payments` JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id` JOIN `user` ON `promoter_payments`.`promoter_id` = `user`.`id` WHERE `payments`.`created_at` >= :payments.created_at: AND `payments`.`created_at` <= :payments.created_at.1: GROUP BY `payments`.`promoter_id`', [...], false) 4 APPPATH/Controllers/Report.php(463): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_promoters_report() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report)) 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 - 2025-04-26 11:32:05 --> [Caused by] mysqli_sql_exception: Unknown column 'promoter_payments.promoter_id' in 'on clause' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `payments`.`promoter_id`, `payments`.`user_id`, `schemes`.`id` AS `scheme_id`, `schemes`.`scheme` AS `scheme_name`, `user`.`id` AS `user_id`, `user`.`promoter_id` AS `promoter`, `user`.`name`, SUM(payments.amount) AS total_amount, COUNT(payments.user_id) AS user_count FROM `payments` JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id` JOIN `user` ON `promoter_payments`.`promoter_id` = `user`.`id` WHERE `payments`.`created_at` >= \'2025-02-26\' AND `payments`.`created_at` <= \'2025-04-26\' GROUP BY `payments`.`promoter_id`', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `payments`.`promoter_id`, `payments`.`user_id`, `schemes`.`id` AS `scheme_id`, `schemes`.`scheme` AS `scheme_name`, `user`.`id` AS `user_id`, `user`.`promoter_id` AS `promoter`, `user`.`name`, SUM(payments.amount) AS total_amount, COUNT(payments.user_id) AS user_count FROM `payments` JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id` JOIN `user` ON `promoter_payments`.`promoter_id` = `user`.`id` WHERE `payments`.`created_at` >= \'2025-02-26\' AND `payments`.`created_at` <= \'2025-04-26\' GROUP BY `payments`.`promoter_id`') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `payments`.`promoter_id`, `payments`.`user_id`, `schemes`.`id` AS `scheme_id`, `schemes`.`scheme` AS `scheme_name`, `user`.`id` AS `user_id`, `user`.`promoter_id` AS `promoter`, `user`.`name`, SUM(payments.amount) AS total_amount, COUNT(payments.user_id) AS user_count FROM `payments` JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id` JOIN `user` ON `promoter_payments`.`promoter_id` = `user`.`id` WHERE `payments`.`created_at` >= \'2025-02-26\' AND `payments`.`created_at` <= \'2025-04-26\' GROUP BY `payments`.`promoter_id`') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `payments`.`promoter_id`, `payments`.`user_id`, `schemes`.`id` AS `scheme_id`, `schemes`.`scheme` AS `scheme_name`, `user`.`id` AS `user_id`, `user`.`promoter_id` AS `promoter`, `user`.`name`, SUM(payments.amount) AS total_amount, COUNT(payments.user_id) AS user_count FROM `payments` JOIN `schemes` ON `promoter_payments`.`scheme` = `schemes`.`id` JOIN `user` ON `promoter_payments`.`promoter_id` = `user`.`id` WHERE `payments`.`created_at` >= :payments.created_at: AND `payments`.`created_at` <= :payments.created_at.1: GROUP BY `payments`.`promoter_id`', [...], false) 5 APPPATH/Controllers/Report.php(463): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_promoters_report() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report)) 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))