Viewing File: /home/assersoft/public_html/nationallab/writable/logs/log-2025-06-09.log

ERROR - 2025-06-09 20:11:35 --> mysqli_sql_exception: Column 'phone' cannot be null in /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:327
Stack trace:
#0 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `pa...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `pa...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `pa...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `pa...', Array, false)
#4 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(394): CodeIgniter\Database\BaseBuilder->insert()
#5 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(843): CodeIgniter\Model->doInsert(Array)
#6 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(800): CodeIgniter\BaseModel->insert(Array, true)
#7 /home/assersoft/public_html/nationallab/app/Controllers/PatientsController.php(90): CodeIgniter\Model->insert(Object(stdClass))
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\PatientsController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\PatientsController))
#10 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#11 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(334): CodeIgniter\CodeIgniter->run()
#12 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#13 /home/assersoft/public_html/nationallab/public/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#14 {main}
CRITICAL - 2025-06-09 20:11:35 --> CodeIgniter\Database\Exceptions\DatabaseException: Column 'phone' cannot be null
[Method: POST, Route: api/v1/patients]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `patients` (`name`, `age`, `sex`, `phone`, `created_at`, `updated_at`) VALUES (:name:, :age:, :sex:, :phone:, :created_at:, :updated_at:)', [...], false)
 2 SYSTEMPATH/Model.php(394): CodeIgniter\Database\BaseBuilder->insert()
 3 SYSTEMPATH/BaseModel.php(843): CodeIgniter\Model->doInsert([...])
 4 SYSTEMPATH/Model.php(800): CodeIgniter\BaseModel->insert([...], true)
 5 APPPATH/Controllers/PatientsController.php(90): CodeIgniter\Model->insert(Object(stdClass))
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\PatientsController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\PatientsController))
 8 SYSTEMPATH/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 SYSTEMPATH/Boot.php(334): CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
11 FCPATH/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
CRITICAL - 2025-06-09 20:11:35 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Column 'phone' cannot be null
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `patients` (`name`, `age`, `sex`, `phone`, `created_at`, `updated_at`) VALUES (\'AAMER NAZIR\', NULL, \'Male\', NULL, \'2025-06-09 20:11:35\', \'2025-06-09 20:11:35\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `patients` (`name`, `age`, `sex`, `phone`, `created_at`, `updated_at`) VALUES (\'AAMER NAZIR\', NULL, \'Male\', NULL, \'2025-06-09 20:11:35\', \'2025-06-09 20:11:35\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `patients` (`name`, `age`, `sex`, `phone`, `created_at`, `updated_at`) VALUES (:name:, :age:, :sex:, :phone:, :created_at:, :updated_at:)', [...], false)
 4 SYSTEMPATH/Model.php(394): CodeIgniter\Database\BaseBuilder->insert()
 5 SYSTEMPATH/BaseModel.php(843): CodeIgniter\Model->doInsert([...])
 6 SYSTEMPATH/Model.php(800): CodeIgniter\BaseModel->insert([...], true)
 7 APPPATH/Controllers/PatientsController.php(90): CodeIgniter\Model->insert(Object(stdClass))
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\PatientsController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\PatientsController))
10 SYSTEMPATH/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 SYSTEMPATH/Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
13 FCPATH/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
CRITICAL - 2025-06-09 20:11:35 --> [Caused by] mysqli_sql_exception: Column 'phone' cannot be null
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `patients` (`name`, `age`, `sex`, `phone`, `created_at`, `updated_at`) VALUES (\'AAMER NAZIR\', NULL, \'Male\', NULL, \'2025-06-09 20:11:35\', \'2025-06-09 20:11:35\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `patients` (`name`, `age`, `sex`, `phone`, `created_at`, `updated_at`) VALUES (\'AAMER NAZIR\', NULL, \'Male\', NULL, \'2025-06-09 20:11:35\', \'2025-06-09 20:11:35\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `patients` (`name`, `age`, `sex`, `phone`, `created_at`, `updated_at`) VALUES (\'AAMER NAZIR\', NULL, \'Male\', NULL, \'2025-06-09 20:11:35\', \'2025-06-09 20:11:35\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `patients` (`name`, `age`, `sex`, `phone`, `created_at`, `updated_at`) VALUES (:name:, :age:, :sex:, :phone:, :created_at:, :updated_at:)', [...], false)
 5 SYSTEMPATH/Model.php(394): CodeIgniter\Database\BaseBuilder->insert()
 6 SYSTEMPATH/BaseModel.php(843): CodeIgniter\Model->doInsert([...])
 7 SYSTEMPATH/Model.php(800): CodeIgniter\BaseModel->insert([...], true)
 8 APPPATH/Controllers/PatientsController.php(90): CodeIgniter\Model->insert(Object(stdClass))
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\PatientsController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\PatientsController))
11 SYSTEMPATH/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
12 SYSTEMPATH/Boot.php(334): CodeIgniter\CodeIgniter->run()
13 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
14 FCPATH/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))