Viewing File: /home/assersoft/public_html/nationallab/writable/logs/log-2025-07-23.log

ERROR - 2025-07-23 03:57:45 --> Error connecting to the database: mysqli_sql_exception: Connection refused in /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:201
Stack trace:
#0 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(201): mysqli->real_connect('localhost', 'assersoft_natio...', Object(SensitiveParameterValue), 'assersoft_natio...', 3306, '', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(421): CodeIgniter\Database\MySQLi\Connection->connect(false)
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(620): CodeIgniter\Database\BaseConnection->initialize()
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1733): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/assersoft/public_html/nationallab/app/Validation/PatientRules.php(12): CodeIgniter\Database\BaseBuilder->countAllResults()
#5 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Validation/Validation.php(335): App\Validation\PatientRules::checkPatientExists(357, NULL)
#6 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Validation/Validation.php(201): CodeIgniter\Validation\Validation->processRules('patient_id', 'patient_id', 357, Array, Array, 'patient_id')
#7 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(1580): CodeIgniter\Validation\Validation->run(Array, NULL, NULL)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(812): CodeIgniter\BaseModel->validate(Array)
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(800): CodeIgniter\BaseModel->insert(Array, true)
#10 /home/assersoft/public_html/nationallab/app/Controllers/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#11 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#12 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#13 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#14 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(334): CodeIgniter\CodeIgniter->run()
#15 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#16 /home/assersoft/public_html/nationallab/public/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#17 {main}

Next CodeIgniter\Database\Exceptions\DatabaseException: Connection refused in /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:246
Stack trace:
#0 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(421): CodeIgniter\Database\MySQLi\Connection->connect(false)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(620): CodeIgniter\Database\BaseConnection->initialize()
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1733): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#3 /home/assersoft/public_html/nationallab/app/Validation/PatientRules.php(12): CodeIgniter\Database\BaseBuilder->countAllResults()
#4 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Validation/Validation.php(335): App\Validation\PatientRules::checkPatientExists(357, NULL)
#5 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Validation/Validation.php(201): CodeIgniter\Validation\Validation->processRules('patient_id', 'patient_id', 357, Array, Array, 'patient_id')
#6 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(1580): CodeIgniter\Validation\Validation->run(Array, NULL, NULL)
#7 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(812): CodeIgniter\BaseModel->validate(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(800): CodeIgniter\BaseModel->insert(Array, true)
#9 /home/assersoft/public_html/nationallab/app/Controllers/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#10 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#11 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#12 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#13 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(334): CodeIgniter\CodeIgniter->run()
#14 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#15 /home/assersoft/public_html/nationallab/public/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#16 {main}
CRITICAL - 2025-07-23 03:57:45 --> CodeIgniter\Database\Exceptions\DatabaseException: Unable to connect to the database.
Main connection [MySQLi]: Connection refused
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 467.
 1 SYSTEMPATH/Database/BaseConnection.php(620): CodeIgniter\Database\BaseConnection->initialize()
 2 SYSTEMPATH/Database/BaseBuilder.php(1733): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM `patients`
WHERE `id` = :id:', [...], false)
 3 APPPATH/Validation/PatientRules.php(12): CodeIgniter\Database\BaseBuilder->countAllResults()
 4 SYSTEMPATH/Validation/Validation.php(335): App\Validation\PatientRules::checkPatientExists(357, null)
 5 SYSTEMPATH/Validation/Validation.php(201): CodeIgniter\Validation\Validation->processRules('patient_id', 'patient_id', 357, [...], [...], 'patient_id')
 6 SYSTEMPATH/BaseModel.php(1580): CodeIgniter\Validation\Validation->run([...], null, null)
 7 SYSTEMPATH/BaseModel.php(812): CodeIgniter\BaseModel->validate([...])
 8 SYSTEMPATH/Model.php(800): CodeIgniter\BaseModel->insert([...], true)
 9 APPPATH/Controllers/InvoicesController.php(175): CodeIgniter\Model->insert([...])
10 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
11 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
12 SYSTEMPATH/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
13 SYSTEMPATH/Boot.php(334): CodeIgniter\CodeIgniter->run()
14 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
15 FCPATH/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
ERROR - 2025-07-23 03:57:49 --> Error connecting to the database: mysqli_sql_exception: Connection refused in /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:201
Stack trace:
#0 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(201): mysqli->real_connect('localhost', 'assersoft_natio...', Object(SensitiveParameterValue), 'assersoft_natio...', 3306, '', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(421): CodeIgniter\Database\MySQLi\Connection->connect(false)
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(620): CodeIgniter\Database\BaseConnection->initialize()
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1733): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/assersoft/public_html/nationallab/app/Validation/PatientRules.php(12): CodeIgniter\Database\BaseBuilder->countAllResults()
#5 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Validation/Validation.php(335): App\Validation\PatientRules::checkPatientExists(357, NULL)
#6 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Validation/Validation.php(201): CodeIgniter\Validation\Validation->processRules('patient_id', 'patient_id', 357, Array, Array, 'patient_id')
#7 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(1580): CodeIgniter\Validation\Validation->run(Array, NULL, NULL)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(812): CodeIgniter\BaseModel->validate(Array)
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(800): CodeIgniter\BaseModel->insert(Array, true)
#10 /home/assersoft/public_html/nationallab/app/Controllers/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#11 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#12 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#13 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#14 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(334): CodeIgniter\CodeIgniter->run()
#15 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#16 /home/assersoft/public_html/nationallab/public/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#17 {main}

Next CodeIgniter\Database\Exceptions\DatabaseException: Connection refused in /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:246
Stack trace:
#0 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(421): CodeIgniter\Database\MySQLi\Connection->connect(false)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(620): CodeIgniter\Database\BaseConnection->initialize()
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1733): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#3 /home/assersoft/public_html/nationallab/app/Validation/PatientRules.php(12): CodeIgniter\Database\BaseBuilder->countAllResults()
#4 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Validation/Validation.php(335): App\Validation\PatientRules::checkPatientExists(357, NULL)
#5 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Validation/Validation.php(201): CodeIgniter\Validation\Validation->processRules('patient_id', 'patient_id', 357, Array, Array, 'patient_id')
#6 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(1580): CodeIgniter\Validation\Validation->run(Array, NULL, NULL)
#7 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(812): CodeIgniter\BaseModel->validate(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(800): CodeIgniter\BaseModel->insert(Array, true)
#9 /home/assersoft/public_html/nationallab/app/Controllers/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#10 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#11 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#12 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#13 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(334): CodeIgniter\CodeIgniter->run()
#14 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#15 /home/assersoft/public_html/nationallab/public/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#16 {main}
CRITICAL - 2025-07-23 03:57:49 --> CodeIgniter\Database\Exceptions\DatabaseException: Unable to connect to the database.
Main connection [MySQLi]: Connection refused
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 467.
 1 SYSTEMPATH/Database/BaseConnection.php(620): CodeIgniter\Database\BaseConnection->initialize()
 2 SYSTEMPATH/Database/BaseBuilder.php(1733): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM `patients`
WHERE `id` = :id:', [...], false)
 3 APPPATH/Validation/PatientRules.php(12): CodeIgniter\Database\BaseBuilder->countAllResults()
 4 SYSTEMPATH/Validation/Validation.php(335): App\Validation\PatientRules::checkPatientExists(357, null)
 5 SYSTEMPATH/Validation/Validation.php(201): CodeIgniter\Validation\Validation->processRules('patient_id', 'patient_id', 357, [...], [...], 'patient_id')
 6 SYSTEMPATH/BaseModel.php(1580): CodeIgniter\Validation\Validation->run([...], null, null)
 7 SYSTEMPATH/BaseModel.php(812): CodeIgniter\BaseModel->validate([...])
 8 SYSTEMPATH/Model.php(800): CodeIgniter\BaseModel->insert([...], true)
 9 APPPATH/Controllers/InvoicesController.php(175): CodeIgniter\Model->insert([...])
10 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
11 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
12 SYSTEMPATH/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
13 SYSTEMPATH/Boot.php(334): CodeIgniter\CodeIgniter->run()
14 SYSTEMPATH/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
15 FCPATH/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))