EVOLUTION-NINJA

Edit File: log-2025-03-12.log

ERROR - 2025-03-12 08:29:25 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(116): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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} ERROR - 2025-03-12 08:29:43 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(116): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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} ERROR - 2025-03-12 08:35:04 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(115): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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} ERROR - 2025-03-12 08:35:12 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(115): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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} ERROR - 2025-03-12 08:36:48 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(115): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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} ERROR - 2025-03-12 08:40:47 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(114): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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} ERROR - 2025-03-12 08:41:01 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(114): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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} ERROR - 2025-03-12 08:41:05 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(114): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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} ERROR - 2025-03-12 08:41:42 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(114): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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} ERROR - 2025-03-12 08:43:38 --> mysqli_sql_exception: Unknown column 'name' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(114): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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-03-12 08:43:38 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'name' in 'field list' [Method: POST, Route: create-customer] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `payments` (`user_id`, `scheme`, `name`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (:user_id:, :scheme:, :name:, :request_id:, :promoter_id:, :remarks:, :payment_date:, :created_at:)', [...], false) 2 APPPATH/Controllers/Promoter.php(114): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() 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-03-12 08:43:38 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'name' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `payments` (`user_id`, `scheme`, `name`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID6439-KAVYA T\', \'1\', \'KAVYA T\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:43:38\', \'2025-03-12 08:43:38\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `payments` (`user_id`, `scheme`, `name`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID6439-KAVYA T\', \'1\', \'KAVYA T\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:43:38\', \'2025-03-12 08:43:38\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `payments` (`user_id`, `scheme`, `name`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (:user_id:, :scheme:, :name:, :request_id:, :promoter_id:, :remarks:, :payment_date:, :created_at:)', [...], false) 4 APPPATH/Controllers/Promoter.php(114): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() 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-03-12 08:43:38 --> [Caused by] mysqli_sql_exception: Unknown column 'name' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `payments` (`user_id`, `scheme`, `name`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID6439-KAVYA T\', \'1\', \'KAVYA T\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:43:38\', \'2025-03-12 08:43:38\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `payments` (`user_id`, `scheme`, `name`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID6439-KAVYA T\', \'1\', \'KAVYA T\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:43:38\', \'2025-03-12 08:43:38\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `payments` (`user_id`, `scheme`, `name`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID6439-KAVYA T\', \'1\', \'KAVYA T\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:43:38\', \'2025-03-12 08:43:38\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `payments` (`user_id`, `scheme`, `name`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (:user_id:, :scheme:, :name:, :request_id:, :promoter_id:, :remarks:, :payment_date:, :created_at:)', [...], false) 5 APPPATH/Controllers/Promoter.php(114): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() 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)) ERROR - 2025-03-12 08:45:26 --> mysqli_sql_exception: Unknown column 'request_id' in 'field list' 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('INSERT INTO `pa...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(113): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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-03-12 08:45:26 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'request_id' in 'field list' [Method: POST, Route: create-customer] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `payments` (`user_id`, `scheme`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (:user_id:, :scheme:, :request_id:, :promoter_id:, :remarks:, :payment_date:, :created_at:)', [...], false) 2 APPPATH/Controllers/Promoter.php(113): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() 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-03-12 08:45:26 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'request_id' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `payments` (`user_id`, `scheme`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID8910-KAVYA T\', \'1\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:45:26\', \'2025-03-12 08:45:26\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `payments` (`user_id`, `scheme`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID8910-KAVYA T\', \'1\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:45:26\', \'2025-03-12 08:45:26\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `payments` (`user_id`, `scheme`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (:user_id:, :scheme:, :request_id:, :promoter_id:, :remarks:, :payment_date:, :created_at:)', [...], false) 4 APPPATH/Controllers/Promoter.php(113): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() 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-03-12 08:45:26 --> [Caused by] mysqli_sql_exception: Unknown column 'request_id' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `payments` (`user_id`, `scheme`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID8910-KAVYA T\', \'1\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:45:26\', \'2025-03-12 08:45:26\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `payments` (`user_id`, `scheme`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID8910-KAVYA T\', \'1\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:45:26\', \'2025-03-12 08:45:26\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `payments` (`user_id`, `scheme`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (\'UID8910-KAVYA T\', \'1\', \'RI53090434\', \'6\', \'test\', \'2025-03-12 08:45:26\', \'2025-03-12 08:45:26\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `payments` (`user_id`, `scheme`, `request_id`, `promoter_id`, `remarks`, `payment_date`, `created_at`) VALUES (:user_id:, :scheme:, :request_id:, :promoter_id:, :remarks:, :payment_date:, :created_at:)', [...], false) 5 APPPATH/Controllers/Promoter.php(113): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->create_customer() 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)) CRITICAL - 2025-03-12 05:50:03 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "' customerId" [Method: GET, Route: customer-table-data1/%27%20%20%20customerId] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('customer-table-data1/\' customerId') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('customer-table-data1/\' customerId') 3 SYSTEMPATH/CodeIgniter.php(457): CodeIgniter\CodeIgniter->tryToRouteIt(Object(CodeIgniter\Router\RouteCollection)) 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2025-03-12 05:50:44 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "' customerId" [Method: GET, Route: customer-table-data1/%27%20%20%20customerId] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('customer-table-data1/\' customerId') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('customer-table-data1/\' customerId') 3 SYSTEMPATH/CodeIgniter.php(457): CodeIgniter\CodeIgniter->tryToRouteIt(Object(CodeIgniter\Router\RouteCollection)) 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2025-03-12 05:50:49 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "' customerId" [Method: GET, Route: customer-table-data1/%27%20customerId] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('customer-table-data1/\' customerId') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('customer-table-data1/\' customerId') 3 SYSTEMPATH/CodeIgniter.php(457): CodeIgniter\CodeIgniter->tryToRouteIt(Object(CodeIgniter\Router\RouteCollection)) 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2025-03-12 05:51:08 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "' customerId" [Method: GET, Route: customer-table-data1/%27%20customerId] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('customer-table-data1/\' customerId') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('customer-table-data1/\' customerId') 3 SYSTEMPATH/CodeIgniter.php(457): CodeIgniter\CodeIgniter->tryToRouteIt(Object(CodeIgniter\Router\RouteCollection)) 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2025-03-12 05:51:13 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "'customerId" [Method: GET, Route: customer-table-data1/%27customerId] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('customer-table-data1/\'customerId') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('customer-table-data1/\'customerId') 3 SYSTEMPATH/CodeIgniter.php(457): CodeIgniter\CodeIgniter->tryToRouteIt(Object(CodeIgniter\Router\RouteCollection)) 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) CRITICAL - 2025-03-12 05:52:10 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "'customerId" [Method: GET, Route: customer-table-data1/%27customerId] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('customer-table-data1/\'customerId') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('customer-table-data1/\'customerId') 3 SYSTEMPATH/CodeIgniter.php(457): CodeIgniter\CodeIgniter->tryToRouteIt(Object(CodeIgniter\Router\RouteCollection)) 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run() 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) ERROR - 2025-03-12 18:07:07 --> mysqli_sql_exception: Unknown column 'user.city' in 'field list' 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 `Custome...', 0) #1 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `Custome...') #2 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `Custome...') #3 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1782): CodeIgniter\Database\BaseConnection->query('SELECT `Custome...', Array, false) #4 /home/greenpalaceherit/public_html/app/Controllers/Promoter.php(876): CodeIgniter\Database\BaseBuilder->getWhere(Array) #5 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Promoter->getCustomerTableData1('97') #6 /home/greenpalaceherit/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Promoter)) #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-03-12 18:07:07 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'user.city' in 'field list' [Method: GET, Route: customer-table-data1/97] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1782): CodeIgniter\Database\BaseConnection->query('SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`city`, `payments`.`amount`, `payments`.`payment_date`, sum(payments.amount)as total_amount, `user`.`name` as `promoter_name`, `user`.`promoter_id`, `user`.`city` FROM `Customers` LEFT JOIN `payments` ON `payments`.`user_id` = `Customers`.`user_id` LEFT JOIN `user` ON `user`.`id` = `Customers`.`promoter_id` WHERE `Customers`.`id` = :Customers.id:', [...], false) 2 APPPATH/Controllers/Promoter.php(876): CodeIgniter\Database\BaseBuilder->getWhere([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->getCustomerTableData1('97') 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-03-12 18:07:07 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'user.city' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`city`, `payments`.`amount`, `payments`.`payment_date`, sum(payments.amount)as total_amount, `user`.`name` as `promoter_name`, `user`.`promoter_id`, `user`.`city` FROM `Customers` LEFT JOIN `payments` ON `payments`.`user_id` = `Customers`.`user_id` LEFT JOIN `user` ON `user`.`id` = `Customers`.`promoter_id` WHERE `Customers`.`id` = \'97\'') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`city`, `payments`.`amount`, `payments`.`payment_date`, sum(payments.amount)as total_amount, `user`.`name` as `promoter_name`, `user`.`promoter_id`, `user`.`city` FROM `Customers` LEFT JOIN `payments` ON `payments`.`user_id` = `Customers`.`user_id` LEFT JOIN `user` ON `user`.`id` = `Customers`.`promoter_id` WHERE `Customers`.`id` = \'97\'') 3 SYSTEMPATH/Database/BaseBuilder.php(1782): CodeIgniter\Database\BaseConnection->query('SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`city`, `payments`.`amount`, `payments`.`payment_date`, sum(payments.amount)as total_amount, `user`.`name` as `promoter_name`, `user`.`promoter_id`, `user`.`city` FROM `Customers` LEFT JOIN `payments` ON `payments`.`user_id` = `Customers`.`user_id` LEFT JOIN `user` ON `user`.`id` = `Customers`.`promoter_id` WHERE `Customers`.`id` = :Customers.id:', [...], false) 4 APPPATH/Controllers/Promoter.php(876): CodeIgniter\Database\BaseBuilder->getWhere([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->getCustomerTableData1('97') 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-03-12 18:07:07 --> [Caused by] mysqli_sql_exception: Unknown column 'user.city' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`city`, `payments`.`amount`, `payments`.`payment_date`, sum(payments.amount)as total_amount, `user`.`name` as `promoter_name`, `user`.`promoter_id`, `user`.`city` FROM `Customers` LEFT JOIN `payments` ON `payments`.`user_id` = `Customers`.`user_id` LEFT JOIN `user` ON `user`.`id` = `Customers`.`promoter_id` WHERE `Customers`.`id` = \'97\'', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`city`, `payments`.`amount`, `payments`.`payment_date`, sum(payments.amount)as total_amount, `user`.`name` as `promoter_name`, `user`.`promoter_id`, `user`.`city` FROM `Customers` LEFT JOIN `payments` ON `payments`.`user_id` = `Customers`.`user_id` LEFT JOIN `user` ON `user`.`id` = `Customers`.`promoter_id` WHERE `Customers`.`id` = \'97\'') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`city`, `payments`.`amount`, `payments`.`payment_date`, sum(payments.amount)as total_amount, `user`.`name` as `promoter_name`, `user`.`promoter_id`, `user`.`city` FROM `Customers` LEFT JOIN `payments` ON `payments`.`user_id` = `Customers`.`user_id` LEFT JOIN `user` ON `user`.`id` = `Customers`.`promoter_id` WHERE `Customers`.`id` = \'97\'') 4 SYSTEMPATH/Database/BaseBuilder.php(1782): CodeIgniter\Database\BaseConnection->query('SELECT `Customers`.`id`, `Customers`.`name`, `Customers`.`user_id`, `Customers`.`city`, `payments`.`amount`, `payments`.`payment_date`, sum(payments.amount)as total_amount, `user`.`name` as `promoter_name`, `user`.`promoter_id`, `user`.`city` FROM `Customers` LEFT JOIN `payments` ON `payments`.`user_id` = `Customers`.`user_id` LEFT JOIN `user` ON `user`.`id` = `Customers`.`promoter_id` WHERE `Customers`.`id` = :Customers.id:', [...], false) 5 APPPATH/Controllers/Promoter.php(876): CodeIgniter\Database\BaseBuilder->getWhere([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Promoter->getCustomerTableData1('97') 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))