EVOLUTION-NINJA

Edit File: log-2024-12-19.log

ERROR - 2024-12-19 05:31:52 --> 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(79): 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 - 2024-12-19 05:31:52 --> 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`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `sl_no`, `APM`, `engineer`, `supervisor`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `adm_date`, `status`, `labour_contract`, `remarks`) VALUES (:department:, :project_name:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :sl_no:, :APM:, :engineer:, :supervisor:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :adm_date:, :status:, :labour_contract:, :remarks:)', [...], false) 2 APPPATH/Controllers/Excel.php(79): 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 - 2024-12-19 05:31:52 --> [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`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `sl_no`, `APM`, `engineer`, `supervisor`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `adm_date`, `status`, `labour_contract`, `remarks`) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)') 2 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `project_name`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `sl_no`, `APM`, `engineer`, `supervisor`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `adm_date`, `status`, `labour_contract`, `remarks`) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)') 3 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `sl_no`, `APM`, `engineer`, `supervisor`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `adm_date`, `status`, `labour_contract`, `remarks`) VALUES (:department:, :project_name:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :sl_no:, :APM:, :engineer:, :supervisor:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :adm_date:, :status:, :labour_contract:, :remarks:)', [...], false) 4 APPPATH/Controllers/Excel.php(79): 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 - 2024-12-19 05:31:52 --> [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`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `sl_no`, `APM`, `engineer`, `supervisor`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `adm_date`, `status`, `labour_contract`, `remarks`) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)', 0) 2 SYSTEMPATH/Database/BaseConnection.php(734): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `create_project` (`department`, `project_name`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `sl_no`, `APM`, `engineer`, `supervisor`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `adm_date`, `status`, `labour_contract`, `remarks`) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)') 3 SYSTEMPATH/Database/BaseConnection.php(648): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `create_project` (`department`, `project_name`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `sl_no`, `APM`, `engineer`, `supervisor`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `adm_date`, `status`, `labour_contract`, `remarks`) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)') 4 SYSTEMPATH/Database/BaseBuilder.php(2340): CodeIgniter\Database\BaseConnection->query('INSERT INTO `create_project` (`department`, `project_name`, `Total_amount`, `Constituency`, `mla`, `fund_wise`, `sl_no`, `APM`, `engineer`, `supervisor`, `date_of_Proposal`, `financial_year`, `est_sub_date`, `estimated_cost`, `date_of_approval`, `adm_amount`, `start_date`, `adm_date`, `status`, `labour_contract`, `remarks`) VALUES (:department:, :project_name:, :Total_amount:, :Constituency:, :mla:, :fund_wise:, :sl_no:, :APM:, :engineer:, :supervisor:, :date_of_Proposal:, :financial_year:, :est_sub_date:, :estimated_cost:, :date_of_approval:, :adm_amount:, :start_date:, :adm_date:, :status:, :labour_contract:, :remarks:)', [...], false) 5 APPPATH/Controllers/Excel.php(79): 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))