EVOLUTION-NINJA

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

ERROR - 2025-11-26 12:08:20 --> mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_cash
                     FROM expenditure_new 
                     GROUP BY' at line 23 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(1651): CodeIgniter\Database\BaseBuilder->get()
#5 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->project_list_data_cash()
#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-11-26 12:08:20 --> CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_cash
                     FROM expenditure_new 
                     GROUP BY' at line 23
[Method: POST, Route: project-list-data-cash]
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`, `mla_table`.`mla` AS `mla_name`, `mp_table`.`MP` AS `mp_name`, `mlc_table`.`MLC` AS `mlc_name`, `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, GROUP_CONCAT(DISTINCT progress_documents.document_name SEPARATOR ", ") AS progress_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(cash.total_expenditure_cash, 0) AS total_expenditure_cash, `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` AS `mla_table` ON `mla_table`.`id` = `create_project`.`mla`
LEFT JOIN `constituency_master` AS `mp_table` ON `mp_table`.`id` = `create_project`.`MP`
LEFT JOIN `constituency_master` AS `mlc_table` ON `mlc_table`.`id` = `create_project`.`MLC`
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 `progress_documents` ON `progress_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`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure _cash
                     FROM expenditure_new 
                     GROUP BY project_id) AS cash ON `cash`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY `create_project`.`id` DESC', [], false)
 2 APPPATH/Controllers/Project.php(1651): CodeIgniter\Database\BaseBuilder->get()
 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data_cash()
 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-11-26 12:08:20 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_cash
                     FROM expenditure_new 
                     GROUP BY' at line 23
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`, `mla_table`.`mla` AS `mla_name`, `mp_table`.`MP` AS `mp_name`, `mlc_table`.`MLC` AS `mlc_name`, `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, GROUP_CONCAT(DISTINCT progress_documents.document_name SEPARATOR ", ") AS progress_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(cash.total_expenditure_cash, 0) AS total_expenditure_cash, `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` AS `mla_table` ON `mla_table`.`id` = `create_project`.`mla`
LEFT JOIN `constituency_master` AS `mp_table` ON `mp_table`.`id` = `create_project`.`MP`
LEFT JOIN `constituency_master` AS `mlc_table` ON `mlc_table`.`id` = `create_project`.`MLC`
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 `progress_documents` ON `progress_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`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure _cash
                     FROM expenditure_new 
                     GROUP BY project_id) AS cash ON `cash`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY `create_project`.`id` DESC')
 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `mla_table`.`mla` AS `mla_name`, `mp_table`.`MP` AS `mp_name`, `mlc_table`.`MLC` AS `mlc_name`, `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, GROUP_CONCAT(DISTINCT progress_documents.document_name SEPARATOR ", ") AS progress_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(cash.total_expenditure_cash, 0) AS total_expenditure_cash, `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` AS `mla_table` ON `mla_table`.`id` = `create_project`.`mla`
LEFT JOIN `constituency_master` AS `mp_table` ON `mp_table`.`id` = `create_project`.`MP`
LEFT JOIN `constituency_master` AS `mlc_table` ON `mlc_table`.`id` = `create_project`.`MLC`
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 `progress_documents` ON `progress_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`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure _cash
                     FROM expenditure_new 
                     GROUP BY project_id) AS cash ON `cash`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY `create_project`.`id` DESC')
 3 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `mla_table`.`mla` AS `mla_name`, `mp_table`.`MP` AS `mp_name`, `mlc_table`.`MLC` AS `mlc_name`, `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, GROUP_CONCAT(DISTINCT progress_documents.document_name SEPARATOR ", ") AS progress_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(cash.total_expenditure_cash, 0) AS total_expenditure_cash, `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` AS `mla_table` ON `mla_table`.`id` = `create_project`.`mla`
LEFT JOIN `constituency_master` AS `mp_table` ON `mp_table`.`id` = `create_project`.`MP`
LEFT JOIN `constituency_master` AS `mlc_table` ON `mlc_table`.`id` = `create_project`.`MLC`
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 `progress_documents` ON `progress_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`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure _cash
                     FROM expenditure_new 
                     GROUP BY project_id) AS cash ON `cash`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY `create_project`.`id` DESC', [], false)
 4 APPPATH/Controllers/Project.php(1651): CodeIgniter\Database\BaseBuilder->get()
 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data_cash()
 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-11-26 12:08:20 --> [Caused by] mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_cash
                     FROM expenditure_new 
                     GROUP BY' at line 23
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`, `mla_table`.`mla` AS `mla_name`, `mp_table`.`MP` AS `mp_name`, `mlc_table`.`MLC` AS `mlc_name`, `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, GROUP_CONCAT(DISTINCT progress_documents.document_name SEPARATOR ", ") AS progress_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(cash.total_expenditure_cash, 0) AS total_expenditure_cash, `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` AS `mla_table` ON `mla_table`.`id` = `create_project`.`mla`
LEFT JOIN `constituency_master` AS `mp_table` ON `mp_table`.`id` = `create_project`.`MP`
LEFT JOIN `constituency_master` AS `mlc_table` ON `mlc_table`.`id` = `create_project`.`MLC`
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 `progress_documents` ON `progress_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`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure _cash
                     FROM expenditure_new 
                     GROUP BY project_id) AS cash ON `cash`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY `create_project`.`id` DESC', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `mla_table`.`mla` AS `mla_name`, `mp_table`.`MP` AS `mp_name`, `mlc_table`.`MLC` AS `mlc_name`, `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, GROUP_CONCAT(DISTINCT progress_documents.document_name SEPARATOR ", ") AS progress_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(cash.total_expenditure_cash, 0) AS total_expenditure_cash, `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` AS `mla_table` ON `mla_table`.`id` = `create_project`.`mla`
LEFT JOIN `constituency_master` AS `mp_table` ON `mp_table`.`id` = `create_project`.`MP`
LEFT JOIN `constituency_master` AS `mlc_table` ON `mlc_table`.`id` = `create_project`.`MLC`
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 `progress_documents` ON `progress_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`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure _cash
                     FROM expenditure_new 
                     GROUP BY project_id) AS cash ON `cash`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY `create_project`.`id` DESC')
 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `mla_table`.`mla` AS `mla_name`, `mp_table`.`MP` AS `mp_name`, `mlc_table`.`MLC` AS `mlc_name`, `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, GROUP_CONCAT(DISTINCT progress_documents.document_name SEPARATOR ", ") AS progress_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(cash.total_expenditure_cash, 0) AS total_expenditure_cash, `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` AS `mla_table` ON `mla_table`.`id` = `create_project`.`mla`
LEFT JOIN `constituency_master` AS `mp_table` ON `mp_table`.`id` = `create_project`.`MP`
LEFT JOIN `constituency_master` AS `mlc_table` ON `mlc_table`.`id` = `create_project`.`MLC`
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 `progress_documents` ON `progress_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`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure _cash
                     FROM expenditure_new 
                     GROUP BY project_id) AS cash ON `cash`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY `create_project`.`id` DESC')
 4 SYSTEMPATH/Database/BaseBuilder.php(1644): CodeIgniter\Database\BaseConnection->query('SELECT `create_project`.*, `department`.`department_name`, `constituency`.`constituency_name`, `mla_table`.`mla` AS `mla_name`, `mp_table`.`MP` AS `mp_name`, `mlc_table`.`MLC` AS `mlc_name`, `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, GROUP_CONCAT(DISTINCT progress_documents.document_name SEPARATOR ", ") AS progress_document_names, COALESCE(total_released.total_released_amount, 0) AS total_released_amount, COALESCE(total_expenditure.total_expenditure, 0) AS total_expenditure, COALESCE(cash.total_expenditure_cash, 0) AS total_expenditure_cash, `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` AS `mla_table` ON `mla_table`.`id` = `create_project`.`mla`
LEFT JOIN `constituency_master` AS `mp_table` ON `mp_table`.`id` = `create_project`.`MP`
LEFT JOIN `constituency_master` AS `mlc_table` ON `mlc_table`.`id` = `create_project`.`MLC`
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 `progress_documents` ON `progress_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`
LEFT JOIN (SELECT project_id, SUM(expenditure_amount) AS total_expenditure _cash
                     FROM expenditure_new 
                     GROUP BY project_id) AS cash ON `cash`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY `create_project`.`id` DESC', [], false)
 5 APPPATH/Controllers/Project.php(1651): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_list_data_cash()
 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-11-26 12:58:01 --> Exception: Failed to parse time string (2025-02- 11) at position 7 (-): Unexpected character
[Method: GET, Route: project-edit/1844]
in APPPATH/Views/createproject/project_edit.php on line 676.
 1 APPPATH/Views/createproject/project_edit.php(676): DateTime->__construct('2025-02- 11')
 2 SYSTEMPATH/View/View.php(234): include('/home/mnknirman/public_html/app/Views/createproject/project_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_edit', [], true)
 5 APPPATH/Controllers/Project.php(763): view('createproject/project_edit', [...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_edit('1844')
 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))
ERROR - 2025-11-26 13:25:01 --> mysqli_sql_exception: Column 'remarks' cannot be null 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('INSERT INTO `pr...', 0)
#1 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pr...')
#2 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pr...')
#3 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pr...', Array, false)
#4 /home/mnknirman/public_html/app/Controllers/Project.php(986): CodeIgniter\Database\BaseBuilder->insert(Array)
#5 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Project->update_project('1892')
#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-11-26 13:25:01 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'remarks' cannot be null
[Method: POST, Route: project-update/1892]
in SYSTEMPATH/Database/BaseConnection.php on line 688.
 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `progress_documents` (`project_id`, `document_name`, `created_at`, `created_by`, `remarks`) VALUES (:project_id:, :document_name:, :created_at:, :created_by:, :remarks:)', [...], false)
 2 APPPATH/Controllers/Project.php(986): CodeIgniter\Database\BaseBuilder->insert([...])
 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->update_project('1892')
 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-11-26 13:25:01 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'remarks' 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 `progress_documents` (`project_id`, `document_name`, `created_at`, `created_by`, `remarks`) VALUES (\'1892\', \'WhatsApp_Image_2025-11-26_at_13.22.34_89f64633.jpg\', (\'2025-08-13\'), \'AssistantEngineer2\', NULL)')
 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `progress_documents` (`project_id`, `document_name`, `created_at`, `created_by`, `remarks`) VALUES (\'1892\', \'WhatsApp_Image_2025-11-26_at_13.22.34_89f64633.jpg\', (\'2025-08-13\'), \'AssistantEngineer2\', NULL)')
 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `progress_documents` (`project_id`, `document_name`, `created_at`, `created_by`, `remarks`) VALUES (:project_id:, :document_name:, :created_at:, :created_by:, :remarks:)', [...], false)
 4 APPPATH/Controllers/Project.php(986): CodeIgniter\Database\BaseBuilder->insert([...])
 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->update_project('1892')
 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-11-26 13:25:01 --> [Caused by] mysqli_sql_exception: Column 'remarks' cannot be null
in SYSTEMPATH/Database/MySQLi/Connection.php on line 312.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(312): mysqli->query('INSERT INTO `progress_documents` (`project_id`, `document_name`, `created_at`, `created_by`, `remarks`) VALUES (\'1892\', \'WhatsApp_Image_2025-11-26_at_13.22.34_89f64633.jpg\', (\'2025-08-13\'), \'AssistantEngineer2\', NULL)', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `progress_documents` (`project_id`, `document_name`, `created_at`, `created_by`, `remarks`) VALUES (\'1892\', \'WhatsApp_Image_2025-11-26_at_13.22.34_89f64633.jpg\', (\'2025-08-13\'), \'AssistantEngineer2\', NULL)')
 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `progress_documents` (`project_id`, `document_name`, `created_at`, `created_by`, `remarks`) VALUES (\'1892\', \'WhatsApp_Image_2025-11-26_at_13.22.34_89f64633.jpg\', (\'2025-08-13\'), \'AssistantEngineer2\', NULL)')
 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `progress_documents` (`project_id`, `document_name`, `created_at`, `created_by`, `remarks`) VALUES (:project_id:, :document_name:, :created_at:, :created_by:, :remarks:)', [...], false)
 5 APPPATH/Controllers/Project.php(986): CodeIgniter\Database\BaseBuilder->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->update_project('1892')
 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-11-26 13:39:36 --> Exception: Failed to parse time string (2025-02- 11) at position 7 (-): Unexpected character
[Method: GET, Route: project-edit/1844]
in APPPATH/Views/createproject/project_edit.php on line 676.
 1 APPPATH/Views/createproject/project_edit.php(676): DateTime->__construct('2025-02- 11')
 2 SYSTEMPATH/View/View.php(234): include('/home/mnknirman/public_html/app/Views/createproject/project_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_edit', [], true)
 5 APPPATH/Controllers/Project.php(763): view('createproject/project_edit', [...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_edit('1844')
 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-11-26 13:39:53 --> Exception: Failed to parse time string (2025-02- 11) at position 7 (-): Unexpected character
[Method: GET, Route: project-edit/1844]
in APPPATH/Views/createproject/project_edit.php on line 676.
 1 APPPATH/Views/createproject/project_edit.php(676): DateTime->__construct('2025-02- 11')
 2 SYSTEMPATH/View/View.php(234): include('/home/mnknirman/public_html/app/Views/createproject/project_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_edit', [], true)
 5 APPPATH/Controllers/Project.php(763): view('createproject/project_edit', [...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Project->project_edit('1844')
 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))