EVOLUTION-NINJA

Edit File: log-2024-10-01.log

INFO - 2024-10-01 05:18:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:18:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:19:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:19:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:19:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:24:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:24:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:27:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2024-10-01 05:27:05 --> CodeIgniter\HTTP\Exceptions\HTTPException: The original file is not a valid file. [Method: POST, Route: create_department] in SYSTEMPATH/HTTP/Files/UploadedFile.php on line 142. 1 SYSTEMPATH/HTTP/Files/UploadedFile.php(142): CodeIgniter\HTTP\Exceptions\HTTPException::forInvalidFile() 2 APPPATH/Controllers/Department.php(26): CodeIgniter\HTTP\Files\UploadedFile->move('/home/injayblues/public_html/nirmithi_kendra/public/departmentLogo/', '1727760425_4ba5697d69f6710d9a38') 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Department->create_department() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Department)) 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)) INFO - 2024-10-01 05:27:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:27:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:29:02 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:31:20 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:31:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:38:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:38:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:39:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:41:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:41:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:43:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:47:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:48:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:48:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:48:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:48:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:48:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:48:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:49:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:49:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:49:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:49:19 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:49:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:49:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:49:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:49:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:49:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 05:53:27 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 06:33:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 07:57:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 07:57:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 07:57:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 07:57:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 07:59:09 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:02:55 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:03:24 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:03:25 --> mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->project_list_data() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:03:25 --> CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist [Method: GET, Route: project-list-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 2 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:03:25 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 4 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:03:25 --> [Caused by] mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 5 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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)) INFO - 2024-10-01 08:04:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:04:24 --> mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->project_list_data() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:04:24 --> CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist [Method: GET, Route: project-list-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 2 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:04:24 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 4 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:04:24 --> [Caused by] mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 5 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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)) INFO - 2024-10-01 08:04:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:04:46 --> mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->project_list_data() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:04:46 --> CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist [Method: GET, Route: project-list-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 2 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:04:46 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 4 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:04:46 --> [Caused by] mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.create_project' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 5 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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)) INFO - 2024-10-01 08:10:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:10:29 --> mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.approval_documents' doesn't exist in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->project_list_data() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:10:29 --> CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.approval_documents' doesn't exist [Method: GET, Route: project-list-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 2 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:10:29 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.approval_documents' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 4 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:10:29 --> [Caused by] mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.approval_documents' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 5 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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)) INFO - 2024-10-01 08:10:38 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:10:41 --> mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.approval_documents' doesn't exist in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->project_list_data() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:10:41 --> CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.approval_documents' doesn't exist [Method: GET, Route: project-list-data] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 2 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:10:41 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Table 'injayblues_nirmiti_kendra.approval_documents' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 317. 1 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 4 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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 - 2024-10-01 08:10:41 --> [Caused by] mysqli_sql_exception: Table 'injayblues_nirmiti_kendra.approval_documents' doesn't exist in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC') 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `constituency_master`.`mla` AS `mla`, `roles_creation_apm`.`first_name` AS `apm_first_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, GROUP_CONCAT(DISTINCT proposal_documents.document_name SEPARATOR ", ") AS proposal_document_names, GROUP_CONCAT(DISTINCT estimation_documents.document_name SEPARATOR ", ") AS estimation_document_names, GROUP_CONCAT(DISTINCT approval_documents.document_name SEPARATOR ", ") AS approval_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure FROM `create_project` LEFT JOIN `department` ON `department`.`id` = `create_project`.`department` LEFT JOIN `constituency` ON `constituency`.`id` = `create_project`.`constituency` LEFT JOIN `constituency_master` ON `constituency_master`.`constituency_name` = `create_project`.`constituency` LEFT JOIN `roles_creation` AS `roles_creation_apm` ON `roles_creation_apm`.`id` = `create_project`.`apm` LEFT JOIN `roles_creation` AS `roles_creation_engineer` ON `roles_creation_engineer`.`id` = `create_project`.`engineer` LEFT JOIN `proposal_documents` ON `proposal_documents`.`project_id` = `create_project`.`id` LEFT JOIN `estimation_documents` ON `estimation_documents`.`project_id` = `create_project`.`id` LEFT JOIN `approval_documents` ON `approval_documents`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(released_amount) AS total_released_amount FROM released_amounts GROUP BY project_id) AS total_released ON `total_released`.`project_id` = `create_project`.`id` LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure FROM expenditure GROUP BY project_id) AS total_expenditure ON `total_expenditure`.`project_id` = `create_project`.`id` GROUP BY `create_project`.`id` ORDER BY `create_project`.`created_at` DESC', [], false) 5 APPPATH/Controllers/Project.php(282): CodeIgniter\Database\BaseBuilder->get() 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data() 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)) INFO - 2024-10-01 08:11:34 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:12:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2024-10-01 08:12:30 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "project (1).png" [Method: GET, Route: project-edit/public/assets/images/project%20%281%29.png] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('project-edit/public/assets/images/project (1).png') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('project-edit/public/assets/images/project (1).png') 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)) INFO - 2024-10-01 08:16:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:16:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:17:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:21:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:21:25 --> mysqli_sql_exception: Column 'engineer' cannot be null in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_project() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:21:25 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' cannot be null [Method: POST, Route: create-project] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:25 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' 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_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:25\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:25\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:25 --> [Caused by] mysqli_sql_exception: Column 'engineer' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:25\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:25\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:25\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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)) INFO - 2024-10-01 08:21:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:21:29 --> mysqli_sql_exception: Column 'engineer' cannot be null in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_project() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:21:29 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' cannot be null [Method: POST, Route: create-project] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:29 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' 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_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:29\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:29\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:29 --> [Caused by] mysqli_sql_exception: Column 'engineer' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:29\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:29\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:29\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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)) INFO - 2024-10-01 08:21:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:21:39 --> mysqli_sql_exception: Column 'engineer' cannot be null in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_project() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:21:39 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' cannot be null [Method: POST, Route: create-project] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:39 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' 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_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:39\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:39\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:39 --> [Caused by] mysqli_sql_exception: Column 'engineer' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:39\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:39\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'4\', \'2024-10-01 08:21:39\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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)) INFO - 2024-10-01 08:21:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:21:57 --> mysqli_sql_exception: Column 'engineer' cannot be null in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_project() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:21:57 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' cannot be null [Method: POST, Route: create-project] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:57 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' 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_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:57 --> [Caused by] mysqli_sql_exception: Column 'engineer' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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)) INFO - 2024-10-01 08:21:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:21:57 --> mysqli_sql_exception: Column 'engineer' cannot be null in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `cr...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->create_project() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:21:57 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' cannot be null [Method: POST, Route: create-project] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:57 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'engineer' 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_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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 - 2024-10-01 08:21:57 --> [Caused by] mysqli_sql_exception: Column 'engineer' cannot be null in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (\'4\', \'7\', \'Option1\', \'2\', \'\', NULL, \'2024-10-04\', \'2016-17\', \'2024-10-25\', \'3000\', \'2024-10-17\', \'2000\', \'2024-10-17\', \'Option2\', \'sdsd\', \'vjbj\', \'\', \'2024-10-01 08:21:57\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `Constituency`, `fund_wise`, `sl_no`, `apm`, `engineer`, `date_of_proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `labour_contract`, `remarks`, `mla`, `created_at`, `created_by`) VALUES (:department:, :Constituency:, :fund_wise:, :sl_no:, :apm:, :engineer:, :date_of_proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :labour_contract:, :remarks:, :mla:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Project.php(70): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->create_project() 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)) INFO - 2024-10-01 08:25:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:25:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:26:04 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:26:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:26:18 --> mysqli_sql_exception: Unknown column 'created_by' in 'field list' in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `us...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `us...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `us...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `us...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:26:18 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' in 'field list' [Method: POST, Route: add-roles-creation] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:26:18 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' 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 `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'2b09d7b1\', \'2\', 1, \'2024-10-01 08:26:15\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'2b09d7b1\', \'2\', 1, \'2024-10-01 08:26:15\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:26:18 --> [Caused by] mysqli_sql_exception: Unknown column 'created_by' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'2b09d7b1\', \'2\', 1, \'2024-10-01 08:26:15\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'2b09d7b1\', \'2\', 1, \'2024-10-01 08:26:15\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'2b09d7b1\', \'2\', 1, \'2024-10-01 08:26:15\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:26:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:26:28 --> mysqli_sql_exception: Unknown column 'created_by' in 'field list' in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `us...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `us...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `us...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `us...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:26:28 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' in 'field list' [Method: POST, Route: add-roles-creation] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:26:28 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' 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 `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'0ef5c79e\', \'2\', 1, \'2024-10-01 08:26:25\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'0ef5c79e\', \'2\', 1, \'2024-10-01 08:26:25\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:26:28 --> [Caused by] mysqli_sql_exception: Unknown column 'created_by' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'0ef5c79e\', \'2\', 1, \'2024-10-01 08:26:25\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'0ef5c79e\', \'2\', 1, \'2024-10-01 08:26:25\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'0ef5c79e\', \'2\', 1, \'2024-10-01 08:26:25\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:29:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:31:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:35:48 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:35:51 --> mysqli_sql_exception: Unknown column 'created_by' in 'field list' in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `us...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `us...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `us...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `us...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:35:51 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' in 'field list' [Method: POST, Route: add-roles-creation] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:35:51 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' 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 `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'aa7475a3\', \'2\', 1, \'2024-10-01 08:35:48\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'aa7475a3\', \'2\', 1, \'2024-10-01 08:35:48\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:35:51 --> [Caused by] mysqli_sql_exception: Unknown column 'created_by' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'aa7475a3\', \'2\', 1, \'2024-10-01 08:35:48\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'aa7475a3\', \'2\', 1, \'2024-10-01 08:35:48\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'aa7475a3\', \'2\', 1, \'2024-10-01 08:35:48\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:37:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:37:35 --> mysqli_sql_exception: Unknown column 'created_by' in 'field list' in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `us...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `us...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `us...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `us...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:37:35 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' in 'field list' [Method: POST, Route: add-roles-creation] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:37:35 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' 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 `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'d70ad7d4\', \'2\', 1, \'2024-10-01 08:37:32\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'d70ad7d4\', \'2\', 1, \'2024-10-01 08:37:32\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:37:35 --> [Caused by] mysqli_sql_exception: Unknown column 'created_by' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'d70ad7d4\', \'2\', 1, \'2024-10-01 08:37:32\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'d70ad7d4\', \'2\', 1, \'2024-10-01 08:37:32\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'d70ad7d4\', \'2\', 1, \'2024-10-01 08:37:32\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:38:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:38:59 --> mysqli_sql_exception: Unknown column 'created_by' in 'field list' in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `us...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `us...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `us...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `us...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:38:59 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' in 'field list' [Method: POST, Route: add-roles-creation] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:38:59 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' 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 `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'6bce6d63\', \'2\', 1, \'2024-10-01 08:38:56\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'6bce6d63\', \'2\', 1, \'2024-10-01 08:38:56\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:38:59 --> [Caused by] mysqli_sql_exception: Unknown column 'created_by' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'6bce6d63\', \'2\', 1, \'2024-10-01 08:38:56\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'6bce6d63\', \'2\', 1, \'2024-10-01 08:38:56\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'6bce6d63\', \'2\', 1, \'2024-10-01 08:38:56\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:39:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:40:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:40:31 --> mysqli_sql_exception: Unknown column 'created_by' in 'field list' in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `us...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `us...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `us...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `us...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:40:31 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' in 'field list' [Method: POST, Route: add-roles-creation] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:40:31 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' 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 `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'f516f612\', \'2\', 1, \'2024-10-01 08:40:28\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'f516f612\', \'2\', 1, \'2024-10-01 08:40:28\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:40:31 --> [Caused by] mysqli_sql_exception: Unknown column 'created_by' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'f516f612\', \'2\', 1, \'2024-10-01 08:40:28\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'f516f612\', \'2\', 1, \'2024-10-01 08:40:28\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'f516f612\', \'2\', 1, \'2024-10-01 08:40:28\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:40:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. ERROR - 2024-10-01 08:40:47 --> mysqli_sql_exception: Unknown column 'created_by' in 'field list' in /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `us...', 0) #1 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `us...') #2 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `us...') #3 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `us...', Array, false) #4 /home/injayblues/public_html/nirmithi_kendra/app/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert(Array) #5 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() #6 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) #7 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/injayblues/public_html/nirmithi_kendra/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/injayblues/public_html/nirmithi_kendra/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2024-10-01 08:40:47 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' in 'field list' [Method: POST, Route: add-roles-creation] in SYSTEMPATH/Database/BaseConnection.php on line 688. 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 2 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:40:47 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'created_by' 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 `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'acd5680f\', \'2\', 1, \'2024-10-01 08:40:44\', \'kavya\')') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'acd5680f\', \'2\', 1, \'2024-10-01 08:40:44\', \'kavya\')') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 4 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:40:47 --> [Caused by] mysqli_sql_exception: Unknown column 'created_by' in 'field list' in SYSTEMPATH/Database/MySQLi/Connection.php on line 312. 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'acd5680f\', \'2\', 1, \'2024-10-01 08:40:44\', \'kavya\')', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'acd5680f\', \'2\', 1, \'2024-10-01 08:40:44\', \'kavya\')') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (\'APM1\', \'Kvy547@gmail.com\', \'acd5680f\', \'2\', 1, \'2024-10-01 08:40:44\', \'kavya\')') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `users` (`username`, `email`, `password`, `role`, `valid_user`, `created_at`, `created_by`) VALUES (:username:, :email:, :password:, :role:, :valid_user:, :created_at:, :created_by:)', [...], false) 5 APPPATH/Controllers/Roles.php(129): CodeIgniter\Database\BaseBuilder->insert([...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Roles->add_roles_creation() 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Roles)) 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 - 2024-10-01 08:42:03 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:42:06 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:42:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:42:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2024-10-01 08:42:32 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "project (1).png" [Method: GET, Route: project-edit/public/assets/images/project%20%281%29.png] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('project-edit/public/assets/images/project (1).png') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('project-edit/public/assets/images/project (1).png') 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)) INFO - 2024-10-01 08:42:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:42:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:42:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2024-10-01 08:42:55 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "project (1).png" [Method: GET, Route: project-edit/public/assets/images/project%20%281%29.png] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('project-edit/public/assets/images/project (1).png') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('project-edit/public/assets/images/project (1).png') 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)) INFO - 2024-10-01 08:43:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:43:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:43:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2024-10-01 08:43:18 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "project (1).png" [Method: GET, Route: project-edit/public/assets/images/project%20%281%29.png] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('project-edit/public/assets/images/project (1).png') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('project-edit/public/assets/images/project (1).png') 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)) INFO - 2024-10-01 08:43:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:43:36 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:43:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2024-10-01 08:43:43 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "project (1).png" [Method: GET, Route: project-edit/public/assets/images/project%20%281%29.png] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('project-edit/public/assets/images/project (1).png') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('project-edit/public/assets/images/project (1).png') 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)) INFO - 2024-10-01 08:43:57 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:43:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:44:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:45:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:46:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:50:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:52:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:52:53 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:56:35 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:57:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:57:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:57:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:57:28 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:58:37 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 08:58:47 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2024-10-01 08:58:48 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "project (1).png" [Method: GET, Route: project-edit/public/assets/images/project%20%281%29.png] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('project-edit/public/assets/images/project (1).png') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('project-edit/public/assets/images/project (1).png') 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)) INFO - 2024-10-01 09:00:23 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 09:50:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. CRITICAL - 2024-10-01 09:50:19 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "project (1).png" [Method: GET, Route: project-edit/public/assets/images/project%20%281%29.png] in SYSTEMPATH/Router/Router.php on line 737. 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('project-edit/public/assets/images/project (1).png') 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('project-edit/public/assets/images/project (1).png') 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)) INFO - 2024-10-01 15:47:01 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. INFO - 2024-10-01 22:46:15 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.