CRITICAL - 2025-06-18 04:58:12 --> Undefined variable: agent_agent_id
in ROOTPATH/modules/Agent/Controllers/Agent.php on line 83.
 1 ROOTPATH/modules/Agent/Controllers/Agent.php(83): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: agent_agent_id', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Controllers/Agent.php', 83, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 4 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 6 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-18 05:02:43 --> mysqli_sql_exception: Unknown column 'agents.name' in 'SELECT' in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `agents`...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `agents`...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `agents`...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `agents`...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Controllers/Agent.php(94): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-06-18 05:02:43 --> Unknown column 'agents.name' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `agents`.`name` as `agent_name`, `companies`.`name` as `company_name`, `payagents`.`agent_id`, `payagents`.`company_id`, SUM(payagents.amount) as total_amount
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
WHERE `payagents`.`company_id` > 0
AND `payagents`.`status` = 1
AND `payagents`.`deleted_at` IS NULL
GROUP BY `payagents`.`agent_id`, `payagents`.`company_id`', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `agents`.`name` as `agent_name`, `companies`.`name` as `company_name`, `payagents`.`agent_id`, `payagents`.`company_id`, SUM(payagents.amount) as total_amount
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
WHERE `payagents`.`company_id` > 0
AND `payagents`.`status` = 1
AND `payagents`.`deleted_at` IS NULL
GROUP BY `payagents`.`agent_id`, `payagents`.`company_id`')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `agents`.`name` as `agent_name`, `companies`.`name` as `company_name`, `payagents`.`agent_id`, `payagents`.`company_id`, SUM(payagents.amount) as total_amount
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
WHERE `payagents`.`company_id` > 0
AND `payagents`.`status` = 1
AND `payagents`.`deleted_at` IS NULL
GROUP BY `payagents`.`agent_id`, `payagents`.`company_id`')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `agents`.`name` as `agent_name`, `companies`.`name` as `company_name`, `payagents`.`agent_id`, `payagents`.`company_id`, SUM(payagents.amount) as total_amount
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
WHERE `payagents`.`company_id` > :payagents.company_id:
AND `payagents`.`status` = :payagents.status:
AND `payagents`.`deleted_at` IS NULL
GROUP BY `payagents`.`agent_id`, `payagents`.`company_id`', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Agent/Controllers/Agent.php(94): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 05:16:09 --> Use of undefined constant exir - assumed 'exir' (this will throw an Error in a future version of PHP)
in ROOTPATH/modules/Agent/Controllers/Agent.php on line 100.
 1 ROOTPATH/modules/Agent/Controllers/Agent.php(100): CodeIgniter\Debug\Exceptions->errorHandler(2, 'Use of undefined constant exir - assumed \'exir\' (this will throw an Error in a future version of PHP)', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Controllers/Agent.php', 100, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 4 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 6 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 05:20:51 --> Cannot use temporary expression in write context
in ROOTPATH/modules/Agent/Controllers/Agent.php on line 98.
 1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
CRITICAL - 2025-06-18 05:20:59 --> Cannot use temporary expression in write context
in ROOTPATH/modules/Agent/Controllers/Agent.php on line 98.
 1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
CRITICAL - 2025-06-18 05:21:00 --> Cannot use temporary expression in write context
in ROOTPATH/modules/Agent/Controllers/Agent.php on line 98.
 1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
CRITICAL - 2025-06-18 05:21:02 --> Cannot use temporary expression in write context
in ROOTPATH/modules/Agent/Controllers/Agent.php on line 98.
 1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
CRITICAL - 2025-06-18 05:49:38 --> Trying to get property 'company_names' of non-object
in ROOTPATH/modules/Agent/Views/agent/index.php on line 57.
 1 ROOTPATH/modules/Agent/Views/agent/index.php(57): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Trying to get property \'company_names\' of non-object', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php', 57, [...])
 2 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php')
 3 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 4 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Agent\\Views\\agent\\index', [], true)
 5 ROOTPATH/modules/Agent/Controllers/Agent.php(131): view('Modules\\Agent\\Views\\agent\\index', [...])
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 8 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
10 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 05:50:02 --> Undefined property: stdClass::$company_names
in ROOTPATH/modules/Agent/Views/agent/index.php on line 57.
 1 ROOTPATH/modules/Agent/Views/agent/index.php(57): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: stdClass::$company_names', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php', 57, [...])
 2 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php')
 3 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 4 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Agent\\Views\\agent\\index', [], true)
 5 ROOTPATH/modules/Agent/Controllers/Agent.php(131): view('Modules\\Agent\\Views\\agent\\index', [...])
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 8 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
10 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 05:50:04 --> Undefined property: stdClass::$company_names
in ROOTPATH/modules/Agent/Views/agent/index.php on line 57.
 1 ROOTPATH/modules/Agent/Views/agent/index.php(57): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: stdClass::$company_names', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php', 57, [...])
 2 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php')
 3 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 4 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Agent\\Views\\agent\\index', [], true)
 5 ROOTPATH/modules/Agent/Controllers/Agent.php(131): view('Modules\\Agent\\Views\\agent\\index', [...])
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 8 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
10 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 05:50:12 --> Undefined property: stdClass::$company_names
in ROOTPATH/modules/Agent/Views/agent/index.php on line 57.
 1 ROOTPATH/modules/Agent/Views/agent/index.php(57): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: stdClass::$company_names', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php', 57, [...])
 2 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php')
 3 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 4 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Agent\\Views\\agent\\index', [], true)
 5 ROOTPATH/modules/Agent/Controllers/Agent.php(131): view('Modules\\Agent\\Views\\agent\\index', [...])
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 8 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
10 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 05:50:18 --> Undefined property: stdClass::$company_names
in ROOTPATH/modules/Agent/Views/agent/index.php on line 57.
 1 ROOTPATH/modules/Agent/Views/agent/index.php(57): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: stdClass::$company_names', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php', 57, [...])
 2 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php')
 3 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 4 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Agent\\Views\\agent\\index', [], true)
 5 ROOTPATH/modules/Agent/Controllers/Agent.php(131): view('Modules\\Agent\\Views\\agent\\index', [...])
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 8 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 9 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
10 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 05:51:02 --> Undefined property: stdClass::$aget_id
in ROOTPATH/modules/Agent/Controllers/Agent.php on line 114.
 1 ROOTPATH/modules/Agent/Controllers/Agent.php(114): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: stdClass::$aget_id', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Controllers/Agent.php', 114, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 4 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 5 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 6 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 06:08:33 --> number_format() expects parameter 1 to be float, array given
in ROOTPATH/modules/Agent/Views/agent/index.php on line 67.
 1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'number_format() expects parameter 1 to be float, array given', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php', 67, [...])
 2 ROOTPATH/modules/Agent/Views/agent/index.php(67): number_format([...], 2)
 3 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php')
 4 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 5 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Agent\\Views\\agent\\index', [], true)
 6 ROOTPATH/modules/Agent/Controllers/Agent.php(131): view('Modules\\Agent\\Views\\agent\\index', [...])
 7 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 8 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 9 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
10 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
11 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 06:09:06 --> implode(): Invalid arguments passed
in ROOTPATH/modules/Agent/Views/agent/index.php on line 67.
 1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'implode(): Invalid arguments passed', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php', 67, [...])
 2 ROOTPATH/modules/Agent/Views/agent/index.php(67): implode(' + ', false)
 3 SYSTEMPATH/View/View.php(226): include('/home/busvalle/data.busvalley.com/busvalley_new/modules/Agent/Views/agent/index.php')
 4 SYSTEMPATH/View/View.php(229): CodeIgniter\View\View->CodeIgniter\View\{closure}()
 5 SYSTEMPATH/Common.php(1174): CodeIgniter\View\View->render('Modules\\Agent\\Views\\agent\\index', [], true)
 6 ROOTPATH/modules/Agent/Controllers/Agent.php(131): view('Modules\\Agent\\Views\\agent\\index', [...])
 7 SYSTEMPATH/CodeIgniter.php(932): Modules\Agent\Controllers\Agent->index()
 8 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Agent\Controllers\Agent))
 9 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
10 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
11 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-18 08:51:40 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 08:51:40 --> 
ERROR - 2025-06-18 09:15:39 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 09:15:39 --> 
ERROR - 2025-06-18 09:32:41 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 09:32:41 --> 
ERROR - 2025-06-18 11:21:57 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 11:21:57 --> 
ERROR - 2025-06-18 11:24:09 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 11:24:09 --> 
ERROR - 2025-06-18 11:26:46 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 11:26:46 --> 
ERROR - 2025-06-18 11:55:29 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 11:55:29 --> 
ERROR - 2025-06-18 12:50:38 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 12:50:38 --> 
ERROR - 2025-06-18 13:10:51 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 13:10:51 --> 
ERROR - 2025-06-18 13:27:34 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 13:27:34 --> 
ERROR - 2025-06-18 13:47:42 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 13:47:42 --> 
ERROR - 2025-06-18 13:48:36 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 13:48:36 --> 
ERROR - 2025-06-18 13:54:44 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 13:54:44 --> 
CRITICAL - 2025-06-18 13:56:53 --> Trying to get property 'trip_id' of non-object
in APPPATH/Libraries/Ticketmail.php on line 88.
 1 APPPATH/Libraries/Ticketmail.php(88): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Trying to get property \'trip_id\' of non-object', '/home/busvalle/data.busvalley.com/busvalley_new/app/Libraries/Ticketmail.php', 88, [...])
 2 ROOTPATH/modules/Ticket/Controllers/Ticket.php(1043): App\Libraries\Ticketmail->getticketEmailData('TBKVBA35YC')
 3 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->create()
 4 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
 5 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 6 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 7 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-18 13:58:22 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 13:58:22 --> 
ERROR - 2025-06-18 14:05:00 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 14:05:00 --> 
ERROR - 2025-06-18 14:13:25 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 14:13:25 --> 
ERROR - 2025-06-18 14:14:26 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 14:14:26 --> 
ERROR - 2025-06-18 15:21:38 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 15:21:38 --> 
ERROR - 2025-06-18 15:29:23 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 15:29:23 --> 
ERROR - 2025-06-18 15:59:43 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 15:59:43 --> 
ERROR - 2025-06-18 17:43:52 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 17:43:52 --> 
ERROR - 2025-06-18 17:58:23 --> mysqli_sql_exception: Unknown column 'CASE WHEN booker.id IS NOT NULL THEN "Admin" WHEN booker_agents.id IS NOT NULL THEN "Agent" END' in 'SELECT' in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php(2187): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('64')
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-06-18 17:58:23 --> Unknown column 'CASE WHEN booker.id IS NOT NULL THEN "Admin" WHEN booker_agents.id IS NOT NULL THEN "Agent" END' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`id IS NOT NULL THEN "Admin" WHEN booker_agents`.`id IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`id IS NOT NULL THEN "Admin" WHEN booker_agents`.`id IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`id IS NOT NULL THEN "Admin" WHEN booker_agents`.`id IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`id IS NOT NULL THEN "Admin" WHEN booker_agents`.`id IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = :pretrip.id:
AND `pretrip`.`deleted_at` IS NULL', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Ticket/Controllers/Ticket.php(2187): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('64')
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-18 17:58:53 --> mysqli_sql_exception: Unknown column 'CASE WHEN booker.first_name IS NOT NULL THEN "Admin" WHEN booker_agents.first_name IS NOT NULL THEN "Agent" END' in 'SELECT' in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php(2187): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('64')
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-06-18 17:58:53 --> Unknown column 'CASE WHEN booker.first_name IS NOT NULL THEN "Admin" WHEN booker_agents.first_name IS NOT NULL THEN "Agent" END' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = :pretrip.id:
AND `pretrip`.`deleted_at` IS NULL', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Ticket/Controllers/Ticket.php(2187): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('64')
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-18 17:58:57 --> mysqli_sql_exception: Unknown column 'CASE WHEN booker.first_name IS NOT NULL THEN "Admin" WHEN booker_agents.first_name IS NOT NULL THEN "Agent" END' in 'SELECT' in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php(2187): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('64')
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-06-18 17:58:57 --> Unknown column 'CASE WHEN booker.first_name IS NOT NULL THEN "Admin" WHEN booker_agents.first_name IS NOT NULL THEN "Agent" END' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = :pretrip.id:
AND `pretrip`.`deleted_at` IS NULL', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Ticket/Controllers/Ticket.php(2187): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('64')
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-18 18:00:42 --> mysqli_sql_exception: Unknown column 'CASE WHEN booker.first_name IS NOT NULL THEN "Admin" WHEN booker_agents.first_name IS NOT NULL THEN "Agent" ELSE "Unknown" END' in 'SELECT' in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php(2187): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('64')
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-06-18 18:00:42 --> Unknown column 'CASE WHEN booker.first_name IS NOT NULL THEN "Admin" WHEN booker_agents.first_name IS NOT NULL THEN "Agent" ELSE "Unknown" END' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" ELSE "Unknown" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" ELSE "Unknown" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" ELSE "Unknown" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'64\'
AND `pretrip`.`deleted_at` IS NULL')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`first_name IS NOT NULL THEN "Admin" WHEN booker_agents`.`first_name IS NOT NULL THEN "Agent" ELSE "Unknown" END` as `createdByType`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = :pretrip.id:
AND `pretrip`.`deleted_at` IS NULL', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Ticket/Controllers/Ticket.php(2187): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('64')
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-18 18:02:01 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 18:02:01 --> 
ERROR - 2025-06-18 18:02:22 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 18:02:22 --> 
ERROR - 2025-06-18 18:03:36 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 18:03:36 --> 
ERROR - 2025-06-18 18:11:45 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 18:11:45 --> 
ERROR - 2025-06-18 18:14:49 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 18:14:49 --> 
ERROR - 2025-06-18 18:43:32 --> mysqli_sql_exception: Unknown column 'CASE WHEN booker.user_id IS NOT NULL THEN "Admin" WHEN booker_agents.user_id IS NOT NULL THEN "Agent" ELSE "Unknown" END' in 'SELECT' in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php(2189): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('61')
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-06-18 18:43:32 --> Unknown column 'CASE WHEN booker.user_id IS NOT NULL THEN "Admin" WHEN booker_agents.user_id IS NOT NULL THEN "Agent" ELSE "Unknown" END' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`user_id IS NOT NULL THEN "Admin" WHEN booker_agents`.`user_id IS NOT NULL THEN "Agent" ELSE "Unknown" END` AS `booked_by`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'61\'
AND `pretrip`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`user_id IS NOT NULL THEN "Admin" WHEN booker_agents`.`user_id IS NOT NULL THEN "Agent" ELSE "Unknown" END` AS `booked_by`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'61\'
AND `pretrip`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`user_id IS NOT NULL THEN "Admin" WHEN booker_agents`.`user_id IS NOT NULL THEN "Agent" ELSE "Unknown" END` AS `booked_by`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'61\'
AND `pretrip`.`deleted_at` IS NULL')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `CASE WHEN booker`.`user_id IS NOT NULL THEN "Admin" WHEN booker_agents`.`user_id IS NOT NULL THEN "Agent" ELSE "Unknown" END` AS `booked_by`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = :pretrip.id:
AND `pretrip`.`deleted_at` IS NULL', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Ticket/Controllers/Ticket.php(2189): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('61')
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-06-18 18:44:21 --> syntax error, unexpected 'Admin' (T_STRING), expecting ')'
in ROOTPATH/modules/Ticket/Controllers/Ticket.php on line 2173.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Ticket\\Controllers\\Ticket')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Ticket\\Controllers\\Ticket')
 4 [internal function]: spl_autoload_call('Modules\\Ticket\\Controllers\\Ticket')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Ticket\\Controllers\\Ticket', true)
 6 SYSTEMPATH/CodeIgniter.php(484): CodeIgniter\CodeIgniter->startController()
 7 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 8 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 9 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-18 18:45:19 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 18:45:19 --> 
ERROR - 2025-06-18 18:47:49 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 18:47:49 --> 
ERROR - 2025-06-18 19:07:56 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 19:07:56 --> 
ERROR - 2025-06-18 19:18:58 --> mysqli_sql_exception: Table 'busvalle_old_new_merge.stand' doesn't exist in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php(2189): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('61')
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#10 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#11 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#12 {main}
CRITICAL - 2025-06-18 19:18:58 --> Table 'busvalle_old_new_merge.stand' doesn't exist
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `booker`.`id` as `booker_id`, `booker_agents`.`id` as `booker_agent_id`, `pickdownstand`.`name` as `A`, `pickupstand`.`name` as `B`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `pickdrops` as `pickup` ON `pickup`.`trip_id` = `trips`.`id` AND `pickup`.`type` = 1
LEFT JOIN `stand` as `pickupstand` ON `pickupstand`.`id` = `pickup`.`stand_id`
LEFT JOIN `pickdrops` as `pickdown` ON `pickdown`.`trip_id` = `trips`.`id` AND `pickup`.`type` = 0
LEFT JOIN `stand` as `pickdownstand` ON `pickdownstand`.`id` = `pickdown`.`stand_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'61\'
AND `pretrip`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `booker`.`id` as `booker_id`, `booker_agents`.`id` as `booker_agent_id`, `pickdownstand`.`name` as `A`, `pickupstand`.`name` as `B`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `pickdrops` as `pickup` ON `pickup`.`trip_id` = `trips`.`id` AND `pickup`.`type` = 1
LEFT JOIN `stand` as `pickupstand` ON `pickupstand`.`id` = `pickup`.`stand_id`
LEFT JOIN `pickdrops` as `pickdown` ON `pickdown`.`trip_id` = `trips`.`id` AND `pickup`.`type` = 0
LEFT JOIN `stand` as `pickdownstand` ON `pickdownstand`.`id` = `pickdown`.`stand_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'61\'
AND `pretrip`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `booker`.`id` as `booker_id`, `booker_agents`.`id` as `booker_agent_id`, `pickdownstand`.`name` as `A`, `pickupstand`.`name` as `B`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `pickdrops` as `pickup` ON `pickup`.`trip_id` = `trips`.`id` AND `pickup`.`type` = 1
LEFT JOIN `stand` as `pickupstand` ON `pickupstand`.`id` = `pickup`.`stand_id`
LEFT JOIN `pickdrops` as `pickdown` ON `pickdown`.`trip_id` = `trips`.`id` AND `pickup`.`type` = 0
LEFT JOIN `stand` as `pickdownstand` ON `pickdownstand`.`id` = `pickdown`.`stand_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = \'61\'
AND `pretrip`.`deleted_at` IS NULL')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip`.`id` as `pretripId`, `pretrip`.*, `trips`.*, CONCAT(driver.first_name, "", driver.last_name) as driverName, `driver`.`phone` as `driverphone`, CONCAT(assistance.first_name, "", assistance.last_name) as assistanceName, `assistance`.`phone` as `assistancephone`, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `pretrip`.`gas_later` as `gas_later`, `pretrip`.`bus_meter` as `bus_meter`, `pretrip`.`notes` as `notes`, CONCAT(COALESCE(booker.first_name, booker_agents.first_name), " ", COALESCE(booker.last_name, booker_agents.last_name)) AS createdBy, `companies`.`name` as `company_name`, `pretrip`.`create_at` as `pretrip_created_at`, `booker`.`id` as `booker_id`, `booker_agents`.`id` as `booker_agent_id`, `pickdownstand`.`name` as `A`, `pickupstand`.`name` as `B`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
JOIN `employees` AS `driver` ON `pretrip`.`Driver_id` = `driver`.`id`
LEFT JOIN `employees` AS `assistance` ON `pretrip`.`Assistant_id` = `assistance`.`id`
JOIN `vehicles` ON `pretrip`.`bus_id` = `vehicles`.`id`
JOIN `schedules` ON `trips`.`schedule_id` = `schedules`.`id`
LEFT JOIN `user_details` as `booker` ON `pretrip`.`created_by` = `booker`.`user_id`
LEFT JOIN `agents` as `booker_agents` ON `pretrip`.`created_by` = `booker_agents`.`user_id`
LEFT JOIN `locations` as `pic_location` ON `pic_location`.`id` = `trips`.`pick_location_id`
LEFT JOIN `locations` as `drop_location` ON `drop_location`.`id` = `trips`.`drop_location_id`
LEFT JOIN `pickdrops` as `pickup` ON `pickup`.`trip_id` = `trips`.`id` AND `pickup`.`type` = 1
LEFT JOIN `stand` as `pickupstand` ON `pickupstand`.`id` = `pickup`.`stand_id`
LEFT JOIN `pickdrops` as `pickdown` ON `pickdown`.`trip_id` = `trips`.`id` AND `pickup`.`type` = 0
LEFT JOIN `stand` as `pickdownstand` ON `pickdownstand`.`id` = `pickdown`.`stand_id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `pretrip`.`id` = :pretrip.id:
AND `pretrip`.`deleted_at` IS NULL', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Ticket/Controllers/Ticket.php(2189): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->print_pretrip('61')
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
10 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
11 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
12 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-06-18 19:41:21 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 19:41:21 --> 
ERROR - 2025-06-18 19:46:14 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 19:46:14 --> 
ERROR - 2025-06-18 19:47:08 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 19:47:08 --> 
ERROR - 2025-06-18 19:52:40 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 19:52:40 --> 
ERROR - 2025-06-18 20:03:45 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 20:03:45 --> 
ERROR - 2025-06-18 20:09:59 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 20:09:59 --> 
ERROR - 2025-06-18 20:27:49 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 20:27:49 --> 
ERROR - 2025-06-18 20:39:43 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 20:39:43 --> 
ERROR - 2025-06-18 20:46:47 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 20:46:47 --> 
ERROR - 2025-06-18 21:06:15 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 21:06:15 --> 
ERROR - 2025-06-18 22:37:27 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 22:37:27 --> 
ERROR - 2025-06-18 22:55:17 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 22:55:17 --> 
ERROR - 2025-06-18 23:16:39 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-06-18 23:16:39 --> 
