EVOLUTION-NINJA

Edit File: log-2025-01-28.log

INFO - 2025-01-28 20:20:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:21:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2025-01-28 20:22:04 --> Error: Call to undefined function App\Controllers\print_t() [Method: POST, Route: withdraw-amount-request] in APPPATH/Controllers/Promoter.php on line 483. 1 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_amount_request() 2 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) 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)) INFO - 2025-01-28 20:22:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:23:21 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:26:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2025-01-28 20:27:08 --> mysqli_sql_exception: Cannot add or update a child row: a foreign key constraint fails (`injayblues_smart_finance`.`withdraw_requests`, CONSTRAINT `withdraw_requests_ibfk_1` FOREIGN KEY (`promoter_id`) REFERENCES `user` (`id`)) in /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `wi...', 0) #1 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `wi...') #2 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `wi...') #3 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `wi...', Array, false) #4 /home/injayblues/public_html/Green_Palace_Heritage/app/Controllers/Promoter.php(539): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_amount_request() #6 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #7 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/Green_Palace_Heritage/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/Green_Palace_Heritage/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2025-01-28 20:27:08 --> CodeIgniter\Database\Exceptions\DatabaseException: Cannot add or update a child row: a foreign key constraint fails (`injayblues_smart_finance`.`withdraw_requests`, CONSTRAINT `withdraw_requests_ibfk_1` FOREIGN KEY (`promoter_id`) REFERENCES `user` (`id`)) [Method: POST, Route: withdraw-amount-request] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `withdraw_requests` (`promoter_id`, `amount`, `scheme`, `status`) VALUES (:promoter_id:, :amount:, :scheme:, :status:)', [...], false) 2 APPPATH/Controllers/Promoter.php(539): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_amount_request() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) 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-01-28 20:27:08 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Cannot add or update a child row: a foreign key constraint fails (`injayblues_smart_finance`.`withdraw_requests`, CONSTRAINT `withdraw_requests_ibfk_1` FOREIGN KEY (`promoter_id`) REFERENCES `user` (`id`)) in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `withdraw_requests` (`promoter_id`, `amount`, `scheme`, `status`) VALUES (\'PID5453\', \'50\', \'2\', \'Pending\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `withdraw_requests` (`promoter_id`, `amount`, `scheme`, `status`) VALUES (\'PID5453\', \'50\', \'2\', \'Pending\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `withdraw_requests` (`promoter_id`, `amount`, `scheme`, `status`) VALUES (:promoter_id:, :amount:, :scheme:, :status:)', [...], false) 4 APPPATH/Controllers/Promoter.php(539): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_amount_request() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) 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-01-28 20:27:08 --> [Caused by] mysqli_sql_exception: Cannot add or update a child row: a foreign key constraint fails (`injayblues_smart_finance`.`withdraw_requests`, CONSTRAINT `withdraw_requests_ibfk_1` FOREIGN KEY (`promoter_id`) REFERENCES `user` (`id`)) in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `withdraw_requests` (`promoter_id`, `amount`, `scheme`, `status`) VALUES (\'PID5453\', \'50\', \'2\', \'Pending\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `withdraw_requests` (`promoter_id`, `amount`, `scheme`, `status`) VALUES (\'PID5453\', \'50\', \'2\', \'Pending\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `withdraw_requests` (`promoter_id`, `amount`, `scheme`, `status`) VALUES (\'PID5453\', \'50\', \'2\', \'Pending\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `withdraw_requests` (`promoter_id`, `amount`, `scheme`, `status`) VALUES (:promoter_id:, :amount:, :scheme:, :status:)', [...], false) 5 APPPATH/Controllers/Promoter.php(539): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_amount_request() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) 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)) INFO - 2025-01-28 20:28:51 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:29:46 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:30:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:38:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:46:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 15:16:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:46:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-28 20:46:18 --> Promoter ID: 6 DEBUG - 2025-01-28 20:46:18 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-28 20:46:18 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 51 [total_request] => 2 [total_initial] => 6 ) INFO - 2025-01-28 20:47:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:48:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 15:18:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:48:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-28 20:48:20 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email` FROM `admin` WHERE `admin`.`id` = '1' DEBUG - 2025-01-28 20:48:20 --> Admin Data: Array ( [id] => 1 [username] => kavya [role_name] => Super Admin [email] => kavyat7349@gmail.com ) DEBUG - 2025-01-28 20:48:20 --> Customer Query: SELECT COUNT(id) as total_pins FROM `promoter_repayment_requests` DEBUG - 2025-01-28 20:48:20 --> Customer Count: Array ( [total_customers] => 57 ) DEBUG - 2025-01-28 20:48:20 --> Amount Query: SELECT SUM(amount) as total_amount FROM `payments` DEBUG - 2025-01-28 20:48:20 --> Amount Data: Array ( [total_amount] => 21000 ) INFO - 2025-01-28 20:49:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2025-01-28 20:49:12 --> ErrorException: Undefined array key "requested_amount" [Method: GET, Route: withdraw-request-approval] in APPPATH/Views/admin/withdraw_request_approval.php on line 192. 1 APPPATH/Views/admin/withdraw_request_approval.php(192): CodeIgniter\Debug\Exceptions->errorHandler(2, 'Undefined array key "requested_amount"', '/home/injayblues/public_html/Green_Palace_Heritage/app/Views/admin/withdraw_request_approval.php', 192) 2 SYSTEMPATH/View/View.php(234): include('/home/injayblues/public_html/Green_Palace_Heritage/app/Views/admin/withdraw_request_approval.php') 3 SYSTEMPATH/View/View.php(237): CodeIgniter\View\View->CodeIgniter\View\{closure}() 4 SYSTEMPATH/Common.php(1171): CodeIgniter\View\View->render('admin/withdraw_request_approval', [], true) 5 APPPATH/Controllers/Promoter.php(574): view('admin/withdraw_request_approval', [...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_request_approval() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) 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)) INFO - 2025-01-28 20:50:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:52:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:55:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:56:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 15:26:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:56:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-28 20:56:20 --> Promoter ID: 6 DEBUG - 2025-01-28 20:56:20 --> Query: SELECT `user`.*, `user`.`id` as `user_id`, `promoter_payments`.`promoter_id`, SUM(promoter_payments.amount) as total_earnings, (SELECT SUM(amount) FROM payments WHERE payments.promoter_id = promoter_payments.promoter_id) as total_amount, `user_details`.`city`, `user`.`phone`, `user`.`email`, (SELECT COUNT(DISTINCT Customers.id) FROM Customers WHERE Customers.promoter_id = promoter_payments.promoter_id) as total_customers, (SELECT COUNT(DISTINCT promoter_repayment_requests.id) FROM promoter_repayment_requests WHERE promoter_repayment_requests.promoter_id = promoter_payments.promoter_id) as total_request, (SELECT COUNT(DISTINCT promoter_requests.id) FROM promoter_requests WHERE promoter_requests.promoter_id = promoter_payments.promoter_id) as total_initial FROM `promoter_payments` LEFT JOIN `user` ON `user`.`id` = `promoter_payments`.`promoter_id` LEFT JOIN `user_details` ON `promoter_payments`.`promoter_id` = `user_details`.`user_id` WHERE `promoter_payments`.`promoter_id` = '6' GROUP BY `promoter_payments`.`promoter_id` DEBUG - 2025-01-28 20:56:20 --> Data: Array ( [id] => 6 [name] => KAVYA T [email] => Kvy547@gmail.com [valid_user] => 1 [phone] => 7349645690 [password] => $2y$10$mDY1OAr.lYAgB5wKyttrA.dw9exA11lbItyWNcvuJQAhHZ2L620bO [promoter_id] => 6 [role] => 1 [role_name] => promoter [created_at] => 0000-00-00 00:00:00.000000 [user_id] => 6 [total_earnings] => 6200 [total_amount] => 12000 [city] => H D KOTE [total_customers] => 51 [total_request] => 2 [total_initial] => 6 ) INFO - 2025-01-28 20:57:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 20:58:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 21:00:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 21:00:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 21:00:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 15:30:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 21:00:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. DEBUG - 2025-01-28 21:00:50 --> Admin Query: SELECT `admin`.`id`, `admin`.`username`, `admin`.`role_name`, `admin`.`email` FROM `admin` WHERE `admin`.`id` = '1' DEBUG - 2025-01-28 21:00:50 --> Admin Data: Array ( [id] => 1 [username] => kavya [role_name] => Super Admin [email] => kavyat7349@gmail.com ) DEBUG - 2025-01-28 21:00:50 --> Customer Query: SELECT COUNT(id) as total_pins FROM `promoter_repayment_requests` DEBUG - 2025-01-28 21:00:50 --> Customer Count: Array ( [total_customers] => 57 ) DEBUG - 2025-01-28 21:00:50 --> Amount Query: SELECT SUM(amount) as total_amount FROM `payments` DEBUG - 2025-01-28 21:00:50 --> Amount Data: Array ( [total_amount] => 21000 ) INFO - 2025-01-28 21:01:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2025-01-28 21:01:02 --> ErrorException: Undefined array key "request_id" [Method: GET, Route: withdraw-request-approval] in APPPATH/Views/admin/withdraw_request_approval.php on line 196. 1 APPPATH/Views/admin/withdraw_request_approval.php(196): CodeIgniter\Debug\Exceptions->errorHandler(2, 'Undefined array key "request_id"', '/home/injayblues/public_html/Green_Palace_Heritage/app/Views/admin/withdraw_request_approval.php', 196) 2 SYSTEMPATH/View/View.php(234): include('/home/injayblues/public_html/Green_Palace_Heritage/app/Views/admin/withdraw_request_approval.php') 3 SYSTEMPATH/View/View.php(237): CodeIgniter\View\View->CodeIgniter\View\{closure}() 4 SYSTEMPATH/Common.php(1171): CodeIgniter\View\View->render('admin/withdraw_request_approval', [], true) 5 APPPATH/Controllers/Promoter.php(567): view('admin/withdraw_request_approval', [...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->withdraw_request_approval() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) 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)) INFO - 2025-01-28 21:02:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2025-01-28 16:55:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.