[2025-11-11 08:46:24] HotBee.ERROR: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "NaN" CONTEXT: unnamed portal parameter $1 = '...' (SQL: select "id", "factory_id", "project_name", "start_date", "end_date", (select count(*) from "ir_project_sections" where "ir_projects"."id" = "ir_project_sections"."ir_project_id" and "ir_project_sections"."deleted_at" is null) as "ir_sections_count", (select count(*) from "ir_project_boxes" inner join "ir_project_sections" on "ir_project_sections"."id" = "ir_project_boxes"."ir_project_section_id" where "ir_projects"."id" = "ir_project_sections"."ir_project_id" and "ir_project_sections"."deleted_at" is null) as "ir_boxes_count" from "ir_projects" where "id" = NaN and "ir_projects"."deleted_at" is null limit 1) {"userId":191,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: \"NaN\" CONTEXT: unnamed portal parameter $1 = '...' (SQL: select \"id\", \"factory_id\", \"project_name\", \"start_date\", \"end_date\", (select count(*) from \"ir_project_sections\" where \"ir_projects\".\"id\" = \"ir_project_sections\".\"ir_project_id\" and \"ir_project_sections\".\"deleted_at\" is null) as \"ir_sections_count\", (select count(*) from \"ir_project_boxes\" inner join \"ir_project_sections\" on \"ir_project_sections\".\"id\" = \"ir_project_boxes\".\"ir_project_section_id\" where \"ir_projects\".\"id\" = \"ir_project_sections\".\"ir_project_id\" and \"ir_project_sections\".\"deleted_at\" is null) as \"ir_boxes_count\" from \"ir_projects\" where \"id\" = NaN and \"ir_projects\".\"deleted_at\" is null limit 1) at C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"id\", \"f...', Array, Object(Closure)) #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"id\", \"f...', Array, Object(Closure)) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"id\", \"f...', Array, true) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(625): Illuminate\\Database\\Query\\Builder->get(Array) #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(609): Illuminate\\Database\\Eloquent\\Builder->getModels(Array) #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Eloquent\\Builder->get(Array) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\app\\Http\\Controllers\\ApiThermalUploadController.php(111): Illuminate\\Database\\Eloquent\\Builder->first() #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalUploadController->detail(Object(Illuminate\\Http\\Request), 'first', 'NaN') #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('detail', Array) #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(261): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalUploadController), 'detail') #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\app\\Http\\Middleware\\AuthticatedThermalSubAccount.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\AuthticatedThermalSubAccount->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(58): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(719): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\public\\index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #53 {main} [previous exception] [object] (PDOException(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: \"NaN\" CONTEXT: unnamed portal parameter $1 = '...' at C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"id\", \"f...', Array) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"id\", \"f...', Array, Object(Closure)) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"id\", \"f...', Array, Object(Closure)) #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"id\", \"f...', Array, true) #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(625): Illuminate\\Database\\Query\\Builder->get(Array) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(609): Illuminate\\Database\\Eloquent\\Builder->getModels(Array) #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Eloquent\\Builder->get(Array) #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\app\\Http\\Controllers\\ApiThermalUploadController.php(111): Illuminate\\Database\\Eloquent\\Builder->first() #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalUploadController->detail(Object(Illuminate\\Http\\Request), 'first', 'NaN') #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('detail', Array) #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(261): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalUploadController), 'detail') #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\app\\Http\\Middleware\\AuthticatedThermalSubAccount.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\AuthticatedThermalSubAccount->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(58): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(719): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #53 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #54 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\public\\index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #55 {main} "} [2025-11-11 08:46:27] HotBee.ERROR: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "NaN" CONTEXT: unnamed portal parameter $1 = '...' (SQL: select "id", "factory_id", "project_name", "start_date", "end_date", (select count(*) from "ir_project_sections" where "ir_projects"."id" = "ir_project_sections"."ir_project_id" and "ir_project_sections"."deleted_at" is null) as "ir_sections_count", (select count(*) from "ir_project_boxes" inner join "ir_project_sections" on "ir_project_sections"."id" = "ir_project_boxes"."ir_project_section_id" where "ir_projects"."id" = "ir_project_sections"."ir_project_id" and "ir_project_sections"."deleted_at" is null) as "ir_boxes_count" from "ir_projects" where "id" = NaN and "ir_projects"."deleted_at" is null limit 1) {"userId":191,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: \"NaN\" CONTEXT: unnamed portal parameter $1 = '...' (SQL: select \"id\", \"factory_id\", \"project_name\", \"start_date\", \"end_date\", (select count(*) from \"ir_project_sections\" where \"ir_projects\".\"id\" = \"ir_project_sections\".\"ir_project_id\" and \"ir_project_sections\".\"deleted_at\" is null) as \"ir_sections_count\", (select count(*) from \"ir_project_boxes\" inner join \"ir_project_sections\" on \"ir_project_sections\".\"id\" = \"ir_project_boxes\".\"ir_project_section_id\" where \"ir_projects\".\"id\" = \"ir_project_sections\".\"ir_project_id\" and \"ir_project_sections\".\"deleted_at\" is null) as \"ir_boxes_count\" from \"ir_projects\" where \"id\" = NaN and \"ir_projects\".\"deleted_at\" is null limit 1) at C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"id\", \"f...', Array, Object(Closure)) #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"id\", \"f...', Array, Object(Closure)) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"id\", \"f...', Array, true) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(625): Illuminate\\Database\\Query\\Builder->get(Array) #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(609): Illuminate\\Database\\Eloquent\\Builder->getModels(Array) #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Eloquent\\Builder->get(Array) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\app\\Http\\Controllers\\ApiThermalUploadController.php(111): Illuminate\\Database\\Eloquent\\Builder->first() #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalUploadController->detail(Object(Illuminate\\Http\\Request), 'first', 'NaN') #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('detail', Array) #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(261): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalUploadController), 'detail') #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\app\\Http\\Middleware\\AuthticatedThermalSubAccount.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\AuthticatedThermalSubAccount->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(58): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(719): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\public\\index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #53 {main} [previous exception] [object] (PDOException(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: \"NaN\" CONTEXT: unnamed portal parameter $1 = '...' at C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"id\", \"f...', Array) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"id\", \"f...', Array, Object(Closure)) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"id\", \"f...', Array, Object(Closure)) #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"id\", \"f...', Array, true) #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(625): Illuminate\\Database\\Query\\Builder->get(Array) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(609): Illuminate\\Database\\Eloquent\\Builder->getModels(Array) #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Eloquent\\Builder->get(Array) #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\app\\Http\\Controllers\\ApiThermalUploadController.php(111): Illuminate\\Database\\Eloquent\\Builder->first() #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalUploadController->detail(Object(Illuminate\\Http\\Request), 'first', 'NaN') #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('detail', Array) #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(261): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalUploadController), 'detail') #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\app\\Http\\Middleware\\AuthticatedThermalSubAccount.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\AuthticatedThermalSubAccount->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(58): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(719): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #53 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #54 C:\\AppServ\\Apache\\2.4.58\\htdocs\\IDA_hotbee\\public\\index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #55 {main} "}