Viewing File: /home/assersoft/public_html/nationallab/writable/logs/log-2025-08-26.log

ERROR - 2025-08-26 09:47:34 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:47:34 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:47:34 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 311, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:34\', \'2025-08-26 09:47:34\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 311, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:34\', \'2025-08-26 09:47:34\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:47:34 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 311, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:34\', \'2025-08-26 09:47:34\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 311, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:34\', \'2025-08-26 09:47:34\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 311, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:34\', \'2025-08-26 09:47:34\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:47:59 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:47:59 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:47:59 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:59\', \'2025-08-26 09:47:59\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:59\', \'2025-08-26 09:47:59\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:47:59 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:59\', \'2025-08-26 09:47:59\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:59\', \'2025-08-26 09:47:59\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:47:59\', \'2025-08-26 09:47:59\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:48:18 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:48:18 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:48:18 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:18\', \'2025-08-26 09:48:18\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:18\', \'2025-08-26 09:48:18\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:48:18 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:18\', \'2025-08-26 09:48:18\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:18\', \'2025-08-26 09:48:18\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:18\', \'2025-08-26 09:48:18\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:48:26 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:48:26 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:48:26 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:26\', \'2025-08-26 09:48:26\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:26\', \'2025-08-26 09:48:26\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:48:26 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:26\', \'2025-08-26 09:48:26\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:26\', \'2025-08-26 09:48:26\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 621, \'\', \'2025-08-26 14:47\', 800, 0, 800, 800, 0, \'2025-08-26 16:30\', \'2025-08-26 09:48:26\', \'2025-08-26 09:48:26\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:48:59 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:48:59 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:48:59 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:48:59\', \'2025-08-26 09:48:59\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:48:59\', \'2025-08-26 09:48:59\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:48:59 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:48:59\', \'2025-08-26 09:48:59\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:48:59\', \'2025-08-26 09:48:59\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:48:59\', \'2025-08-26 09:48:59\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:49:04 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:49:04 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:49:04 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:04\', \'2025-08-26 09:49:04\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:04\', \'2025-08-26 09:49:04\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:49:04 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:04\', \'2025-08-26 09:49:04\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:04\', \'2025-08-26 09:49:04\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:04\', \'2025-08-26 09:49:04\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:49:06 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:49:06 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:49:06 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:06\', \'2025-08-26 09:49:06\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:06\', \'2025-08-26 09:49:06\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:49:06 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:06\', \'2025-08-26 09:49:06\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:06\', \'2025-08-26 09:49:06\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:06\', \'2025-08-26 09:49:06\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:49:09 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:49:09 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:49:09 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:08\', \'2025-08-26 09:49:08\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:08\', \'2025-08-26 09:49:08\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:49:09 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:08\', \'2025-08-26 09:49:08\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:08\', \'2025-08-26 09:49:08\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:08\', \'2025-08-26 09:49:08\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:49:10 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:49:10 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:49:10 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:10\', \'2025-08-26 09:49:10\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:10\', \'2025-08-26 09:49:10\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:49:10 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:10\', \'2025-08-26 09:49:10\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:10\', \'2025-08-26 09:49:10\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:10\', \'2025-08-26 09:49:10\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:49:13 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:49:13 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:49:13 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:13\', \'2025-08-26 09:49:13\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:13\', \'2025-08-26 09:49:13\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:49:13 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:13\', \'2025-08-26 09:49:13\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:13\', \'2025-08-26 09:49:13\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 622, \'\', \'2025-08-26 14:48\', 800, 0, 800, 800, 0, \'2025-08-26 18:30\', \'2025-08-26 09:49:13\', \'2025-08-26 09:49:13\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:49:56 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:49:56 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:49:56 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:49:56\', \'2025-08-26 09:49:56\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:49:56\', \'2025-08-26 09:49:56\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:49:56 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:49:56\', \'2025-08-26 09:49:56\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:49:56\', \'2025-08-26 09:49:56\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:49:56\', \'2025-08-26 09:49:56\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:50:03 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:50:03 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:50:03 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:03\', \'2025-08-26 09:50:03\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:03\', \'2025-08-26 09:50:03\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:50:03 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:03\', \'2025-08-26 09:50:03\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:03\', \'2025-08-26 09:50:03\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:03\', \'2025-08-26 09:50:03\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:50:06 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:50:06 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:50:06 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:06\', \'2025-08-26 09:50:06\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:06\', \'2025-08-26 09:50:06\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:50:06 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:06\', \'2025-08-26 09:50:06\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:06\', \'2025-08-26 09:50:06\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:06\', \'2025-08-26 09:50:06\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 09:50:11 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 09:50:11 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 09:50:11 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:11\', \'2025-08-26 09:50:11\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:11\', \'2025-08-26 09:50:11\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 09:50:11 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:11\', \'2025-08-26 09:50:11\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:11\', \'2025-08-26 09:50:11\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 623, \'\', \'2025-08-26 14:49\', 800, 0, 800, 800, 0, \'2025-08-27 14:30\', \'2025-08-26 09:50:11\', \'2025-08-26 09:50:11\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 10:04:40 --> mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number' 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 `in...', 0)
#1 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `in...')
#2 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `in...')
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `in...', 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/InvoicesController.php(175): CodeIgniter\Model->insert(Array)
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
#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-08-26 10:04:40 --> CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
[Method: POST, Route: api/v1/invoices]
in SYSTEMPATH/Database/BaseConnection.php on line 692.
 1 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
 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-08-26 10:04:40 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 332.
 1 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 624, \'\', \'2025-08-26 15:03\', 4000, 0, 4000, 4000, 0, \'2025-08-26 16:00\', \'2025-08-26 10:04:40\', \'2025-08-26 10:04:40\')')
 2 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 624, \'\', \'2025-08-26 15:03\', 4000, 0, 4000, 4000, 0, \'2025-08-26 16:00\', \'2025-08-26 10:04:40\', \'2025-08-26 10:04:40\')')
 3 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 8 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
 9 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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-08-26 10:04:40 --> [Caused by] mysqli_sql_exception: Duplicate entry '26082025-73596' for key 'invoices.lab_number'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 327.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(327): mysqli->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 624, \'\', \'2025-08-26 15:03\', 4000, 0, 4000, 4000, 0, \'2025-08-26 16:00\', \'2025-08-26 10:04:40\', \'2025-08-26 10:04:40\')', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 624, \'\', \'2025-08-26 15:03\', 4000, 0, 4000, 4000, 0, \'2025-08-26 16:00\', \'2025-08-26 10:04:40\', \'2025-08-26 10:04:40\')')
 3 SYSTEMPATH/Database/BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (\'26082025-73596\', 624, \'\', \'2025-08-26 15:03\', 4000, 0, 4000, 4000, 0, \'2025-08-26 16:00\', \'2025-08-26 10:04:40\', \'2025-08-26 10:04:40\')')
 4 SYSTEMPATH/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query('INSERT INTO `invoices` (`lab_number`, `patient_id`, `referred_by`, `invoice_date`, `total_amount`, `discount`, `discounted_amount`, `paid_amount`, `balance`, `collecting_date`, `created_at`, `updated_at`) VALUES (:lab_number:, :patient_id:, :referred_by:, :invoice_date:, :total_amount:, :discount:, :discounted_amount:, :paid_amount:, :balance:, :collecting_date:, :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/InvoicesController.php(175): CodeIgniter\Model->insert([...])
 9 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\InvoicesController->create()
10 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\InvoicesController))
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))
ERROR - 2025-08-26 12:38:44 --> 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(1649): CodeIgniter\Database\BaseConnection->query('SELECT *\nFROM `...', Array, false)
#4 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(679): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/assersoft/public_html/nationallab/app/Controllers/TestsController.php(39): CodeIgniter\BaseModel->findAll()
#7 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\TestsController->index()
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\TestsController))
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#12 /home/assersoft/public_html/nationallab/public/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#13 {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(1649): CodeIgniter\Database\BaseConnection->query('SELECT *\nFROM `...', Array, false)
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#4 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(679): CodeIgniter\Model->doFindAll(0, 0)
#5 /home/assersoft/public_html/nationallab/app/Controllers/TestsController.php(39): CodeIgniter\BaseModel->findAll()
#6 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\TestsController->index()
#7 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\TestsController))
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(334): CodeIgniter\CodeIgniter->run()
#10 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#11 /home/assersoft/public_html/nationallab/public/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#12 {main}
CRITICAL - 2025-08-26 12:38:44 --> CodeIgniter\Database\Exceptions\DatabaseException: Unable to connect to the database.
Main connection [MySQLi]: Connection refused
[Method: GET, Route: api/v1/tests]
in SYSTEMPATH/Database/BaseConnection.php on line 467.
 1 SYSTEMPATH/Database/BaseConnection.php(620): CodeIgniter\Database\BaseConnection->initialize()
 2 SYSTEMPATH/Database/BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query('SELECT *
FROM `tests`', [], false)
 3 SYSTEMPATH/Model.php(286): CodeIgniter\Database\BaseBuilder->get()
 4 SYSTEMPATH/BaseModel.php(679): CodeIgniter\Model->doFindAll(0, 0)
 5 APPPATH/Controllers/TestsController.php(39): CodeIgniter\BaseModel->findAll()
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\TestsController->index()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\TestsController))
 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))
ERROR - 2025-08-26 12:38:46 --> 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(1649): CodeIgniter\Database\BaseConnection->query('SELECT *\nFROM `...', Array, false)
#4 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(679): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/assersoft/public_html/nationallab/app/Controllers/TestsController.php(39): CodeIgniter\BaseModel->findAll()
#7 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\TestsController->index()
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\TestsController))
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#12 /home/assersoft/public_html/nationallab/public/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#13 {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(1649): CodeIgniter\Database\BaseConnection->query('SELECT *\nFROM `...', Array, false)
#3 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#4 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/BaseModel.php(679): CodeIgniter\Model->doFindAll(0, 0)
#5 /home/assersoft/public_html/nationallab/app/Controllers/TestsController.php(39): CodeIgniter\BaseModel->findAll()
#6 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\TestsController->index()
#7 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\TestsController))
#8 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#9 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(334): CodeIgniter\CodeIgniter->run()
#10 /home/assersoft/public_html/nationallab/vendor/codeigniter4/framework/system/Boot.php(67): CodeIgniter\Boot::runCodeIgniter(Object(CodeIgniter\CodeIgniter))
#11 /home/assersoft/public_html/nationallab/public/index.php(64): CodeIgniter\Boot::bootWeb(Object(Config\Paths))
#12 {main}
CRITICAL - 2025-08-26 12:38:46 --> CodeIgniter\Database\Exceptions\DatabaseException: Unable to connect to the database.
Main connection [MySQLi]: Connection refused
[Method: GET, Route: api/v1/tests]
in SYSTEMPATH/Database/BaseConnection.php on line 467.
 1 SYSTEMPATH/Database/BaseConnection.php(620): CodeIgniter\Database\BaseConnection->initialize()
 2 SYSTEMPATH/Database/BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query('SELECT *
FROM `tests`', [], false)
 3 SYSTEMPATH/Model.php(286): CodeIgniter\Database\BaseBuilder->get()
 4 SYSTEMPATH/BaseModel.php(679): CodeIgniter\Model->doFindAll(0, 0)
 5 APPPATH/Controllers/TestsController.php(39): CodeIgniter\BaseModel->findAll()
 6 SYSTEMPATH/CodeIgniter.php(933): App\Controllers\TestsController->index()
 7 SYSTEMPATH/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\TestsController))
 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))