EVOLUTION-NINJA

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

ERROR - 2025-01-09 05:36:38 --> mysqli_sql_exception: Table 'mnknirman_kendra.create_project' doesn't exist 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/Report.php(467): CodeIgniter\Database\BaseBuilder->get()
#5 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Report->get_report()
#6 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report))
#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-09 05:36:38 --> CodeIgniter\Database\Exceptions\DatabaseException: Table 'mnknirman_kendra.create_project' doesn't exist
[Method: POST, Route: get_report]
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`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_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, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
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 `status_master` ON `status_master`.`status` = `create_project`.`status`
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`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                     FROM released_amounts 
                     WHERE YEAR(released_date) = 2024-04-01 
                     GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2024-04-01\' AND \'2025-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC', [], false)
 2 APPPATH/Controllers/Report.php(467): CodeIgniter\Database\BaseBuilder->get()
 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_report()
 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report))
 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-09 05:36:38 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Table 'mnknirman_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`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_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, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
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 `status_master` ON `status_master`.`status` = `create_project`.`status`
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`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                     FROM released_amounts 
                     WHERE YEAR(released_date) = 2024-04-01 
                     GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2024-04-01\' AND \'2025-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC')
 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`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_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, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
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 `status_master` ON `status_master`.`status` = `create_project`.`status`
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`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                     FROM released_amounts 
                     WHERE YEAR(released_date) = 2024-04-01 
                     GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2024-04-01\' AND \'2025-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC')
 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`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_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, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
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 `status_master` ON `status_master`.`status` = `create_project`.`status`
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`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                     FROM released_amounts 
                     WHERE YEAR(released_date) = 2024-04-01 
                     GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2024-04-01\' AND \'2025-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC', [], false)
 4 APPPATH/Controllers/Report.php(467): CodeIgniter\Database\BaseBuilder->get()
 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_report()
 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report))
 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-09 05:36:38 --> [Caused by] mysqli_sql_exception: Table 'mnknirman_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`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_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, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
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 `status_master` ON `status_master`.`status` = `create_project`.`status`
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`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                     FROM released_amounts 
                     WHERE YEAR(released_date) = 2024-04-01 
                     GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2024-04-01\' AND \'2025-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC', 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`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_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, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
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 `status_master` ON `status_master`.`status` = `create_project`.`status`
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`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                     FROM released_amounts 
                     WHERE YEAR(released_date) = 2024-04-01 
                     GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2024-04-01\' AND \'2025-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC')
 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`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_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, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
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 `status_master` ON `status_master`.`status` = `create_project`.`status`
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`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                     FROM released_amounts 
                     WHERE YEAR(released_date) = 2024-04-01 
                     GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2024-04-01\' AND \'2025-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC')
 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`, `fund_master`.`fund_name` AS `fund_name`, `roles_creation_engineer`.`first_name` AS `engineer_first_name`, `status_master`.`status` AS `status`, `status_master`.`status_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, COALESCE(previous_year_released.previous_year_released, 0) AS previous_year_released, COALESCE(present_year_released.present_year_released, 0) AS present_year_released, COALESCE(last_released.last_released_amount, 0) AS last_released_amount, COALESCE(last_released.last_released_date, NULL) AS last_released_date
FROM `create_project`
LEFT JOIN `department` ON `department`.`id` = `create_project`.`department`
LEFT JOIN `fund_master` ON `fund_master`.`id` = `create_project`.`fund_wise`
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 `status_master` ON `status_master`.`status` = `create_project`.`status`
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`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS previous_year_released 
                     FROM released_amounts 
                     WHERE YEAR(released_date) = 2024-04-01 
                     GROUP BY project_id) AS previous_year_released ON `previous_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, SUM(released_amount) AS present_year_released 
                     FROM released_amounts 
                     WHERE released_date BETWEEN \'2024-04-01\' AND \'2025-03-31\'
                     GROUP BY project_id) AS present_year_released ON `present_year_released`.`project_id` = `create_project`.`id`
LEFT JOIN (SELECT project_id, 
                            released_amount AS last_released_amount, 
                            released_date AS last_released_date 
                     FROM released_amounts 
                     WHERE (project_id, released_date) IN 
                           (SELECT project_id, MAX(released_date) 
                            FROM released_amounts 
                            GROUP BY project_id)
                    ) AS last_released ON `last_released`.`project_id` = `create_project`.`id`
GROUP BY `create_project`.`id`
ORDER BY (department.preference = 0) ASC, `department`.`preference` ASC', [], false)
 5 APPPATH/Controllers/Report.php(467): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Report->get_report()
 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Report))
 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-09 11:46:09 --> ErrorException: Allowed memory size of 134217728 bytes exhausted (tried to allocate 528384 bytes)
[Method: POST, Route: Excel/import]
in FCPATH/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php on line 2949.
 1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
CRITICAL - 2025-01-09 11:46:53 --> ErrorException: Allowed memory size of 134217728 bytes exhausted (tried to allocate 528384 bytes)
[Method: POST, Route: Excel/import]
in FCPATH/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php on line 2949.
 1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
CRITICAL - 2025-01-09 12:05:04 --> ErrorException: Allowed memory size of 134217728 bytes exhausted (tried to allocate 528384 bytes)
[Method: POST, Route: Excel/import]
in FCPATH/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php on line 2949.
 1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
CRITICAL - 2025-01-09 12:08:22 --> ErrorException: Allowed memory size of 536870912 bytes exhausted (tried to allocate 528384 bytes)
[Method: POST, Route: Excel/import]
in FCPATH/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php on line 2949.
 1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
CRITICAL - 2025-01-09 12:27:15 --> Error: Call to undefined method App\Controllers\Excel::getStatusValue()
[Method: POST, Route: Excel/import]
in APPPATH/Controllers/Excel.php on line 49.
 1 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 2 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 3 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 4 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 5 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 6 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
CRITICAL - 2025-01-09 12:27:19 --> Error: Call to undefined method App\Controllers\Excel::getStatusValue()
[Method: POST, Route: Excel/import]
in APPPATH/Controllers/Excel.php on line 49.
 1 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 2 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 3 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 4 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 5 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 6 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
CRITICAL - 2025-01-09 12:41:42 --> TypeError: max(): Argument #1 ($value) must be of type array, string given
[Method: POST, Route: Excel/import]
in APPPATH/Controllers/Excel.php on line 54.
 1 APPPATH/Controllers/Excel.php(54): max('')
 2 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 3 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
ERROR - 2025-01-09 15:08:28 --> mysqli_sql_exception: Column 'project_name' 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 `cr...', 0)
#1 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...')
#2 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...')
#3 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false)
#4 /home/mnknirman/public_html/app/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert(Array)
#5 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Excel->import()
#6 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
#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-09 15:08:28 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'project_name' cannot be null
[Method: POST, Route: Excel/import]
in SYSTEMPATH/Database/BaseConnection.php on line 688.
 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (:department:, :project_name:, :adm_date:, :sl_no:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :APM:, :engineer:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :remarks:)', [...], false)
 2 APPPATH/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert([...])
 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 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-09 15:08:28 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'project_name' 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`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (NULL, NULL, \'3\', \'ಸರಗೂರು ಗ್ರಾಮದಲ್ಲಿ ಸಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ ಮುಂದುವರೆದ ಕಾಮಗಾರಿ\', \'AiÉÆÃ¸ÀC/VGAiÉÆÃ(3)/¹Dgï-4/2017-18 ¢: 21/03/2023\', \'1\', \'12.00\', \'27\', NULL, NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, \'0\', \'1\')')
 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (NULL, NULL, \'3\', \'ಸರಗೂರು ಗ್ರಾಮದಲ್ಲಿ ಸಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ ಮುಂದುವರೆದ ಕಾಮಗಾರಿ\', \'AiÉÆÃ¸ÀC/VGAiÉÆÃ(3)/¹Dgï-4/2017-18 ¢: 21/03/2023\', \'1\', \'12.00\', \'27\', NULL, NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, \'0\', \'1\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (:department:, :project_name:, :adm_date:, :sl_no:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :APM:, :engineer:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :remarks:)', [...], false)
 4 APPPATH/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert([...])
 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 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-09 15:08:28 --> [Caused by] mysqli_sql_exception: Column 'project_name' 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`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (NULL, NULL, \'3\', \'ಸರಗೂರು ಗ್ರಾಮದಲ್ಲಿ ಸಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ ಮುಂದುವರೆದ ಕಾಮಗಾರಿ\', \'AiÉÆÃ¸ÀC/VGAiÉÆÃ(3)/¹Dgï-4/2017-18 ¢: 21/03/2023\', \'1\', \'12.00\', \'27\', NULL, NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, \'0\', \'1\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (NULL, NULL, \'3\', \'ಸರಗೂರು ಗ್ರಾಮದಲ್ಲಿ ಸಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ ಮುಂದುವರೆದ ಕಾಮಗಾರಿ\', \'AiÉÆÃ¸ÀC/VGAiÉÆÃ(3)/¹Dgï-4/2017-18 ¢: 21/03/2023\', \'1\', \'12.00\', \'27\', NULL, NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, \'0\', \'1\')')
 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (NULL, NULL, \'3\', \'ಸರಗೂರು ಗ್ರಾಮದಲ್ಲಿ ಸಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ ಮುಂದುವರೆದ ಕಾಮಗಾರಿ\', \'AiÉÆÃ¸ÀC/VGAiÉÆÃ(3)/¹Dgï-4/2017-18 ¢: 21/03/2023\', \'1\', \'12.00\', \'27\', NULL, NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, \'0\', \'1\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (:department:, :project_name:, :adm_date:, :sl_no:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :APM:, :engineer:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :remarks:)', [...], false)
 5 APPPATH/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 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-01-09 15:12:34 --> mysqli_sql_exception: Column 'adm_date' 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 `cr...', 0)
#1 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...')
#2 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...')
#3 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false)
#4 /home/mnknirman/public_html/app/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert(Array)
#5 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Excel->import()
#6 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
#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-09 15:12:34 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'adm_date' cannot be null
[Method: POST, Route: Excel/import]
in SYSTEMPATH/Database/BaseConnection.php on line 688.
 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (:department:, :project_name:, :adm_date:, :sl_no:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :APM:, :engineer:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :remarks:)', [...], false)
 2 APPPATH/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert([...])
 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 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-09 15:12:34 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'adm_date' 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`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')')
 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (:department:, :project_name:, :adm_date:, :sl_no:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :APM:, :engineer:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :remarks:)', [...], false)
 4 APPPATH/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert([...])
 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 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-09 15:12:34 --> [Caused by] mysqli_sql_exception: Column 'adm_date' 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`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')')
 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (:department:, :project_name:, :adm_date:, :sl_no:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :APM:, :engineer:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :remarks:)', [...], false)
 5 APPPATH/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 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-01-09 15:12:59 --> mysqli_sql_exception: Column 'adm_date' 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 `cr...', 0)
#1 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `cr...')
#2 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `cr...')
#3 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `cr...', Array, false)
#4 /home/mnknirman/public_html/app/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert(Array)
#5 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Excel->import()
#6 /home/mnknirman/public_html/vendor/codeigniter4/framework/system/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
#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-09 15:12:59 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'adm_date' cannot be null
[Method: POST, Route: Excel/import]
in SYSTEMPATH/Database/BaseConnection.php on line 688.
 1 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (:department:, :project_name:, :adm_date:, :sl_no:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :APM:, :engineer:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :remarks:)', [...], false)
 2 APPPATH/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert([...])
 3 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 4 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 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-09 15:12:59 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'adm_date' 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`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')')
 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (:department:, :project_name:, :adm_date:, :sl_no:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :APM:, :engineer:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :remarks:)', [...], false)
 4 APPPATH/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert([...])
 5 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 6 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 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-09 15:12:59 --> [Caused by] mysqli_sql_exception: Column 'adm_date' 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`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')')
 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (\'3\', \'ಮೇದಿನಿ (ಹೊಸತಿರುಮಕೂಡಲು ಬದಲಾಗಿ)  ಗ್ರಾಮದಲ್ಲಿ ಸÀಮುದಾಯ ಭವನ ನಿರ್ಮಾಣ\', NULL, \'1\', \'12.00\', \'8\', \'7\', NULL, \'76\', \'86\', NULL, \'2023-24\', NULL, NULL, NULL, NULL, NULL, \'1\', \'ಮೇಲ್ಛಾವಣಿ ಮುಗಿದಿದೆ, ಬಾಕಿ ಹಣ ಬಿಡುಗಡೆಗೆ ಯುಸಿ ಸಲ್ಲಿಸಲಾಗಿದೆ\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `adm_date`, `sl_no`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `APM`, `engineer`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `status`, `remarks`) VALUES (:department:, :project_name:, :adm_date:, :sl_no:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :APM:, :engineer:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :status:, :remarks:)', [...], false)
 5 APPPATH/Controllers/Excel.php(75): CodeIgniter\Database\BaseBuilder->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\Excel->import()
 7 SYSTEMPATH/CodeIgniter.php(509): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Excel))
 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-09 19:12:19 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "®.php"
[Method: GET, Route: modules/mod_simplefileuploadv1.3/elements/%C2%AE.php]
in SYSTEMPATH/Router/Router.php on line 737.
 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('modules/mod_simplefileuploadv1.3/elements/®.php')
 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('modules/mod_simplefileuploadv1.3/elements/®.php')
 3 SYSTEMPATH/CodeIgniter.php(457): CodeIgniter\CodeIgniter->tryToRouteIt(Object(CodeIgniter\Router\RouteCollection))
 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
CRITICAL - 2025-01-09 19:12:20 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "®.php7"
[Method: GET, Route: modules/mod_simplefileuploadv1.3/elements/%C2%AE.php7]
in SYSTEMPATH/Router/Router.php on line 737.
 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('modules/mod_simplefileuploadv1.3/elements/®.php7')
 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('modules/mod_simplefileuploadv1.3/elements/®.php7')
 3 SYSTEMPATH/CodeIgniter.php(457): CodeIgniter\CodeIgniter->tryToRouteIt(Object(CodeIgniter\Router\RouteCollection))
 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
CRITICAL - 2025-01-09 19:12:22 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "®.php7"
[Method: GET, Route: modules/mod_simplefileuploadv1.3/elements/%C2%AE.php7]
in SYSTEMPATH/Router/Router.php on line 737.
 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('modules/mod_simplefileuploadv1.3/elements/®.php7')
 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('modules/mod_simplefileuploadv1.3/elements/®.php7')
 3 SYSTEMPATH/CodeIgniter.php(457): CodeIgniter\CodeIgniter->tryToRouteIt(Object(CodeIgniter\Router\RouteCollection))
 4 SYSTEMPATH/CodeIgniter.php(355): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 SYSTEMPATH/Boot.php(325): CodeIgniter\CodeIgniter->run()
 6 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
 7 FCPATH/index.php(56): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
CRITICAL - 2025-01-09 19:12:25 --> CodeIgniter\HTTP\Exceptions\BadRequestException: The URI you submitted has disallowed characters: "®.php"
[Method: GET, Route: wp-content/themes/alera/%C2%AE.php]
in SYSTEMPATH/Router/Router.php on line 737.
 1 SYSTEMPATH/Router/Router.php(204): CodeIgniter\Router\Router->checkDisallowedChars('wp-content/themes/alera/®.php')
 2 SYSTEMPATH/CodeIgniter.php(834): CodeIgniter\Router\Router->handle('wp-content/themes/alera/®.php')
 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))