ERROR - 2025-08-18 01:36:05 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 01:36:05 --> 
CRITICAL - 2025-08-18 05:52:15 --> Class 'Modules\Trip\Controllers\Api\DateTime' not found
in ROOTPATH/modules/Trip/Controllers/Api/Trip.php on line 326.
 1 SYSTEMPATH/CodeIgniter.php(932): Modules\Trip\Controllers\Api\Trip->getAllTrip()
 2 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Trip\Controllers\Api\Trip))
 3 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 4 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 5 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
CRITICAL - 2025-08-18 05:52:33 --> Class 'Modules\Trip\Controllers\Api\DateTime' not found
in ROOTPATH/modules/Trip/Controllers/Api/Trip.php on line 327.
 1 SYSTEMPATH/CodeIgniter.php(932): Modules\Trip\Controllers\Api\Trip->getAllTrip()
 2 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Trip\Controllers\Api\Trip))
 3 SYSTEMPATH/CodeIgniter.php(366): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
 4 FCPATH/index.php(65): CodeIgniter\CodeIgniter->run()
 5 ROOTPATH/index.php(2): require_once('/home/busvalle/data.busvalley.com/busvalley_new/public/index.php')
ERROR - 2025-08-18 06:59:44 --> mysqli_sql_exception: Cannot delete or update a parent row: a foreign key constraint fails (`busvalle_old_new_merge`.`cancels`, CONSTRAINT `cancels_cancel_by_foreign` FOREIGN KEY (`cancel_by`) REFERENCES `users` (`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('DELETE FROM `us...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('DELETE FROM `us...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('DELETE FROM `us...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2791): CodeIgniter\Database\BaseConnection->query('DELETE FROM `us...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(445): CodeIgniter\Database\BaseBuilder->delete()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1080): CodeIgniter\Model->doDelete(NULL, true)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Employee/Controllers/Employee.php(510): CodeIgniter\BaseModel->delete(NULL, true)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Employee\Controllers\Employee->updateRole(45)
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Employee\Controllers\Employee))
#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}
ERROR - 2025-08-18 06:59:59 --> mysqli_sql_exception: Cannot delete or update a parent row: a foreign key constraint fails (`busvalle_old_new_merge`.`cancels`, CONSTRAINT `cancels_cancel_by_foreign` FOREIGN KEY (`cancel_by`) REFERENCES `users` (`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('DELETE FROM `us...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('DELETE FROM `us...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('DELETE FROM `us...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2791): CodeIgniter\Database\BaseConnection->query('DELETE FROM `us...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(445): CodeIgniter\Database\BaseBuilder->delete()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(1080): CodeIgniter\Model->doDelete(NULL, true)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Employee/Controllers/Employee.php(510): CodeIgniter\BaseModel->delete(NULL, true)
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Employee\Controllers\Employee->updateRole(45)
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Employee\Controllers\Employee))
#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}
ERROR - 2025-08-18 09:00:10 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 09:00:10 --> 
ERROR - 2025-08-18 09:33:20 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 09:33:20 --> 
ERROR - 2025-08-18 09:40:42 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 09:40:42 --> 
ERROR - 2025-08-18 09:44:56 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 09:44:56 --> 
ERROR - 2025-08-18 10:17:51 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 10:17:51 --> 
ERROR - 2025-08-18 11:14:18 --> mysqli_sql_exception: Column 'company_id' in WHERE is ambiguous in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `agents`...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `agents`...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `agents`...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `agents`...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Account/Controllers/Payagent.php(430): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Account\Controllers\Payagent->range()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Account\Controllers\Payagent))
#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-08-18 11:14:18 --> Column 'company_id' in WHERE is ambiguous
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= \'2025-08-18 00:00:00\'
AND DATE(payagents.created_at) <= \'2025-08-30 00:00:00\'
AND   (
`agent_id` = \'20\'
OR `company_id` = \'4\'
 )
AND `payagents`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= \'2025-08-18 00:00:00\'
AND DATE(payagents.created_at) <= \'2025-08-30 00:00:00\'
AND   (
`agent_id` = \'20\'
OR `company_id` = \'4\'
 )
AND `payagents`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= \'2025-08-18 00:00:00\'
AND DATE(payagents.created_at) <= \'2025-08-30 00:00:00\'
AND   (
`agent_id` = \'20\'
OR `company_id` = \'4\'
 )
AND `payagents`.`deleted_at` IS NULL')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= :DATE(payagents.created_at):
AND DATE(payagents.created_at) <= :DATE(payagents.created_at).1:
AND   (
`agent_id` = :agent_id:
OR `company_id` = :company_id:
 )
AND `payagents`.`deleted_at` IS NULL', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Account/Controllers/Payagent.php(430): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Account\Controllers\Payagent->range()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Account\Controllers\Payagent))
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-08-18 11:43:33 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 11:43:33 --> 
ERROR - 2025-08-18 12:05:05 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 12:05:05 --> 
ERROR - 2025-08-18 12:22:18 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 12:22:18 --> 
ERROR - 2025-08-18 13:03:29 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 13:03:29 --> 
ERROR - 2025-08-18 13:05:00 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 13:05:00 --> 
ERROR - 2025-08-18 13:35:04 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 13:35:04 --> 
ERROR - 2025-08-18 13:43:08 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 13:43:08 --> 
ERROR - 2025-08-18 13:43:09 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 13:43:09 --> 
ERROR - 2025-08-18 13:45:05 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 13:45:05 --> 
ERROR - 2025-08-18 14:38:16 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 14:38:16 --> 
ERROR - 2025-08-18 14:39:37 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 14:39:37 --> 
ERROR - 2025-08-18 14:43:10 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 14:43:10 --> 
ERROR - 2025-08-18 14:43:46 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 14:43:46 --> 
ERROR - 2025-08-18 14:53:34 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 14:53:34 --> 
ERROR - 2025-08-18 15:39:21 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 15:39:21 --> 
ERROR - 2025-08-18 16:20:47 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 16:20:47 --> 
ERROR - 2025-08-18 16:41:30 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 16:41:30 --> 
ERROR - 2025-08-18 16:47:23 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 16:47:23 --> 
ERROR - 2025-08-18 17:01:38 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 17:01:38 --> 
ERROR - 2025-08-18 17:22:39 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 17:22:39 --> 
ERROR - 2025-08-18 17:35:13 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 17:35:13 --> 
ERROR - 2025-08-18 18:59:31 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 18:59:31 --> 
ERROR - 2025-08-18 19:15:52 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 19:15:52 --> 
ERROR - 2025-08-18 19:59:57 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 19:59:57 --> 
ERROR - 2025-08-18 20:12:30 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 20:12:30 --> 
ERROR - 2025-08-18 21:37:51 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 21:37:51 --> 
ERROR - 2025-08-18 22:42:04 --> mysqli_sql_exception: Column 'company_id' in WHERE is ambiguous in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `agents`...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `agents`...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `agents`...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `agents`...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Account/Controllers/Payagent.php(430): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Account\Controllers\Payagent->range()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Account\Controllers\Payagent))
#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-08-18 22:42:04 --> Column 'company_id' in WHERE is ambiguous
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= \'2025-08-01 00:00:00\'
AND DATE(payagents.created_at) <= \'2025-08-17 00:00:00\'
AND   (
`agent_id` = \'16\'
OR `company_id` = \'3,4,5\'
 )
AND `payagents`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= \'2025-08-01 00:00:00\'
AND DATE(payagents.created_at) <= \'2025-08-17 00:00:00\'
AND   (
`agent_id` = \'16\'
OR `company_id` = \'3,4,5\'
 )
AND `payagents`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= \'2025-08-01 00:00:00\'
AND DATE(payagents.created_at) <= \'2025-08-17 00:00:00\'
AND   (
`agent_id` = \'16\'
OR `company_id` = \'3,4,5\'
 )
AND `payagents`.`deleted_at` IS NULL')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= :DATE(payagents.created_at):
AND DATE(payagents.created_at) <= :DATE(payagents.created_at).1:
AND   (
`agent_id` = :agent_id:
OR `company_id` = :company_id:
 )
AND `payagents`.`deleted_at` IS NULL', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Account/Controllers/Payagent.php(430): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Account\Controllers\Payagent->range()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Account\Controllers\Payagent))
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-08-18 22:42:23 --> mysqli_sql_exception: Column 'company_id' in WHERE is ambiguous in /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:295
Stack trace:
#0 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `agents`...', 0)
#1 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `agents`...')
#2 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `agents`...')
#3 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `agents`...', Array, false)
#4 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
#5 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
#6 /home/busvalle/data.busvalley.com/busvalley_new/modules/Account/Controllers/Payagent.php(430): CodeIgniter\BaseModel->findAll()
#7 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(932): Modules\Account\Controllers\Payagent->range()
#8 /home/busvalle/data.busvalley.com/busvalley_new/vendor/codeigniter4/framework/system/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Account\Controllers\Payagent))
#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-08-18 22:42:23 --> Column 'company_id' in WHERE is ambiguous
in SYSTEMPATH/Database/MySQLi/Connection.php on line 295.
 1 SYSTEMPATH/Database/MySQLi/Connection.php(295): mysqli->query('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= \'2025-08-01 00:00:00\'
AND DATE(payagents.created_at) <= \'2025-08-17 00:00:00\'
AND   (
`agent_id` = \'16\'
OR `company_id` = \'3,4,5\'
 )
AND `payagents`.`deleted_at` IS NULL', 0)
 2 SYSTEMPATH/Database/BaseConnection.php(692): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= \'2025-08-01 00:00:00\'
AND DATE(payagents.created_at) <= \'2025-08-17 00:00:00\'
AND   (
`agent_id` = \'16\'
OR `company_id` = \'3,4,5\'
 )
AND `payagents`.`deleted_at` IS NULL')
 3 SYSTEMPATH/Database/BaseConnection.php(606): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= \'2025-08-01 00:00:00\'
AND DATE(payagents.created_at) <= \'2025-08-17 00:00:00\'
AND   (
`agent_id` = \'16\'
OR `company_id` = \'3,4,5\'
 )
AND `payagents`.`deleted_at` IS NULL')
 4 SYSTEMPATH/Database/BaseBuilder.php(1616): CodeIgniter\Database\BaseConnection->query('SELECT `agents`.`id` as `agentId`, `agents`.*, `payagents`.*, `companies`.`name` AS `company_name`, concat(user_details.first_name, " ", user_details.last_name) AS approved_by
FROM `payagents`
LEFT JOIN `agents` ON `agents`.`id` = `payagents`.`agent_id`
LEFT JOIN `companies` ON `companies`.`id` = `payagents`.`company_id`
LEFT JOIN `user_details` ON `user_details`.`user_id` = `payagents`.`approved_id`
WHERE DATE(payagents.created_at) >= :DATE(payagents.created_at):
AND DATE(payagents.created_at) <= :DATE(payagents.created_at).1:
AND   (
`agent_id` = :agent_id:
OR `company_id` = :company_id:
 )
AND `payagents`.`deleted_at` IS NULL', [...], false)
 5 SYSTEMPATH/Model.php(237): CodeIgniter\Database\BaseBuilder->get()
 6 SYSTEMPATH/BaseModel.php(624): CodeIgniter\Model->doFindAll(0, 0)
 7 ROOTPATH/modules/Account/Controllers/Payagent.php(430): CodeIgniter\BaseModel->findAll()
 8 SYSTEMPATH/CodeIgniter.php(932): Modules\Account\Controllers\Payagent->range()
 9 SYSTEMPATH/CodeIgniter.php(497): CodeIgniter\CodeIgniter->runController(Object(Modules\Account\Controllers\Payagent))
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-08-18 23:12:10 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 23:12:10 --> 
ERROR - 2025-08-18 23:57:58 --> Email: Unable to send email using PHP mail(). Your server might not be configured to send mail using this method.
ERROR - 2025-08-18 23:57:58 --> 
