EVOLUTION-NINJA
Edit File: log-2025-01-10.log
ERROR - 2025-01-10 14:32:07 --> mysqli_sql_exception: Unknown column 'create_project.supervisor' in 'on clause' in /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:312 Stack trace: #0 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(312): mysqli->query('SELECT `create_...', 0) #1 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_...') #2 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_...') #3 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_...', Array, false) #4 /home/mnknirman/public_html/app/Controllers/Project.php(414): CodeIgniter\Database\BaseBuilder->get() #5 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->project_list_data() #6 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Project)) #7 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #8 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Boot.php(325): CodeIgniter\CodeIgniter->run() #9 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter)) #10 /home/mnknirman/public_html/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths)) #11 {main} CRITICAL - 2025-01-10 14:32:07 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'create_project.supervisor' in 'on clause' [Method: POST, 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`, `apm_user`.`username` AS `apm_first_name`, `apm_user`.`id` AS `apm_user_id`, `engineer_user`.`username` AS `engineer_first_name`, `engineer_user`.`id` AS `engineer_user_id`, `supervisor_user`.`username` AS `supervisor_first_name`, `supervisor_user`.`id` AS `supervisor_user_id`, 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, `status_master`.`status`, `status_master`.`status_name`, `fund_master`.`id` AS `fund_id`, `fund_master`.`fund_name` 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 `users` AS `apm_user` ON `apm_user`.`id` = `create_project`.`apm` LEFT JOIN `users` AS `engineer_user` ON `engineer_user`.`id` = `create_project`.`engineer` LEFT JOIN `users` AS `supervisor_user` ON `supervisor_user`.`id` = `create_project`.`supervisor` 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 `status_master` ON `status_master`.`status` = `create_project`.`status` LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise` 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(414): 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 - 2025-01-10 14:32:07 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'create_project.supervisor' in 'on clause' 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`, `apm_user`.`username` AS `apm_first_name`, `apm_user`.`id` AS `apm_user_id`, `engineer_user`.`username` AS `engineer_first_name`, `engineer_user`.`id` AS `engineer_user_id`, `supervisor_user`.`username` AS `supervisor_first_name`, `supervisor_user`.`id` AS `supervisor_user_id`, 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, `status_master`.`status`, `status_master`.`status_name`, `fund_master`.`id` AS `fund_id`, `fund_master`.`fund_name` 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 `users` AS `apm_user` ON `apm_user`.`id` = `create_project`.`apm` LEFT JOIN `users` AS `engineer_user` ON `engineer_user`.`id` = `create_project`.`engineer` LEFT JOIN `users` AS `supervisor_user` ON `supervisor_user`.`id` = `create_project`.`supervisor` 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 `status_master` ON `status_master`.`status` = `create_project`.`status` LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise` 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`, `apm_user`.`username` AS `apm_first_name`, `apm_user`.`id` AS `apm_user_id`, `engineer_user`.`username` AS `engineer_first_name`, `engineer_user`.`id` AS `engineer_user_id`, `supervisor_user`.`username` AS `supervisor_first_name`, `supervisor_user`.`id` AS `supervisor_user_id`, 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, `status_master`.`status`, `status_master`.`status_name`, `fund_master`.`id` AS `fund_id`, `fund_master`.`fund_name` 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 `users` AS `apm_user` ON `apm_user`.`id` = `create_project`.`apm` LEFT JOIN `users` AS `engineer_user` ON `engineer_user`.`id` = `create_project`.`engineer` LEFT JOIN `users` AS `supervisor_user` ON `supervisor_user`.`id` = `create_project`.`supervisor` 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 `status_master` ON `status_master`.`status` = `create_project`.`status` LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise` 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`, `apm_user`.`username` AS `apm_first_name`, `apm_user`.`id` AS `apm_user_id`, `engineer_user`.`username` AS `engineer_first_name`, `engineer_user`.`id` AS `engineer_user_id`, `supervisor_user`.`username` AS `supervisor_first_name`, `supervisor_user`.`id` AS `supervisor_user_id`, 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, `status_master`.`status`, `status_master`.`status_name`, `fund_master`.`id` AS `fund_id`, `fund_master`.`fund_name` 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 `users` AS `apm_user` ON `apm_user`.`id` = `create_project`.`apm` LEFT JOIN `users` AS `engineer_user` ON `engineer_user`.`id` = `create_project`.`engineer` LEFT JOIN `users` AS `supervisor_user` ON `supervisor_user`.`id` = `create_project`.`supervisor` 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 `status_master` ON `status_master`.`status` = `create_project`.`status` LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise` 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(414): 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 - 2025-01-10 14:32:07 --> [Caused by] mysqli_sql_exception: Unknown column 'create_project.supervisor' in 'on clause' 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`, `apm_user`.`username` AS `apm_first_name`, `apm_user`.`id` AS `apm_user_id`, `engineer_user`.`username` AS `engineer_first_name`, `engineer_user`.`id` AS `engineer_user_id`, `supervisor_user`.`username` AS `supervisor_first_name`, `supervisor_user`.`id` AS `supervisor_user_id`, 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, `status_master`.`status`, `status_master`.`status_name`, `fund_master`.`id` AS `fund_id`, `fund_master`.`fund_name` 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 `users` AS `apm_user` ON `apm_user`.`id` = `create_project`.`apm` LEFT JOIN `users` AS `engineer_user` ON `engineer_user`.`id` = `create_project`.`engineer` LEFT JOIN `users` AS `supervisor_user` ON `supervisor_user`.`id` = `create_project`.`supervisor` 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 `status_master` ON `status_master`.`status` = `create_project`.`status` LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise` 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`, `apm_user`.`username` AS `apm_first_name`, `apm_user`.`id` AS `apm_user_id`, `engineer_user`.`username` AS `engineer_first_name`, `engineer_user`.`id` AS `engineer_user_id`, `supervisor_user`.`username` AS `supervisor_first_name`, `supervisor_user`.`id` AS `supervisor_user_id`, 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, `status_master`.`status`, `status_master`.`status_name`, `fund_master`.`id` AS `fund_id`, `fund_master`.`fund_name` 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 `users` AS `apm_user` ON `apm_user`.`id` = `create_project`.`apm` LEFT JOIN `users` AS `engineer_user` ON `engineer_user`.`id` = `create_project`.`engineer` LEFT JOIN `users` AS `supervisor_user` ON `supervisor_user`.`id` = `create_project`.`supervisor` 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 `status_master` ON `status_master`.`status` = `create_project`.`status` LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise` 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`, `apm_user`.`username` AS `apm_first_name`, `apm_user`.`id` AS `apm_user_id`, `engineer_user`.`username` AS `engineer_first_name`, `engineer_user`.`id` AS `engineer_user_id`, `supervisor_user`.`username` AS `supervisor_first_name`, `supervisor_user`.`id` AS `supervisor_user_id`, 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, `status_master`.`status`, `status_master`.`status_name`, `fund_master`.`id` AS `fund_id`, `fund_master`.`fund_name` 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 `users` AS `apm_user` ON `apm_user`.`id` = `create_project`.`apm` LEFT JOIN `users` AS `engineer_user` ON `engineer_user`.`id` = `create_project`.`engineer` LEFT JOIN `users` AS `supervisor_user` ON `supervisor_user`.`id` = `create_project`.`supervisor` 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 `status_master` ON `status_master`.`status` = `create_project`.`status` LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise` 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`, `apm_user`.`username` AS `apm_first_name`, `apm_user`.`id` AS `apm_user_id`, `engineer_user`.`username` AS `engineer_first_name`, `engineer_user`.`id` AS `engineer_user_id`, `supervisor_user`.`username` AS `supervisor_first_name`, `supervisor_user`.`id` AS `supervisor_user_id`, 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, `status_master`.`status`, `status_master`.`status_name`, `fund_master`.`id` AS `fund_id`, `fund_master`.`fund_name` 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 `users` AS `apm_user` ON `apm_user`.`id` = `create_project`.`apm` LEFT JOIN `users` AS `engineer_user` ON `engineer_user`.`id` = `create_project`.`engineer` LEFT JOIN `users` AS `supervisor_user` ON `supervisor_user`.`id` = `create_project`.`supervisor` 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 `status_master` ON `status_master`.`status` = `create_project`.`status` LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise` 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(414): 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)) CRITICAL - 2025-01-10 15:47:56 --> Exception: Failed to parse time string (2018. -11- 02) at position 9 (-): Unexpected character [Method: GET, Route: project-payment-edit/14] in APPPATH/Views/createproject/project_payment_edit.php on line 364. 1 APPPATH/Views/createproject/project_payment_edit.php(364): DateTime->__construct('2018. -11- 02') 2 SYSTEMPATH/View/View.php(234): include('/home/mnknirman/public_html/app/Views/createproject/project_payment_edit.php') 3 SYSTEMPATH/View/View.php(237): CodeIgniter\View\View->CodeIgniter\View\{closure}() 4 SYSTEMPATH/Common.php(1171): CodeIgniter\View\View->render('createproject/project_payment_edit', [], true) 5 APPPATH/Controllers/Project.php(949): view('createproject/project_payment_edit', [...]) 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_payment_edit('14') 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))