[2026-03-30 12:37:49] production.INFO: Employee creation request received: {"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null} [2026-03-30 12:37:49] production.INFO: Employee creation request received: {"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null} [2026-03-30 12:37:49] production.INFO: Validation passed: {"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null} [2026-03-30 12:37:49] production.INFO: === START Employee Creation === [2026-03-30 12:37:49] production.INFO: Received data: {"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null} [2026-03-30 12:37:49] production.INFO: Generated next id: {"next_id":9} [2026-03-30 12:37:49] production.INFO: Validation passed: {"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null} [2026-03-30 12:37:49] production.INFO: Generated user_id: {"user_id":"6908698"} [2026-03-30 12:37:49] production.INFO: === START Employee Creation === [2026-03-30 12:37:49] production.INFO: Received data: {"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null} [2026-03-30 12:37:49] production.INFO: Generated next id: {"next_id":9} [2026-03-30 12:37:49] production.INFO: Generated user_id: {"user_id":"9592038"} [2026-03-30 12:37:49] production.INFO: Creating user with data: {"id":9,"user_id":"9592038","username":"luswenyomfenyj@gmail.com","email":"luswenyomfenyj@gmail.com","password":"$2y$12$9elIzH2gar8Icptx9Ai7JOWv.idT6yrQGMlMFiUCVH4M8fUpKvjU2","status":"active"} [2026-03-30 12:37:49] production.INFO: User created successfully: {"user_id":"9592038","id":9} [2026-03-30 12:37:49] production.INFO: Generating employee ID... [2026-03-30 12:37:49] production.INFO: Creating user with data: {"id":9,"user_id":"6908698","username":"luswenyomfenyj@gmail.com","email":"luswenyomfenyj@gmail.com","password":"$2y$12$uyfRie5Bir2dbnS71Z5SVeWbdYLhniFl.zeLAUaI8LqyJlIly2cwa","status":"active"} [2026-03-30 12:37:49] production.INFO: Generated employee_id: {"employee_id":"EMP0000005"} [2026-03-30 12:37:49] production.INFO: Status mapping: {"frontend_status":"Active","mapped_status":"active"} [2026-03-30 12:37:49] production.INFO: Creating employee with data: {"employee_id":"EMP0000005","user_id":"9592038","first_name":"Luswenyo","last_name":"Mafenye","job_title":"jjh","department":"hvvh","hire_date":"2026-03-30","phone_number":null,"status":"active","id_number":"ID-73894347-2648"} [2026-03-30 12:37:49] production.ERROR: === Employee Creation FAILED === [2026-03-30 12:37:49] production.ERROR: Error message: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'luswenyomfenyj@gmail.com' for key 'users_username_unique' (Connection: mysql, SQL: insert into `users` (`id`, `user_id`, `username`, `email`, `password`, `status`, `updated_at`, `created_at`) values (9, 6908698, luswenyomfenyj@gmail.com, luswenyomfenyj@gmail.com, $2y$12$uyfRie5Bir2dbnS71Z5SVeWbdYLhniFl.zeLAUaI8LqyJlIly2cwa, active, 2026-03-30 12:37:49, 2026-03-30 12:37:49))"} [2026-03-30 12:37:49] production.ERROR: Error trace: {"trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(288): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}"} [2026-03-30 12:37:49] production.ERROR: Data at time of error: {"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null} [2026-03-30 12:37:49] production.ERROR: === Employee Creation FAILED === [2026-03-30 12:37:49] production.ERROR: Error message: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'phone_number' cannot be null (Connection: mysql, SQL: insert into `employees` (`employee_id`, `user_id`, `first_name`, `last_name`, `job_title`, `department`, `hire_date`, `phone_number`, `status`, `id_number`, `updated_at`, `created_at`) values (EMP0000005, 9592038, Luswenyo, Mafenye, jjh, hvvh, 2026-03-30 00:00:00, ?, active, ID-73894347-2648, 2026-03-30 12:37:49, 2026-03-30 12:37:49))"} [2026-03-30 12:37:49] production.ERROR: === Transaction ROLLED BACK === [2026-03-30 12:37:49] production.ERROR: Error trace: {"trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(317): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}"} [2026-03-30 12:37:49] production.ERROR: Data at time of error: {"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null} [2026-03-30 12:37:49] production.ERROR: Employee creation exception: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'luswenyomfenyj@gmail.com' for key 'users_username_unique' (Connection: mysql, SQL: insert into `users` (`id`, `user_id`, `username`, `email`, `password`, `status`, `updated_at`, `created_at`) values (9, 6908698, luswenyomfenyj@gmail.com, luswenyomfenyj@gmail.com, $2y$12$uyfRie5Bir2dbnS71Z5SVeWbdYLhniFl.zeLAUaI8LqyJlIly2cwa, active, 2026-03-30 12:37:49, 2026-03-30 12:37:49))","trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(288): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}","request":{"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null}} [2026-03-30 12:37:49] production.ERROR: === Transaction ROLLED BACK === [2026-03-30 12:37:49] production.ERROR: Employee creation exception: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'phone_number' cannot be null (Connection: mysql, SQL: insert into `employees` (`employee_id`, `user_id`, `first_name`, `last_name`, `job_title`, `department`, `hire_date`, `phone_number`, `status`, `id_number`, `updated_at`, `created_at`) values (EMP0000005, 9592038, Luswenyo, Mafenye, jjh, hvvh, 2026-03-30 00:00:00, ?, active, ID-73894347-2648, 2026-03-30 12:37:49, 2026-03-30 12:37:49))","trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(317): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}","request":{"first_name":"Luswenyo","last_name":"Mafenye","email":"luswenyomfenyj@gmail.com","id_number":"ID-73894347-2648","position":"jjh","department":"hvvh","status":"Active","hire_date":"2026-03-30","phone_number":null}} [2026-03-30 12:43:36] production.INFO: Employee creation request received: {"first_name":"Ujamaa","last_name":"Nampweya","email":"unampweya@kestechtraining.com","id_number":"02081600277","position":"Administrative officer","department":"administration","status":"Active","hire_date":"2026-03-16","phone_number":"0814885796"} [2026-03-30 12:43:36] production.INFO: Employee creation request received: {"first_name":"Ujamaa","last_name":"Nampweya","email":"unampweya@kestechtraining.com","id_number":"02081600277","position":"Administrative officer","department":"administration","status":"Active","hire_date":"2026-03-16","phone_number":"0814885796"} [2026-03-30 12:43:36] production.INFO: Validation passed: {"first_name":"Ujamaa","last_name":"Nampweya","email":"unampweya@kestechtraining.com","id_number":"02081600277","position":"Administrative officer","department":"administration","status":"Active","hire_date":"2026-03-16","phone_number":"0814885796"} [2026-03-30 12:43:36] production.INFO: Validation passed: {"first_name":"Ujamaa","last_name":"Nampweya","email":"unampweya@kestechtraining.com","id_number":"02081600277","position":"Administrative officer","department":"administration","status":"Active","hire_date":"2026-03-16","phone_number":"0814885796"} [2026-03-30 12:43:36] production.INFO: === START Employee Creation === [2026-03-30 12:43:36] production.INFO: === START Employee Creation === [2026-03-30 12:43:36] production.INFO: Received data: {"first_name":"Ujamaa","last_name":"Nampweya","email":"unampweya@kestechtraining.com","id_number":"02081600277","position":"Administrative officer","department":"administration","status":"Active","hire_date":"2026-03-16","phone_number":"0814885796"} [2026-03-30 12:43:36] production.INFO: Received data: {"first_name":"Ujamaa","last_name":"Nampweya","email":"unampweya@kestechtraining.com","id_number":"02081600277","position":"Administrative officer","department":"administration","status":"Active","hire_date":"2026-03-16","phone_number":"0814885796"} [2026-03-30 12:43:36] production.INFO: Generated next id: {"next_id":10} [2026-03-30 12:43:36] production.INFO: Generated next id: {"next_id":10} [2026-03-30 12:43:36] production.INFO: Generated user_id: {"user_id":"7176001"} [2026-03-30 12:43:36] production.INFO: Generated user_id: {"user_id":"6040818"} [2026-03-30 12:43:36] production.INFO: Creating user with data: {"id":10,"user_id":"7176001","username":"unampweya@kestechtraining.com","email":"unampweya@kestechtraining.com","password":"$2y$12$qPdPQ6YHO9rQW21j1UX5vu6EhOwMsCsfiR7aVeG50k/Hq26H3fkcO","status":"active"} [2026-03-30 12:43:36] production.INFO: Creating user with data: {"id":10,"user_id":"6040818","username":"unampweya@kestechtraining.com","email":"unampweya@kestechtraining.com","password":"$2y$12$tuwhgd8GAjl7Bs7cs8.ewe2D5.kZf58JuFEJTunJqBM0Wb5xmoU.W","status":"active"} [2026-03-30 12:43:36] production.INFO: User created successfully: {"user_id":"7176001","id":10} [2026-03-30 12:43:36] production.INFO: Generating employee ID... [2026-03-30 12:43:36] production.ERROR: === Employee Creation FAILED === [2026-03-30 12:43:36] production.ERROR: Error message: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'unampweya@kestechtraining.com' for key 'users_username_unique' (Connection: mysql, SQL: insert into `users` (`id`, `user_id`, `username`, `email`, `password`, `status`, `updated_at`, `created_at`) values (10, 6040818, unampweya@kestechtraining.com, unampweya@kestechtraining.com, $2y$12$tuwhgd8GAjl7Bs7cs8.ewe2D5.kZf58JuFEJTunJqBM0Wb5xmoU.W, active, 2026-03-30 12:43:36, 2026-03-30 12:43:36))"} [2026-03-30 12:43:36] production.INFO: Generated employee_id: {"employee_id":"EMP0000005"} [2026-03-30 12:43:36] production.ERROR: Error trace: {"trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(288): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}"} [2026-03-30 12:43:36] production.INFO: Status mapping: {"frontend_status":"Active","mapped_status":"active"} [2026-03-30 12:43:36] production.ERROR: Data at time of error: {"first_name":"Ujamaa","last_name":"Nampweya","email":"unampweya@kestechtraining.com","id_number":"02081600277","position":"Administrative officer","department":"administration","status":"Active","hire_date":"2026-03-16","phone_number":"0814885796"} [2026-03-30 12:43:36] production.INFO: Creating employee with data: {"employee_id":"EMP0000005","user_id":"7176001","first_name":"Ujamaa","last_name":"Nampweya","job_title":"Administrative officer","department":"administration","hire_date":"2026-03-16","phone_number":"0814885796","status":"active","id_number":"02081600277"} [2026-03-30 12:43:36] production.ERROR: === Transaction ROLLED BACK === [2026-03-30 12:43:36] production.ERROR: Employee creation exception: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'unampweya@kestechtraining.com' for key 'users_username_unique' (Connection: mysql, SQL: insert into `users` (`id`, `user_id`, `username`, `email`, `password`, `status`, `updated_at`, `created_at`) values (10, 6040818, unampweya@kestechtraining.com, unampweya@kestechtraining.com, $2y$12$tuwhgd8GAjl7Bs7cs8.ewe2D5.kZf58JuFEJTunJqBM0Wb5xmoU.W, active, 2026-03-30 12:43:36, 2026-03-30 12:43:36))","trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(288): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}","request":{"first_name":"Ujamaa","last_name":"Nampweya","email":"unampweya@kestechtraining.com","id_number":"02081600277","position":"Administrative officer","department":"administration","status":"Active","hire_date":"2026-03-16","phone_number":"0814885796"}} [2026-03-30 12:43:36] production.INFO: Employee created successfully: {"employee_id":"EMP0000005"} [2026-03-30 12:43:36] production.INFO: === Transaction COMMITTED === [2026-03-30 12:43:36] production.INFO: === END Employee Creation - Success === [2026-03-30 12:48:54] production.INFO: AccessControlController: employees() called {"current_user_id":"4918349","current_username":"mluswenyo@kestechtraining.com"} [2026-03-30 12:48:54] production.INFO: Employee counts {"total":4,"same_user_as_current":1} [2026-03-30 12:48:54] production.INFO: Current user employee found {"employee_id":"EMP0000001","name":"Mafenyeho Luswenyo"} [2026-03-30 12:48:54] production.INFO: Generated SQL {"sql":"select `employee_id`, `user_id`, `first_name`, `last_name`, `phone_number`, `id_number`, `department`, `job_title`, `hire_date` from `employees` where `employee_id` != ? and `user_id` is not null","bindings":["EMP0000001"]} [2026-03-30 12:48:54] production.INFO: Employees found {"count":3} [2026-03-30 12:48:54] production.INFO: First 3 employees formatted {"employees":[{"employee_id":"EMP0000004","user_id":"9336210","first_name":"Finnias","last_name":"Sikeba","full_name":"Finnias Sikeba","email":"fsikeba@kestechtraining.com","username":"fsikeba@kestechtraining.com","phone_number":"0816758807","id_number":"90031300928","department":"Electrical","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000004"},{"employee_id":"EMP0000003","user_id":"4753912","first_name":"Lukas","last_name":"Mateus","full_name":"Lukas Mateus","email":"lmateus@kestechtraining.com","username":"lmateus@kestechtraining.com","phone_number":"0816457784","id_number":"02070200868","department":"Solar","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000003"},{"employee_id":"EMP0000005","user_id":"7176001","first_name":"Ujamaa","last_name":"Nampweya","full_name":"Ujamaa Nampweya","email":"unampweya@kestechtraining.com","username":"unampweya@kestechtraining.com","phone_number":"0814885796","id_number":"02081600277","department":"administration","job_title":"Administrative officer","hire_date":"2026-03-16 00:00:00","employee_number":"EMP0000005"}]} [2026-03-30 12:50:10] production.INFO: Employee password reset {"employee_id":"EMP0000005","user_id":"7176001","reset_by":"4918349"} [2026-03-30 12:50:14] production.INFO: Employee status updated {"employee_id":"EMP0000005","user_id":"7176001","old_status":"Active","new_status":"active","updated_by":"4918349"} [2026-03-30 12:52:03] production.INFO: Employee creation request received: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null} [2026-03-30 12:52:03] production.INFO: Employee creation request received: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null} [2026-03-30 12:52:03] production.INFO: Validation passed: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null} [2026-03-30 12:52:03] production.INFO: Validation passed: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null} [2026-03-30 12:52:03] production.INFO: === START Employee Creation === [2026-03-30 12:52:03] production.INFO: Received data: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null} [2026-03-30 12:52:03] production.INFO: === START Employee Creation === [2026-03-30 12:52:03] production.INFO: Received data: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null} [2026-03-30 12:52:03] production.INFO: Generated next id: {"next_id":11} [2026-03-30 12:52:03] production.INFO: Generated next id: {"next_id":11} [2026-03-30 12:52:03] production.INFO: Generated user_id: {"user_id":"9242727"} [2026-03-30 12:52:03] production.INFO: Generated user_id: {"user_id":"4784968"} [2026-03-30 12:52:04] production.INFO: Creating user with data: {"id":11,"user_id":"9242727","username":"nshigwedha@kestechtraining.com","email":"nshigwedha@kestechtraining.com","password":"$2y$12$c2E09KJvGC2DyrEg4uMdeur9Gpb0BZ21clKlZ497Wz5AOe.P6wZZW","status":"active"} [2026-03-30 12:52:04] production.INFO: Creating user with data: {"id":11,"user_id":"4784968","username":"nshigwedha@kestechtraining.com","email":"nshigwedha@kestechtraining.com","password":"$2y$12$FIIMGYFlcF87JtJ41ZMjE.fgLpuLstkb2rem/AT4RFnGiwJFhSfKG","status":"active"} [2026-03-30 12:52:04] production.ERROR: === Employee Creation FAILED === [2026-03-30 12:52:04] production.ERROR: Error message: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'nshigwedha@kestechtraining.com' for key 'users_username_unique' (Connection: mysql, SQL: insert into `users` (`id`, `user_id`, `username`, `email`, `password`, `status`, `updated_at`, `created_at`) values (11, 4784968, nshigwedha@kestechtraining.com, nshigwedha@kestechtraining.com, $2y$12$FIIMGYFlcF87JtJ41ZMjE.fgLpuLstkb2rem/AT4RFnGiwJFhSfKG, active, 2026-03-30 12:52:04, 2026-03-30 12:52:04))"} [2026-03-30 12:52:04] production.ERROR: Error trace: {"trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(288): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}"} [2026-03-30 12:52:04] production.ERROR: Data at time of error: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null} [2026-03-30 12:52:04] production.ERROR: === Transaction ROLLED BACK === [2026-03-30 12:52:04] production.ERROR: Employee creation exception: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'nshigwedha@kestechtraining.com' for key 'users_username_unique' (Connection: mysql, SQL: insert into `users` (`id`, `user_id`, `username`, `email`, `password`, `status`, `updated_at`, `created_at`) values (11, 4784968, nshigwedha@kestechtraining.com, nshigwedha@kestechtraining.com, $2y$12$FIIMGYFlcF87JtJ41ZMjE.fgLpuLstkb2rem/AT4RFnGiwJFhSfKG, active, 2026-03-30 12:52:04, 2026-03-30 12:52:04))","trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(288): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}","request":{"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null}} [2026-03-30 12:52:04] production.INFO: User created successfully: {"user_id":"9242727","id":11} [2026-03-30 12:52:04] production.INFO: Generating employee ID... [2026-03-30 12:52:04] production.INFO: Generated employee_id: {"employee_id":"EMP0000006"} [2026-03-30 12:52:04] production.INFO: Status mapping: {"frontend_status":"Active","mapped_status":"active"} [2026-03-30 12:52:04] production.INFO: Creating employee with data: {"employee_id":"EMP0000006","user_id":"9242727","first_name":"Natalia","last_name":"Shigwedha","job_title":"Marketing officer","department":"Marketing","hire_date":"2026-03-16","phone_number":null,"status":"active","id_number":"03021300073"} [2026-03-30 12:52:04] production.ERROR: === Employee Creation FAILED === [2026-03-30 12:52:04] production.ERROR: Error message: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'phone_number' cannot be null (Connection: mysql, SQL: insert into `employees` (`employee_id`, `user_id`, `first_name`, `last_name`, `job_title`, `department`, `hire_date`, `phone_number`, `status`, `id_number`, `updated_at`, `created_at`) values (EMP0000006, 9242727, Natalia, Shigwedha, Marketing officer, Marketing, 2026-03-16 00:00:00, ?, active, 03021300073, 2026-03-30 12:52:04, 2026-03-30 12:52:04))"} [2026-03-30 12:52:04] production.ERROR: Error trace: {"trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(317): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}"} [2026-03-30 12:52:04] production.ERROR: Data at time of error: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null} [2026-03-30 12:52:04] production.ERROR: === Transaction ROLLED BACK === [2026-03-30 12:52:04] production.ERROR: Employee creation exception: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'phone_number' cannot be null (Connection: mysql, SQL: insert into `employees` (`employee_id`, `user_id`, `first_name`, `last_name`, `job_title`, `department`, `hire_date`, `phone_number`, `status`, `id_number`, `updated_at`, `created_at`) values (EMP0000006, 9242727, Natalia, Shigwedha, Marketing officer, Marketing, 2026-03-16 00:00:00, ?, active, 03021300073, 2026-03-30 12:52:04, 2026-03-30 12:52:04))","trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(317): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}","request":{"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":null}} [2026-03-30 12:52:53] production.INFO: Employee creation request received: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":"0816900830"} [2026-03-30 12:52:53] production.INFO: Validation passed: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":"0816900830"} [2026-03-30 12:52:53] production.INFO: === START Employee Creation === [2026-03-30 12:52:53] production.INFO: Received data: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":"0816900830"} [2026-03-30 12:52:53] production.INFO: Employee creation request received: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":"0816900830"} [2026-03-30 12:52:53] production.INFO: Generated next id: {"next_id":11} [2026-03-30 12:52:53] production.INFO: Generated user_id: {"user_id":"7972923"} [2026-03-30 12:52:53] production.INFO: Validation passed: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":"0816900830"} [2026-03-30 12:52:53] production.INFO: === START Employee Creation === [2026-03-30 12:52:53] production.INFO: Received data: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":"0816900830"} [2026-03-30 12:52:53] production.INFO: Generated next id: {"next_id":11} [2026-03-30 12:52:53] production.INFO: Generated user_id: {"user_id":"6548642"} [2026-03-30 12:52:54] production.INFO: Creating user with data: {"id":11,"user_id":"6548642","username":"nshigwedha@kestechtraining.com","email":"nshigwedha@kestechtraining.com","password":"$2y$12$Yod/iJYk9dZLYHwcxubgl.bPhkDJbi4NGC2x3FNgxSzvlNqdzGNKC","status":"active"} [2026-03-30 12:52:54] production.INFO: Creating user with data: {"id":11,"user_id":"7972923","username":"nshigwedha@kestechtraining.com","email":"nshigwedha@kestechtraining.com","password":"$2y$12$pbzmEXagzJCxuSWB4k8uPup2Jd3ZHtBO8SU0hG1dDWrBqaX6DZV3S","status":"active"} [2026-03-30 12:52:54] production.INFO: User created successfully: {"user_id":"6548642","id":11} [2026-03-30 12:52:54] production.INFO: Generating employee ID... [2026-03-30 12:52:54] production.ERROR: === Employee Creation FAILED === [2026-03-30 12:52:54] production.ERROR: Error message: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'nshigwedha@kestechtraining.com' for key 'users_username_unique' (Connection: mysql, SQL: insert into `users` (`id`, `user_id`, `username`, `email`, `password`, `status`, `updated_at`, `created_at`) values (11, 7972923, nshigwedha@kestechtraining.com, nshigwedha@kestechtraining.com, $2y$12$pbzmEXagzJCxuSWB4k8uPup2Jd3ZHtBO8SU0hG1dDWrBqaX6DZV3S, active, 2026-03-30 12:52:54, 2026-03-30 12:52:54))"} [2026-03-30 12:52:54] production.ERROR: Error trace: {"trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(288): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}"} [2026-03-30 12:52:54] production.ERROR: Data at time of error: {"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":"0816900830"} [2026-03-30 12:52:54] production.ERROR: === Transaction ROLLED BACK === [2026-03-30 12:52:54] production.ERROR: Employee creation exception: {"message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'nshigwedha@kestechtraining.com' for key 'users_username_unique' (Connection: mysql, SQL: insert into `users` (`id`, `user_id`, `username`, `email`, `password`, `status`, `updated_at`, `created_at`) values (11, 7972923, nshigwedha@kestechtraining.com, nshigwedha@kestechtraining.com, $2y$12$pbzmEXagzJCxuSWB4k8uPup2Jd3ZHtBO8SU0hG1dDWrBqaX6DZV3S, active, 2026-03-30 12:52:54, 2026-03-30 12:52:54))","trace":"#0 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run() #2 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3804): Illuminate\\Database\\MySqlConnection->insert() #3 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2235): Illuminate\\Database\\Query\\Builder->insert() #4 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1412): Illuminate\\Database\\Eloquent\\Builder->__call() #5 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert() #6 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save() #7 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(390): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}() #8 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap() #9 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create() #10 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo() #11 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call() #12 /home/kezogesw/api.kestechtraining.com/app/Services/EmployeeService.php(288): Illuminate\\Database\\Eloquent\\Model::__callStatic() #13 /home/kezogesw/api.kestechtraining.com/app/Http/Controllers/EmployeeController.php(129): App\\Services\\EmployeeService->createEmployee() #14 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\EmployeeController->store() #15 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #16 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch() #17 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController() #18 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run() #19 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #20 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #26 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle() #27 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}() #29 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /home/kezogesw/api.kestechtraining.com/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->then() #31 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle() #32 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then() #34 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute() #36 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #38 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #39 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #42 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #44 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #45 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle() #47 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #49 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle() #51 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle() #53 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle() #55 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle() #57 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #58 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #59 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #60 /home/kezogesw/api.kestechtraining.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1220): Illuminate\\Foundation\\Http\\Kernel->handle() #61 /home/kezogesw/api.kestechtraining.com/public/index.php(20): Illuminate\\Foundation\\Application->handleRequest() #62 {main}","request":{"first_name":"Natalia","last_name":"Shigwedha","email":"nshigwedha@kestechtraining.com","id_number":"03021300073","position":"Marketing officer","department":"Marketing","status":"Active","hire_date":"2026-03-16","phone_number":"0816900830"}} [2026-03-30 12:52:54] production.INFO: Generated employee_id: {"employee_id":"EMP0000006"} [2026-03-30 12:52:54] production.INFO: Status mapping: {"frontend_status":"Active","mapped_status":"active"} [2026-03-30 12:52:54] production.INFO: Creating employee with data: {"employee_id":"EMP0000006","user_id":"6548642","first_name":"Natalia","last_name":"Shigwedha","job_title":"Marketing officer","department":"Marketing","hire_date":"2026-03-16","phone_number":"0816900830","status":"active","id_number":"03021300073"} [2026-03-30 12:52:54] production.INFO: Employee created successfully: {"employee_id":"EMP0000006"} [2026-03-30 12:52:54] production.INFO: === Transaction COMMITTED === [2026-03-30 12:52:54] production.INFO: === END Employee Creation - Success === [2026-03-30 12:53:11] production.INFO: AccessControlController: employees() called {"current_user_id":"4918349","current_username":"mluswenyo@kestechtraining.com"} [2026-03-30 12:53:11] production.INFO: Employee counts {"total":5,"same_user_as_current":1} [2026-03-30 12:53:11] production.INFO: Current user employee found {"employee_id":"EMP0000001","name":"Mafenyeho Luswenyo"} [2026-03-30 12:53:11] production.INFO: Generated SQL {"sql":"select `employee_id`, `user_id`, `first_name`, `last_name`, `phone_number`, `id_number`, `department`, `job_title`, `hire_date` from `employees` where `employee_id` != ? and `user_id` is not null","bindings":["EMP0000001"]} [2026-03-30 12:53:11] production.INFO: Employees found {"count":4} [2026-03-30 12:53:11] production.INFO: First 3 employees formatted {"employees":[{"employee_id":"EMP0000004","user_id":"9336210","first_name":"Finnias","last_name":"Sikeba","full_name":"Finnias Sikeba","email":"fsikeba@kestechtraining.com","username":"fsikeba@kestechtraining.com","phone_number":"0816758807","id_number":"90031300928","department":"Electrical","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000004"},{"employee_id":"EMP0000003","user_id":"4753912","first_name":"Lukas","last_name":"Mateus","full_name":"Lukas Mateus","email":"lmateus@kestechtraining.com","username":"lmateus@kestechtraining.com","phone_number":"0816457784","id_number":"02070200868","department":"Solar","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000003"},{"employee_id":"EMP0000006","user_id":"6548642","first_name":"Natalia","last_name":"Shigwedha","full_name":"Natalia Shigwedha","email":"nshigwedha@kestechtraining.com","username":"nshigwedha@kestechtraining.com","phone_number":"0816900830","id_number":"03021300073","department":"Marketing","job_title":"Marketing officer","hire_date":"2026-03-16 00:00:00","employee_number":"EMP0000006"}]} [2026-03-30 12:54:22] production.INFO: Employee password reset {"employee_id":"EMP0000006","user_id":"6548642","reset_by":"4918349"} [2026-03-30 12:54:27] production.INFO: Employee status updated {"employee_id":"EMP0000006","user_id":"6548642","old_status":"Active","new_status":"active","updated_by":"4918349"} [2026-03-31 14:55:56] production.INFO: AccessControlController: employees() called {"current_user_id":"4918349","current_username":"mluswenyo@kestechtraining.com"} [2026-03-31 14:55:56] production.INFO: Employee counts {"total":5,"same_user_as_current":1} [2026-03-31 14:55:56] production.INFO: Current user employee found {"employee_id":"EMP0000001","name":"Mafenyeho Luswenyo"} [2026-03-31 14:55:56] production.INFO: Generated SQL {"sql":"select `employee_id`, `user_id`, `first_name`, `last_name`, `phone_number`, `id_number`, `department`, `job_title`, `hire_date` from `employees` where `employee_id` != ? and `user_id` is not null","bindings":["EMP0000001"]} [2026-03-31 14:55:56] production.INFO: Employees found {"count":4} [2026-03-31 14:55:56] production.INFO: First 3 employees formatted {"employees":[{"employee_id":"EMP0000004","user_id":"9336210","first_name":"Finnias","last_name":"Sikeba","full_name":"Finnias Sikeba","email":"fsikeba@kestechtraining.com","username":"fsikeba@kestechtraining.com","phone_number":"0816758807","id_number":"90031300928","department":"Electrical","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000004"},{"employee_id":"EMP0000003","user_id":"4753912","first_name":"Lukas","last_name":"Mateus","full_name":"Lukas Mateus","email":"lmateus@kestechtraining.com","username":"lmateus@kestechtraining.com","phone_number":"0816457784","id_number":"02070200868","department":"Solar","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000003"},{"employee_id":"EMP0000006","user_id":"6548642","first_name":"Natalia","last_name":"Shigwedha","full_name":"Natalia Shigwedha","email":"nshigwedha@kestechtraining.com","username":"nshigwedha@kestechtraining.com","phone_number":"0816900830","id_number":"03021300073","department":"Marketing","job_title":"Marketing officer","hire_date":"2026-03-16 00:00:00","employee_number":"EMP0000006"}]} [2026-03-31 14:59:10] production.INFO: Employee password reset {"employee_id":"EMP0000004","user_id":"9336210","reset_by":"4918349"} [2026-03-31 14:59:13] production.INFO: Employee status updated {"employee_id":"EMP0000004","user_id":"9336210","old_status":"Active","new_status":"active","updated_by":"4918349"} [2026-03-31 15:03:02] production.INFO: AccessControlController: employees() called {"current_user_id":"4918349","current_username":"mluswenyo@kestechtraining.com"} [2026-03-31 15:03:02] production.INFO: Employee counts {"total":5,"same_user_as_current":1} [2026-03-31 15:03:02] production.INFO: Current user employee found {"employee_id":"EMP0000001","name":"Mafenyeho Luswenyo"} [2026-03-31 15:03:02] production.INFO: Generated SQL {"sql":"select `employee_id`, `user_id`, `first_name`, `last_name`, `phone_number`, `id_number`, `department`, `job_title`, `hire_date` from `employees` where `employee_id` != ? and `user_id` is not null","bindings":["EMP0000001"]} [2026-03-31 15:03:02] production.INFO: Employees found {"count":4} [2026-03-31 15:03:02] production.INFO: First 3 employees formatted {"employees":[{"employee_id":"EMP0000004","user_id":"9336210","first_name":"Finnias","last_name":"Sikeba","full_name":"Finnias Sikeba","email":"fsikeba@kestechtraining.com","username":"fsikeba@kestechtraining.com","phone_number":"0816758807","id_number":"90031300928","department":"Electrical","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000004"},{"employee_id":"EMP0000003","user_id":"4753912","first_name":"Lukas","last_name":"Mateus","full_name":"Lukas Mateus","email":"lmateus@kestechtraining.com","username":"lmateus@kestechtraining.com","phone_number":"0816457784","id_number":"02070200868","department":"Solar","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000003"},{"employee_id":"EMP0000006","user_id":"6548642","first_name":"Natalia","last_name":"Shigwedha","full_name":"Natalia Shigwedha","email":"nshigwedha@kestechtraining.com","username":"nshigwedha@kestechtraining.com","phone_number":"0816900830","id_number":"03021300073","department":"Marketing","job_title":"Marketing officer","hire_date":"2026-03-16 00:00:00","employee_number":"EMP0000006"}]} [2026-03-31 15:04:16] production.INFO: Employee password reset {"employee_id":"EMP0000003","user_id":"4753912","reset_by":"4918349"} [2026-03-31 15:04:20] production.INFO: Employee status updated {"employee_id":"EMP0000003","user_id":"4753912","old_status":"Active","new_status":"active","updated_by":"4918349"} [2026-03-31 15:07:51] production.INFO: AccessControlController: employees() called {"current_user_id":"1","current_username":"admin"} [2026-03-31 15:07:51] production.INFO: Employee counts {"total":5,"same_user_as_current":0} [2026-03-31 15:07:51] production.WARNING: No employee record found for current user [2026-03-31 15:07:51] production.INFO: Generated SQL {"sql":"select `employee_id`, `user_id`, `first_name`, `last_name`, `phone_number`, `id_number`, `department`, `job_title`, `hire_date` from `employees` where `user_id` is not null","bindings":[]} [2026-03-31 15:07:51] production.INFO: Employees found {"count":5} [2026-03-31 15:07:51] production.INFO: First 3 employees formatted {"employees":[{"employee_id":"EMP0000004","user_id":"9336210","first_name":"Finnias","last_name":"Sikeba","full_name":"Finnias Sikeba","email":"fsikeba@kestechtraining.com","username":"fsikeba@kestechtraining.com","phone_number":"0816758807","id_number":"90031300928","department":"Electrical","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000004"},{"employee_id":"EMP0000003","user_id":"4753912","first_name":"Lukas","last_name":"Mateus","full_name":"Lukas Mateus","email":"lmateus@kestechtraining.com","username":"lmateus@kestechtraining.com","phone_number":"0816457784","id_number":"02070200868","department":"Solar","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000003"},{"employee_id":"EMP0000001","user_id":"4918349","first_name":"Mafenyeho","last_name":"Luswenyo","full_name":"Mafenyeho Luswenyo","email":"mluswenyo@kestechtraining.com","username":"mluswenyo@kestechtraining.com","phone_number":"0812649016","id_number":"03100200322","department":"ICT","job_title":"IT Technician","hire_date":"2026-02-08 00:00:00","employee_number":"EMP0000001"}]} [2026-03-31 15:09:01] production.INFO: Employee password reset {"employee_id":"EMP0000004","user_id":"9336210","reset_by":"1"} [2026-03-31 15:09:04] production.INFO: Employee status updated {"employee_id":"EMP0000004","user_id":"9336210","old_status":"Active","new_status":"active","updated_by":"1"} [2026-04-02 21:49:59] production.INFO: AccessControlController: employees() called {"current_user_id":"4918349","current_username":"mluswenyo@kestechtraining.com"} [2026-04-02 21:49:59] production.INFO: Employee counts {"total":5,"same_user_as_current":1} [2026-04-02 21:49:59] production.INFO: Current user employee found {"employee_id":"EMP0000001","name":"Mafenyeho Luswenyo"} [2026-04-02 21:49:59] production.INFO: Generated SQL {"sql":"select `employee_id`, `user_id`, `first_name`, `last_name`, `phone_number`, `id_number`, `department`, `job_title`, `hire_date` from `employees` where `employee_id` != ? and `user_id` is not null","bindings":["EMP0000001"]} [2026-04-02 21:49:59] production.INFO: Employees found {"count":4} [2026-04-02 21:49:59] production.INFO: First 3 employees formatted {"employees":[{"employee_id":"EMP0000004","user_id":"9336210","first_name":"Finnias","last_name":"Sikeba","full_name":"Finnias Sikeba","email":"fsikeba@kestechtraining.com","username":"fsikeba@kestechtraining.com","phone_number":"0816758807","id_number":"90031300928","department":"Electrical","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000004"},{"employee_id":"EMP0000003","user_id":"4753912","first_name":"Lukas","last_name":"Mateus","full_name":"Lukas Mateus","email":"lmateus@kestechtraining.com","username":"lmateus@kestechtraining.com","phone_number":"0816457784","id_number":"02070200868","department":"Solar","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000003"},{"employee_id":"EMP0000006","user_id":"6548642","first_name":"Natalia","last_name":"Shigwedha","full_name":"Natalia Shigwedha","email":"nshigwedha@kestechtraining.com","username":"nshigwedha@kestechtraining.com","phone_number":"0816900830","id_number":"03021300073","department":"Marketing","job_title":"Marketing officer","hire_date":"2026-03-16 00:00:00","employee_number":"EMP0000006"}]} [2026-04-17 02:46:10] production.INFO: AccessControlController: employees() called {"current_user_id":"4918349","current_username":"mluswenyo@kestechtraining.com"} [2026-04-17 02:46:10] production.INFO: Employee counts {"total":5,"same_user_as_current":1} [2026-04-17 02:46:10] production.INFO: Current user employee found {"employee_id":"EMP0000001","name":"Mafenyeho Luswenyo"} [2026-04-17 02:46:10] production.INFO: Generated SQL {"sql":"select `employee_id`, `user_id`, `first_name`, `last_name`, `phone_number`, `id_number`, `department`, `job_title`, `hire_date` from `employees` where `employee_id` != ? and `user_id` is not null","bindings":["EMP0000001"]} [2026-04-17 02:46:10] production.INFO: Employees found {"count":4} [2026-04-17 02:46:10] production.INFO: First 3 employees formatted {"employees":[{"employee_id":"EMP0000004","user_id":"9336210","first_name":"Finnias","last_name":"Sikeba","full_name":"Finnias Sikeba","email":"fsikeba@kestechtraining.com","username":"fsikeba@kestechtraining.com","phone_number":"0816758807","id_number":"90031300928","department":"Electrical","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000004"},{"employee_id":"EMP0000003","user_id":"4753912","first_name":"Lukas","last_name":"Mateus","full_name":"Lukas Mateus","email":"lmateus@kestechtraining.com","username":"lmateus@kestechtraining.com","phone_number":"0816457784","id_number":"02070200868","department":"Solar","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000003"},{"employee_id":"EMP0000006","user_id":"6548642","first_name":"Natalia","last_name":"Shigwedha","full_name":"Natalia Shigwedha","email":"nshigwedha@kestechtraining.com","username":"nshigwedha@kestechtraining.com","phone_number":"0816900830","id_number":"03021300073","department":"Marketing","job_title":"Marketing officer","hire_date":"2026-03-16 00:00:00","employee_number":"EMP0000006"}]} [2026-05-21 08:54:24] production.INFO: AccessControlController: employees() called {"current_user_id":"4918349","current_username":"mluswenyo@kestechtraining.com"} [2026-05-21 08:54:24] production.INFO: Employee counts {"total":5,"same_user_as_current":1} [2026-05-21 08:54:24] production.INFO: Current user employee found {"employee_id":"EMP0000001","name":"Mafenyeho Luswenyo"} [2026-05-21 08:54:24] production.INFO: Generated SQL {"sql":"select `employee_id`, `user_id`, `first_name`, `last_name`, `phone_number`, `id_number`, `department`, `job_title`, `hire_date` from `employees` where `employee_id` != ? and `user_id` is not null","bindings":["EMP0000001"]} [2026-05-21 08:54:24] production.INFO: Employees found {"count":4} [2026-05-21 08:54:24] production.INFO: First 3 employees formatted {"employees":[{"employee_id":"EMP0000004","user_id":"9336210","first_name":"Finnias","last_name":"Sikeba","full_name":"Finnias Sikeba","email":"fsikeba@kestechtraining.com","username":"fsikeba@kestechtraining.com","phone_number":"0816758807","id_number":"90031300928","department":"Electrical","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000004"},{"employee_id":"EMP0000003","user_id":"4753912","first_name":"Lukas","last_name":"Mateus","full_name":"Lukas Mateus","email":"lmateus@kestechtraining.com","username":"lmateus@kestechtraining.com","phone_number":"0816457784","id_number":"02070200868","department":"Solar","job_title":"Instructor","hire_date":"2026-02-15 00:00:00","employee_number":"EMP0000003"},{"employee_id":"EMP0000006","user_id":"6548642","first_name":"Natalia","last_name":"Shigwedha","full_name":"Natalia Shigwedha","email":"nshigwedha@kestechtraining.com","username":"nshigwedha@kestechtraining.com","phone_number":"0816900830","id_number":"03021300073","department":"Marketing","job_title":"Marketing officer","hire_date":"2026-03-16 00:00:00","employee_number":"EMP0000006"}]}