Viewing File: /home/assersoft/public_html/nationallab/writable/logs/log-2025-06-01.log
ERROR - 2025-06-01 12:18:04 --> mysqli_sql_exception: Not unique table/alias: 'tests' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 12:18:05 --> CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
[Method: GET, Route: api/v1/invoices/invoice-tests/search-by-status]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:18:05 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:18:05 --> [Caused by] mysqli_sql_exception: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 12:18:05 --> mysqli_sql_exception: Not unique table/alias: 'tests' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 12:18:05 --> CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
[Method: GET, Route: api/v1/invoices/invoice-tests/search-by-status]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:18:05 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:18:05 --> [Caused by] mysqli_sql_exception: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 12:18:56 --> mysqli_sql_exception: Not unique table/alias: 'tests' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 12:18:56 --> CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
[Method: GET, Route: api/v1/invoices/invoice-tests/search-by-status]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:18:56 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:18:56 --> [Caused by] mysqli_sql_exception: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 12:18:56 --> mysqli_sql_exception: Not unique table/alias: 'tests' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 12:18:56 --> CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
[Method: GET, Route: api/v1/invoices/invoice-tests/search-by-status]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:18:56 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:18:56 --> [Caused by] mysqli_sql_exception: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 12:20:59 --> mysqli_sql_exception: Not unique table/alias: 'tests' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 12:20:59 --> CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
[Method: GET, Route: api/v1/invoices/invoice-tests/search-by-status]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:20:59 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:20:59 --> [Caused by] mysqli_sql_exception: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 12:20:59 --> mysqli_sql_exception: Not unique table/alias: 'tests' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 12:20:59 --> CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
[Method: GET, Route: api/v1/invoices/invoice-tests/search-by-status]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:20:59 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:20:59 --> [Caused by] mysqli_sql_exception: Not unique table/alias: 'tests'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(401): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 12:22:39 --> mysqli_sql_exception: Unknown table 'test_items' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(399): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 12:22:39 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown table 'test_items'
[Method: GET, Route: api/v1/invoices/invoice-tests/search-by-status]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(399): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:22:39 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown table 'test_items'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(399): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:22:39 --> [Caused by] mysqli_sql_exception: Unknown table 'test_items'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(399): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 12:22:40 --> mysqli_sql_exception: Unknown table 'test_items' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(399): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 12:22:40 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown table 'test_items'
[Method: GET, Route: api/v1/invoices/invoice-tests/search-by-status]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(399): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:22:40 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown table 'test_items'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(399): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 12:22:40 --> [Caused by] mysqli_sql_exception: Unknown table 'test_items'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(399): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoicesTestsByStatus()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 13:44:20 --> Error: Cannot use object of type stdClass as array
[Method: POST, Route: api/v1/reports]
in APPPATH\Controllers\ReportsController.php on line 133.
1 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->create()
2 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
3 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
4 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
5 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
6 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
7 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 13:46:59 --> Error: Cannot use object of type stdClass as array
[Method: POST, Route: api/v1/reports]
in APPPATH\Controllers\ReportsController.php on line 144.
1 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->create()
2 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
3 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
4 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
5 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
6 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
7 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 13:47:16 --> Error: Cannot use object of type stdClass as array
[Method: POST, Route: api/v1/reports]
in APPPATH\Controllers\ReportsController.php on line 144.
1 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->create()
2 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
3 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
4 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
5 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
6 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
7 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 13:47:19 --> Error: Cannot use object of type stdClass as array
[Method: POST, Route: api/v1/reports]
in APPPATH\Controllers\ReportsController.php on line 144.
1 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->create()
2 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
3 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
4 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
5 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
6 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
7 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 13:47:43 --> CodeIgniter\Validation\Exceptions\ValidationException: "checkReportExists" is not a valid rule.
[Method: POST, Route: api/v1/reports]
in SYSTEMPATH\Validation\Validation.php on line 345.
1 SYSTEMPATH\Validation\Validation.php(345): CodeIgniter\Validation\Exceptions\ValidationException::forRuleNotFound()
2 SYSTEMPATH\Validation\Validation.php(201): CodeIgniter\Validation\Validation->processRules()
3 SYSTEMPATH\BaseModel.php(1580): CodeIgniter\Validation\Validation->run()
4 SYSTEMPATH\BaseModel.php(936): CodeIgniter\BaseModel->validate()
5 APPPATH\Controllers\ReportsController.php(148): CodeIgniter\BaseModel->insertBatch()
6 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->create()
7 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
11 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
12 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 13:51:22 --> mysqli_sql_exception: Table 'nationallab.reportdetails' doesn't exist in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1841): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(2230): CodeIgniter\Database\BaseBuilder->batchExecute()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(428): CodeIgniter\Database\BaseBuilder->insertBatch()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(963): CodeIgniter\Model->doInsertBatch()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\ReportsController.php(150): CodeIgniter\BaseModel->insertBatch()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\ReportsController->create()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#14 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#15 {main}
CRITICAL - 2025-06-01 13:51:22 --> CodeIgniter\Database\Exceptions\DatabaseException: Table 'nationallab.reportdetails' doesn't exist
[Method: POST, Route: api/v1/reports]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1841): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Database\BaseBuilder.php(2230): CodeIgniter\Database\BaseBuilder->batchExecute()
3 SYSTEMPATH\Model.php(428): CodeIgniter\Database\BaseBuilder->insertBatch()
4 SYSTEMPATH\BaseModel.php(963): CodeIgniter\Model->doInsertBatch()
5 APPPATH\Controllers\ReportsController.php(150): CodeIgniter\BaseModel->insertBatch()
6 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->create()
7 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
11 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
12 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 13:51:22 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Table 'nationallab.reportdetails' doesn't exist
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1841): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Database\BaseBuilder.php(2230): CodeIgniter\Database\BaseBuilder->batchExecute()
5 SYSTEMPATH\Model.php(428): CodeIgniter\Database\BaseBuilder->insertBatch()
6 SYSTEMPATH\BaseModel.php(963): CodeIgniter\Model->doInsertBatch()
7 APPPATH\Controllers\ReportsController.php(150): CodeIgniter\BaseModel->insertBatch()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->create()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 13:51:22 --> [Caused by] mysqli_sql_exception: Table 'nationallab.reportdetails' doesn't exist
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1841): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Database\BaseBuilder.php(2230): CodeIgniter\Database\BaseBuilder->batchExecute()
6 SYSTEMPATH\Model.php(428): CodeIgniter\Database\BaseBuilder->insertBatch()
7 SYSTEMPATH\BaseModel.php(963): CodeIgniter\Model->doInsertBatch()
8 APPPATH\Controllers\ReportsController.php(150): CodeIgniter\BaseModel->insertBatch()
9 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->create()
10 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
11 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
12 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
13 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
14 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
15 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 16:53:51 --> mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7 in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#11 {main}
CRITICAL - 2025-06-01 16:53:51 --> CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
[Method: GET, Route: api/v1/dashboard/summary]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
3 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
4 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
5 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
6 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
7 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
8 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 16:53:51 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
5 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
6 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
7 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
8 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
9 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
10 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 16:53:51 --> [Caused by] mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 16:53:51 --> mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7 in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#11 {main}
CRITICAL - 2025-06-01 16:53:51 --> CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
[Method: GET, Route: api/v1/dashboard/summary]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
3 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
4 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
5 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
6 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
7 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
8 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 16:53:51 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
5 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
6 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
7 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
8 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
9 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
10 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 16:53:51 --> [Caused by] mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 16:54:06 --> mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7 in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#11 {main}
CRITICAL - 2025-06-01 16:54:06 --> CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
[Method: GET, Route: api/v1/dashboard/summary]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
3 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
4 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
5 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
6 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
7 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
8 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 16:54:06 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
5 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
6 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
7 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
8 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
9 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
10 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 16:54:06 --> [Caused by] mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 16:54:06 --> mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7 in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#11 {main}
CRITICAL - 2025-06-01 16:54:06 --> CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
[Method: GET, Route: api/v1/dashboard/summary]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
3 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
4 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
5 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
6 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
7 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
8 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 16:54:06 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
5 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
6 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
7 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
8 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
9 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
10 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 16:54:06 --> [Caused by] mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select invoices.lab_number, patients.name as patient_name, tests.name as test_n' at line 7
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 APPPATH\Controllers\DashboardController.php(13): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\DashboardController->summary()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 17:31:46 --> CodeIgniter\Security\Exceptions\SecurityException: Attempted to send a secure cookie over a non-secure connection.
[Method: POST, Route: api/v1/auth/logout]
in SYSTEMPATH\HTTP\ResponseTrait.php on line 679.
1 SYSTEMPATH\HTTP\ResponseTrait.php(679): CodeIgniter\Security\Exceptions\SecurityException::forInsecureCookie()
2 SYSTEMPATH\HTTP\ResponseTrait.php(669): CodeIgniter\HTTP\Response->dispatchCookies()
3 SYSTEMPATH\HTTP\ResponseTrait.php(377): CodeIgniter\HTTP\Response->sendCookies()
4 SYSTEMPATH\CodeIgniter.php(1107): CodeIgniter\HTTP\Response->send()
5 SYSTEMPATH\CodeIgniter.php(377): CodeIgniter\CodeIgniter->sendResponse()
6 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
7 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
8 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
9 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 17:31:46 --> ErrorException: Uncaught CodeIgniter\Security\Exceptions\SecurityException: Attempted to send a secure cookie over a non-secure connection. in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\HTTP\ResponseTrait.php:679
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\HTTP\ResponseTrait.php(679): CodeIgniter\Security\Exceptions\SecurityException::forInsecureCookie()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\HTTP\ResponseTrait.php(669): CodeIgniter\HTTP\Response->dispatchCookies()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\HTTP\ResponseTrait.php(377): CodeIgniter\HTTP\Response->sendCookies()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Debug\ExceptionHandler.php(85): CodeIgniter\HTTP\Response->send()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Debug\Exceptions.php(162): CodeIgniter\Debug\ExceptionHandler->handle()
#5 [internal function]: CodeIgniter\Debug\Exceptions->exceptionHandler()
#6 {main}
thrown
【Previous Exception】
CodeIgniter\Security\Exceptions\SecurityException
Attempted to send a secure cookie over a non-secure connection.
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\HTTP\ResponseTrait.php(679): CodeIgniter\Security\Exceptions\SecurityException::forInsecureCookie()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\HTTP\ResponseTrait.php(669): CodeIgniter\HTTP\Response->dispatchCookies()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\HTTP\ResponseTrait.php(377): CodeIgniter\HTTP\Response->sendCookies()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(1107): CodeIgniter\HTTP\Response->send()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(377): CodeIgniter\CodeIgniter->sendResponse()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#9 {main}
[Method: POST, Route: api/v1/auth/logout]
in SYSTEMPATH\HTTP\ResponseTrait.php on line 679.
1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
ERROR - 2025-06-01 18:23:51 --> mysqli_sql_exception: Unknown column 'tests.test_name' in 'field list' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(1291): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\ReportsController.php(64): CodeIgniter\BaseModel->paginate()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\ReportsController->index()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#14 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#15 {main}
CRITICAL - 2025-06-01 18:23:51 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'tests.test_name' in 'field list'
[Method: GET, Route: api/v1/reports]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 SYSTEMPATH\BaseModel.php(1291): CodeIgniter\BaseModel->findAll()
5 APPPATH\Controllers\ReportsController.php(64): CodeIgniter\BaseModel->paginate()
6 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->index()
7 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
11 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
12 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 18:23:51 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'tests.test_name' in 'field list'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 SYSTEMPATH\BaseModel.php(1291): CodeIgniter\BaseModel->findAll()
7 APPPATH\Controllers\ReportsController.php(64): CodeIgniter\BaseModel->paginate()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->index()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 18:23:51 --> [Caused by] mysqli_sql_exception: Unknown column 'tests.test_name' in 'field list'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 SYSTEMPATH\BaseModel.php(1291): CodeIgniter\BaseModel->findAll()
8 APPPATH\Controllers\ReportsController.php(64): CodeIgniter\BaseModel->paginate()
9 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\ReportsController->index()
10 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
11 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
12 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
13 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
14 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
15 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 19:14:33 --> mysqli_sql_exception: Unknown column 'report_details.invoice_test_id' in 'where clause' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(404): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 19:14:33 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'report_details.invoice_test_id' in 'where clause'
[Method: GET, Route: api/v1/invoices/invoice-tests/25]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(404): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 19:14:33 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'report_details.invoice_test_id' in 'where clause'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(404): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 19:14:33 --> [Caused by] mysqli_sql_exception: Unknown column 'report_details.invoice_test_id' in 'where clause'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(404): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 19:14:33 --> mysqli_sql_exception: Unknown column 'report_details.invoice_test_id' in 'where clause' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(679): CodeIgniter\Model->doFindAll()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(404): CodeIgniter\BaseModel->findAll()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 19:14:33 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'report_details.invoice_test_id' in 'where clause'
[Method: GET, Route: api/v1/invoices/invoice-tests/25]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
4 APPPATH\Controllers\InvoicesController.php(404): CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 19:14:33 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'report_details.invoice_test_id' in 'where clause'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
6 APPPATH\Controllers\InvoicesController.php(404): CodeIgniter\BaseModel->findAll()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 19:14:33 --> [Caused by] mysqli_sql_exception: Unknown column 'report_details.invoice_test_id' in 'where clause'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(286): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(679): CodeIgniter\Model->doFindAll()
7 APPPATH\Controllers\InvoicesController.php(404): CodeIgniter\BaseModel->findAll()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 19:19:39 --> mysqli_sql_exception: Unknown column 'invoices.invoice_id' in 'field list' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(330): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(717): CodeIgniter\Model->doFirst()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(391): CodeIgniter\BaseModel->first()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 19:19:39 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'invoices.invoice_id' in 'field list'
[Method: GET, Route: api/v1/invoices/invoice-tests/25]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(330): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(717): CodeIgniter\Model->doFirst()
4 APPPATH\Controllers\InvoicesController.php(391): CodeIgniter\BaseModel->first()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 19:19:39 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'invoices.invoice_id' in 'field list'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(330): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(717): CodeIgniter\Model->doFirst()
6 APPPATH\Controllers\InvoicesController.php(391): CodeIgniter\BaseModel->first()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 19:19:39 --> [Caused by] mysqli_sql_exception: Unknown column 'invoices.invoice_id' in 'field list'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(330): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(717): CodeIgniter\Model->doFirst()
7 APPPATH\Controllers\InvoicesController.php(391): CodeIgniter\BaseModel->first()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
ERROR - 2025-06-01 19:19:40 --> mysqli_sql_exception: Unknown column 'invoices.invoice_id' in 'field list' in C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php:327
Stack trace:
#0 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(327): mysqli->query()
#1 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
#2 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
#4 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Model.php(330): CodeIgniter\Database\BaseBuilder->get()
#5 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\BaseModel.php(717): CodeIgniter\Model->doFirst()
#6 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\app\Controllers\InvoicesController.php(391): CodeIgniter\BaseModel->first()
#7 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
#8 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#9 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#10 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(334): CodeIgniter\CodeIgniter->run()
#11 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
#12 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\public\index.php(59): CodeIgniter\Boot::bootWeb()
#13 C:\Users\abdul\OneDrive\Desktop\NationalLab-Web\server\vendor\codeigniter4\framework\system\rewrite.php(44): require_once('...')
#14 {main}
CRITICAL - 2025-06-01 19:19:40 --> CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'invoices.invoice_id' in 'field list'
[Method: GET, Route: api/v1/invoices/invoice-tests/25]
in SYSTEMPATH\Database\BaseConnection.php on line 692.
1 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH\Model.php(330): CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH\BaseModel.php(717): CodeIgniter\Model->doFirst()
4 APPPATH\Controllers\InvoicesController.php(391): CodeIgniter\BaseModel->first()
5 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
6 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
10 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
11 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 19:19:40 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: Unknown column 'invoices.invoice_id' in 'field list'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 332.
1 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
2 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
3 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
4 SYSTEMPATH\Model.php(330): CodeIgniter\Database\BaseBuilder->get()
5 SYSTEMPATH\BaseModel.php(717): CodeIgniter\Model->doFirst()
6 APPPATH\Controllers\InvoicesController.php(391): CodeIgniter\BaseModel->first()
7 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
8 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
12 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
13 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
CRITICAL - 2025-06-01 19:19:40 --> [Caused by] mysqli_sql_exception: Unknown column 'invoices.invoice_id' in 'field list'
in SYSTEMPATH\Database\MySQLi\Connection.php on line 327.
1 SYSTEMPATH\Database\MySQLi\Connection.php(327): mysqli->query()
2 SYSTEMPATH\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute()
3 SYSTEMPATH\Database\BaseConnection.php(652): CodeIgniter\Database\BaseConnection->simpleQuery()
4 SYSTEMPATH\Database\BaseBuilder.php(1649): CodeIgniter\Database\BaseConnection->query()
5 SYSTEMPATH\Model.php(330): CodeIgniter\Database\BaseBuilder->get()
6 SYSTEMPATH\BaseModel.php(717): CodeIgniter\Model->doFirst()
7 APPPATH\Controllers\InvoicesController.php(391): CodeIgniter\BaseModel->first()
8 SYSTEMPATH\CodeIgniter.php(933): App\Controllers\InvoicesController->getInvoiceTestById()
9 SYSTEMPATH\CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
10 SYSTEMPATH\CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
11 SYSTEMPATH\Boot.php(334): CodeIgniter\CodeIgniter->run()
12 SYSTEMPATH\Boot.php(67): CodeIgniter\Boot::runCodeIgniter()
13 FCPATH\index.php(59): CodeIgniter\Boot::bootWeb()
14 SYSTEMPATH\rewrite.php(44): require_once('C:\\Users\\abdul\\OneDrive\\Desktop\\NationalLab-Web\\server\\public\\index.php')
Back to Directory
File Manager