ERROR - 2025-11-21 00:19:46 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 00:19:46 --> 
CRITICAL - 2025-11-21 03:44:52 --> Undefined variable: item
in ROOTPATH/modules/Trip/Controllers/Api/Trip.php on line 461.
 1 ROOTPATH/modules/Trip/Controllers/Api/Trip.php(461): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: item', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Trip/Controllers/Api/Trip.php', 461, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Trip\Controllers\Api\Trip->getAllTrip()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Trip\Controllers\Api\Trip))
 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-11-21 03:51:27 --> Undefined property: stdClass::$adult_fare
in ROOTPATH/modules/Trip/Controllers/Api/Trip.php on line 437.
 1 ROOTPATH/modules/Trip/Controllers/Api/Trip.php(437): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: stdClass::$adult_fare', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Trip/Controllers/Api/Trip.php', 437, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Trip\Controllers\Api\Trip->getAllTrip()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Trip\Controllers\Api\Trip))
 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-11-21 03:51:46 --> Undefined property: stdClass::$adult_fare
in ROOTPATH/modules/Trip/Controllers/Api/Trip.php on line 437.
 1 ROOTPATH/modules/Trip/Controllers/Api/Trip.php(437): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined property: stdClass::$adult_fare', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Trip/Controllers/Api/Trip.php', 437, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Trip\Controllers\Api\Trip->getAllTrip()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Trip\Controllers\Api\Trip))
 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-11-21 03:56:18 --> Undefined variable: item
in ROOTPATH/modules/Trip/Controllers/Api/Trip.php on line 457.
 1 ROOTPATH/modules/Trip/Controllers/Api/Trip.php(457): CodeIgniter\Debug\Exceptions->errorHandler(8, 'Undefined variable: item', '/home/busvalle/data.busvalley.com/busvalley_new/modules/Trip/Controllers/Api/Trip.php', 457, [...])
 2 SYSTEMPATH/CodeIgniter.php(932): Modules\Trip\Controllers\Api\Trip->getAllTrip()
 3 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Trip\Controllers\Api\Trip))
 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-11-21 09:24:30 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 09:24:30 --> 
ERROR - 2025-11-21 11:14:01 --> Error connecting to the database: mysqli_sql_exception: No such file or directory in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:174
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(174): mysqli->real_connect('localhost', 'busvalle_harshc...', 'Harsh123$$&', 'busvalle_old_ne...', 3306, '', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(391): CodeIgniter\Database\MySQLi\Connection->connect(false)
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize()
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT *\nFROM `...', 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/app/Commands/SendScheduledNotifications.php(85): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CLI/Commands.php(65): App\Commands\SendScheduledNotifications->run(Array)
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CLI/Console.php(37): CodeIgniter\CLI\Commands->run('notifications:s...', Array)
#9 /home/busvalle/data.busvalley.com/busvalley_new/spark(97): CodeIgniter\CLI\Console->run()
#10 {main}

Next CodeIgniter\Database\Exceptions\DatabaseException: No such file or directory in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:218
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(391): CodeIgniter\Database\MySQLi\Connection->connect(false)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize()
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT *\nFROM `...', Array, false)
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#5 /home/busvalle/data.busvalley.com/busvalley_new/app/Commands/SendScheduledNotifications.php(85): CodeIgniter\BaseModel->findAll()
#6 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CLI/Commands.php(65): App\Commands\SendScheduledNotifications->run(Array)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CLI/Console.php(37): CodeIgniter\CLI\Commands->run('notifications:s...', Array)
#8 /home/busvalle/data.busvalley.com/busvalley_new/spark(97): CodeIgniter\CLI\Console->run()
#9 {main}
CRITICAL - 2025-11-21 11:14:01 --> Unable to connect to the database.
Main connection [MySQLi]: No such file or directory
in SYSTEMPATH/Database/BaseConnection.php on line 427.
 1 SYSTEMPATH/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize()
 2 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT *
FROM `notifications`
WHERE `status` = :status:
AND `notification_date` <= :notification_date:', [...], false)
 3 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 4 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 5 APPPATH/Commands/SendScheduledNotifications.php(85): CodeIgniter\BaseModel->findAll()
 6 SYSTEMPATH/CLI/Commands.php(65): App\Commands\SendScheduledNotifications->run([])
 7 SYSTEMPATH/CLI/Console.php(37): CodeIgniter\CLI\Commands->run('notifications:send', [])
 8 ROOTPATH/spark(97): CodeIgniter\CLI\Console->run()
ERROR - 2025-11-21 11:14:04 --> Error connecting to the database: mysqli_sql_exception: No such file or directory in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:174
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(174): mysqli->real_connect('localhost', 'busvalle_harshc...', 'Harsh123$$&', 'busvalle_old_ne...', 3306, '', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(391): CodeIgniter\Database\MySQLi\Connection->connect(false)
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize()
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `id`, `m...', 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/app/Libraries/Rolepermission.php(36): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/app/Libraries/Rolepermission.php(26): App\Libraries\Rolepermission->buildMenuChart()
#8 /home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php(2795): App\Libraries\Rolepermission->__construct()
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->allbookinglist()
#10 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
#11 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#12 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#13 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#14 {main}

Next CodeIgniter\Database\Exceptions\DatabaseException: No such file or directory in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:218
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(391): CodeIgniter\Database\MySQLi\Connection->connect(false)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize()
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `id`, `m...', Array, false)
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#5 /home/busvalle/data.busvalley.com/busvalley_new/app/Libraries/Rolepermission.php(36): CodeIgniter\BaseModel->findAll()
#6 /home/busvalle/data.busvalley.com/busvalley_new/app/Libraries/Rolepermission.php(26): App\Libraries\Rolepermission->buildMenuChart()
#7 /home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php(2795): App\Libraries\Rolepermission->__construct()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->allbookinglist()
#9 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
#10 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#11 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#12 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#13 {main}
CRITICAL - 2025-11-21 11:14:04 --> Unable to connect to the database.
Main connection [MySQLi]: No such file or directory
in SYSTEMPATH/Database/BaseConnection.php on line 427.
 1 SYSTEMPATH/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize()
 2 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `id`, `menu_title`, `parent_menu_id`, `have_chield`
FROM `menus`
WHERE `menus`.`deleted_at` IS NULL', [], false)
 3 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 4 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 5 APPPATH/Libraries/Rolepermission.php(36): CodeIgniter\BaseModel->findAll()
 6 APPPATH/Libraries/Rolepermission.php(26): App\Libraries\Rolepermission->buildMenuChart()
 7 ROOTPATH/modules/Ticket/Controllers/Ticket.php(2795): App\Libraries\Rolepermission->__construct()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->allbookinglist()
 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-11-21 11:14:10 --> Error connecting to the database: mysqli_sql_exception: No such file or directory in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:174
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(174): mysqli->real_connect('localhost', 'busvalle_harshc...', 'Harsh123$$&', 'busvalle_old_ne...', 3306, '', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(391): CodeIgniter\Database\MySQLi\Connection->connect(false)
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize()
#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(4614): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->pre_trip_list()
#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}

Next CodeIgniter\Database\Exceptions\DatabaseException: No such file or directory in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:218
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(391): CodeIgniter\Database\MySQLi\Connection->connect(false)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize()
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `pretrip...', Array, false)
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#5 /home/busvalle/data.busvalley.com/busvalley_new/modules/Ticket/Controllers/Ticket.php(4614): CodeIgniter\BaseModel->findAll()
#6 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->pre_trip_list()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#9 /home/busvalle/data.busvalley.com/busvalley_new/public/index.php(65): CodeIgniter\CodeIgniter->run()
#10 /home/busvalle/data.busvalley.com/busvalley_new/index.php(2): require_once('/home/busvalle/...')
#11 {main}
CRITICAL - 2025-11-21 11:14:10 --> Unable to connect to the database.
Main connection [MySQLi]: No such file or directory
in SYSTEMPATH/Database/BaseConnection.php on line 427.
 1 SYSTEMPATH/Database/BaseConnection.php(574): CodeIgniter\Database\BaseConnection->initialize()
 2 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, CONCAT(assistance.first_name, " ", assistance.last_name) as assistanceName, `vehicles`.*, `schedules`.*, `pic_location`.`name` as `pic_location_name`, `drop_location`.`name` as `drop_location_name`, `companies`.`name` as `company`, `pretrip`.`create_at` as `pretrip_create`, CONCAT(COALESCE(booker.first_name, `booker_agents`.`first_name`, booker_agents_emp.first_name), " ", COALESCE(booker.last_name, `booker_agents`.`last_name`, booker_agents_emp.last_name)) AS createdBy, `schedules`.`start_time` as `schedule_time`, `pretrip`.`updated_at` as `updatedAt`
FROM `pretrip`
JOIN `trips` ON `pretrip`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `companies`.`id` = `trips`.`company_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 `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 `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 `users` ON `users`.`id` = `pretrip`.`created_by`
LEFT JOIN `employees` AS `booker_agents_emp` ON `booker_agents_emp`.`email` = `users`.`login_email`
WHERE `pretrip`.`deleted_at` IS NULL', [], false)
 3 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 4 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 5 ROOTPATH/modules/Ticket/Controllers/Ticket.php(4614): CodeIgniter\BaseModel->findAll()
 6 SYSTEMPATH/CodeIgniter.php(932): Modules\Ticket\Controllers\Ticket->pre_trip_list()
 7 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Ticket\Controllers\Ticket))
 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')
ERROR - 2025-11-21 12:39:23 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 12:39:23 --> 
ERROR - 2025-11-21 12:59:51 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 12:59:51 --> 
ERROR - 2025-11-21 13:23:50 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 13:23:50 --> 
ERROR - 2025-11-21 13:44:41 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 13:44:41 --> 
ERROR - 2025-11-21 14:00:08 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 14:00:08 --> 
ERROR - 2025-11-21 14:36:25 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 14:36:25 --> 
ERROR - 2025-11-21 15:22:44 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 15:22:44 --> 
ERROR - 2025-11-21 15:28:41 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 15:28:41 --> 
ERROR - 2025-11-21 16:34:23 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 16:34:23 --> 
ERROR - 2025-11-21 17:15:21 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 17:15:21 --> 
ERROR - 2025-11-21 18:02:08 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 18:02:08 --> 
ERROR - 2025-11-21 18:25:13 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 18:25:13 --> 
ERROR - 2025-11-21 19:05:27 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 19:05:27 --> 
ERROR - 2025-11-21 19:19:10 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 19:19:10 --> 
ERROR - 2025-11-21 20:10:52 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 20:10:52 --> 
ERROR - 2025-11-21 20:15:59 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:15:59 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:16:20 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:16:20 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:16:26 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:16:26 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:16:35 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:16:35 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:16:37 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:16:37 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:17:49 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:17:49 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:17:56 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 20:17:56 --> 
ERROR - 2025-11-21 20:18:04 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:18:04 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:18:12 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:18:12 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:18:16 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:18:16 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:18:22 --> unlink(/home/busvalle/data.busvalley.com/busvalley_new/writable/debugbar/debugbar_1763748822.765955.json): No such file or directory
in SYSTEMPATH/Debug/Toolbar/Collectors/History.php on line 78.
 1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'unlink(/home/busvalle/data.busvalley.com/busvalley_new/writable/debugbar/debugbar_1763748822.765955.json): No such file or directory', '/home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Debug/Toolbar/Collectors/History.php', 78, [...])
 2 SYSTEMPATH/Debug/Toolbar/Collectors/History.php(78): unlink('/home/busvalle/data.busvalley.com/busvalley_new/writable/debugbar/debugbar_1763748822.765955.json')
 3 SYSTEMPATH/Debug/Toolbar.php(502): CodeIgniter\Debug\Toolbar\Collectors\History->setFiles('1763749101.481486', 20)
 4 SYSTEMPATH/Debug/Toolbar.php(479): CodeIgniter\Debug\Toolbar->format([...], 'html')
 5 APPPATH/Config/Events.php(52): CodeIgniter\Debug\Toolbar->respond()
 6 SYSTEMPATH/Events/Events.php(152): CodeIgniter\Events\Events::Config\{closure}()
 7 SYSTEMPATH/CodeIgniter.php(348): CodeIgniter\Events\Events::trigger('pre_system')
 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')
CRITICAL - 2025-11-21 20:19:54 --> syntax error, unexpected '')
' (T_CONSTANT_ENCAPSED_STRING), expecting ')'
in ROOTPATH/modules/Passanger/Controllers/Passanger.php on line 100.
 1 SYSTEMPATH/Autoloader/Autoloader.php(291): CodeIgniter\Autoloader\Autoloader->includeFile('/home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php')
 2 SYSTEMPATH/Autoloader/Autoloader.php(269): CodeIgniter\Autoloader\Autoloader->loadInNamespace('Modules\\Passanger\\Controllers\\Passanger')
 3 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('Modules\\Passanger\\Controllers\\Passanger')
 4 [internal function]: spl_autoload_call('Modules\\Passanger\\Controllers\\Passanger')
 5 SYSTEMPATH/CodeIgniter.php(890): class_exists('\\Modules\\Passanger\\Controllers\\Passanger', 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-11-21 20:20:21 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:20:21 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`, `tickets`.`id` as `ticketID`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `ticketID`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`, `tickets`.`id` as `ticketID`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `ticketID`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`, `tickets`.`id` as `ticketID`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `ticketID`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`, `tickets`.`id` as `ticketID`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `ticketID`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:22:30 --> mysqli_sql_exception: Unknown column 'user_details.gender' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(143): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:22:30 --> Unknown column 'user_details.gender' in 'SELECT'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` AS `user_id`, `users`.`login_email`, `users`.`login_mobile`, `users`.`role_id`, `user_details`.`id` AS `user_detail_id`, `user_details`.`first_name`, `user_details`.`last_name`, `user_details`.`gender`, `user_details`.`address`, `user_details`.`company_id`, `companies`.`id` AS `company_id`, `companies`.`name` AS `company_name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `ticketID`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` AS `user_id`, `users`.`login_email`, `users`.`login_mobile`, `users`.`role_id`, `user_details`.`id` AS `user_detail_id`, `user_details`.`first_name`, `user_details`.`last_name`, `user_details`.`gender`, `user_details`.`address`, `user_details`.`company_id`, `companies`.`id` AS `company_id`, `companies`.`name` AS `company_name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `ticketID`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` AS `user_id`, `users`.`login_email`, `users`.`login_mobile`, `users`.`role_id`, `user_details`.`id` AS `user_detail_id`, `user_details`.`first_name`, `user_details`.`last_name`, `user_details`.`gender`, `user_details`.`address`, `user_details`.`company_id`, `companies`.`id` AS `company_id`, `companies`.`name` AS `company_name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `ticketID`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` AS `user_id`, `users`.`login_email`, `users`.`login_mobile`, `users`.`role_id`, `user_details`.`id` AS `user_detail_id`, `user_details`.`first_name`, `user_details`.`last_name`, `user_details`.`gender`, `user_details`.`address`, `user_details`.`company_id`, `companies`.`id` AS `company_id`, `companies`.`name` AS `company_name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `ticketID`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(143): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:24:01 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:24:01 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:24:27 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:24:27 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:24:29 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:24:29 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:32:21 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 20:32:21 --> 
ERROR - 2025-11-21 20:34:07 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:34:07 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `tickets`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:35:00 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 20:35:00 --> 
ERROR - 2025-11-21 20:40:31 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 20:40:31 --> 
ERROR - 2025-11-21 20:45:31 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:45:31 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:46:56 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:46:56 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(126): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:48:19 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(196): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:48:19 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name` as `company_name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name` as `company_name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name` as `company_name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name` as `company_name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
GROUP BY `users`.`id`
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(196): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 20:51:08 --> mysqli_sql_exception: Duplicate column name 'id' 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 COUNT(*)...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
#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-11-21 20:51:08 --> Duplicate column name 'id'
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT DISTINCT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
) CI_count_all_results', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*) AS `numrows`
FROM (
SELECT DISTINCT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
) CI_count_all_results')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*) AS `numrows`
FROM (
SELECT DISTINCT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = 3
AND   (
`user_details`.`first_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_email` LIKE \'%ad5828182%\' ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE \'%ad5828182%\' ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
) CI_count_all_results')
 4 SYSTEMPATH/Database/BaseBuilder.php(1700): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*) AS `numrows`
FROM (
SELECT DISTINCT `users`.`id` as `user_id`, `users`.*, `user_details`.*, `companies`.`name`
FROM `users`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `users`.`id`
LEFT JOIN `tickets` ON `tickets`.`passanger_id` = `user_details`.`user_id`
LEFT JOIN `trips` ON `tickets`.`trip_id` = `trips`.`id`
LEFT JOIN `companies` ON `trips`.`company_id` = `companies`.`id`
WHERE `role_id` = :role_id:
AND   (
`user_details`.`first_name` LIKE :user_details.first_name: ESCAPE \'!\'
OR  `user_details`.`last_name` LIKE :user_details.last_name: ESCAPE \'!\'
OR  `users`.`login_email` LIKE :users.login_email: ESCAPE \'!\'
OR  `users`.`login_mobile` LIKE :users.login_mobile: ESCAPE \'!\'
 )
AND `users`.`deleted_at` IS NULL
) CI_count_all_results', [...], false)
 5 SYSTEMPATH/Model.php(599): CodeIgniter\Database\BaseBuilder->countAllResults(false)
 6 SYSTEMPATH/BaseModel.php(1203): CodeIgniter\Model->countAllResults(false)
 7 ROOTPATH/modules/Passanger/Controllers/Passanger.php(124): CodeIgniter\BaseModel->paginate(50)
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Passanger\Controllers\Passanger->index()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Passanger\Controllers\Passanger))
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-11-21 21:13:46 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 21:13:46 --> 
ERROR - 2025-11-21 21:14:43 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 21:14:43 --> 
ERROR - 2025-11-21 21:41:55 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 21:41:55 --> 
ERROR - 2025-11-21 22:17:48 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 22:17:48 --> 
ERROR - 2025-11-21 23:05:35 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 23:05:35 --> 
ERROR - 2025-11-21 23:19:42 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-11-21 23:19:42 --> 
