[2024-09-03 16:10:05] local.ERROR: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "result_desc" of relation "ir_report_record_detects" violates not-null constraint DETAIL: Failing row contains (633, 494, 變壓器, 67.0, 0, 1, null, null, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., 1, 2024-09-03 16:10:05, 2024-09-03 16:10:05, null, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., f, 0, 709, null, null, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., 下方拍攝區域為變壓器線圈 故溫度偏高(67.0度)). (SQL: insert into "ir_report_record_detects" ("ir_result_box_partial_id", "exam_point", "ultimate_temp", "box_img_thermal", "box_img_thermal_generate", "box_img_generate", "box_img", "improve_level", "judgment_basis", "result_desc", "advice", "has_second", "remark", "ir_report_record_id", "priority", "updated_at", "created_at") values (709, 變壓器, 67.0, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_TYrnDvvqMe_partial_thermal.jpg, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_TYrnDvvqMe_partial_thermal_custom_rect.png, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_TYrnDvvqMe_partial_visual_custom_rect.png, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_TYrnDvvqMe_partial_visual.jpg, 0, 1, ?, ?, 0, 下方拍攝區域為變壓器線圈 故溫度偏高(67.0度), 494, 1, 2024-09-03 16:10:05, 2024-09-03 16:10:05) returning "id") {"userId":162,"exception":"[object] (Illuminate\\Database\\QueryException(code: 23502): SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"result_desc\" of relation \"ir_report_record_detects\" violates not-null constraint DETAIL: Failing row contains (633, 494, 變壓器, 67.0, 0, 1, null, null, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., 1, 2024-09-03 16:10:05, 2024-09-03 16:10:05, null, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., f, 0, 709, null, null, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., 下方拍攝區域為變壓器線圈 故溫度偏高(67.0度)). (SQL: insert into \"ir_report_record_detects\" (\"ir_result_box_partial_id\", \"exam_point\", \"ultimate_temp\", \"box_img_thermal\", \"box_img_thermal_generate\", \"box_img_generate\", \"box_img\", \"improve_level\", \"judgment_basis\", \"result_desc\", \"advice\", \"has_second\", \"remark\", \"ir_report_record_id\", \"priority\", \"updated_at\", \"created_at\") values (709, 變壓器, 67.0, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_TYrnDvvqMe_partial_thermal.jpg, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_TYrnDvvqMe_partial_thermal_custom_rect.png, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_TYrnDvvqMe_partial_visual_custom_rect.png, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_TYrnDvvqMe_partial_visual.jpg, 0, 1, ?, ?, 0, 下方拍攝區域為變壓器線圈 故溫度偏高(67.0度), 494, 1, 2024-09-03 16:10:05, 2024-09-03 16:10:05) returning \"id\") at C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('insert into \"ir...', Array, Object(Closure)) #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run('insert into \"ir...', Array, Object(Closure)) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(346): Illuminate\\Database\\Connection->select('insert into \"ir...', Array, false) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Processors\\PostgresProcessor.php(24): Illuminate\\Database\\Connection->selectFromWriteConnection('insert into \"ir...', Array) #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(3028): Illuminate\\Database\\Query\\Processors\\PostgresProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into \"ir...', Array, 'id') #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(1657): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id') #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(1188): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array) #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(1153): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array) #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(994): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder)) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(896): Illuminate\\Database\\Eloquent\\Model->save() #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\helpers.php(263): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\IrReportRecordDetect)) #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(897): tap(Object(App\\Models\\IrReportRecordDetect), Object(Closure)) #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create(Array) #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2132): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'create', Array) #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2144): Illuminate\\Database\\Eloquent\\Model->__call('create', Array) #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Repositories\\IrResultExportRepository.php(143): Illuminate\\Database\\Eloquent\\Model::__callStatic('create', Array) #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Services\\IrResultExportService.php(260): App\\Repositories\\IrResultExportRepository->updateOrCreate('88', Array) #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Http\\Controllers\\ApiThermalResultController.php(185): App\\Services\\IrResultExportService->updateOrCreate('88', Array) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalResultController->updatebyId(Object(Illuminate\\Http\\Request), '88') #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('updatebyId', Array) #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalResultController), 'updatebyId') #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(63): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_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)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #53 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #54 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #55 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #56 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #57 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #58 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #59 {main} [previous exception] [object] (PDOException(code: 23502): SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"result_desc\" of relation \"ir_report_record_detects\" violates not-null constraint DETAIL: Failing row contains (633, 494, 變壓器, 67.0, 0, 1, null, null, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., 1, 2024-09-03 16:10:05, 2024-09-03 16:10:05, null, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., f, 0, 709, null, null, thermal_results/162/121/88/1297/gvKQ5scJX4v3k21S5CddUXoq0KCeQG_T..., 下方拍攝區域為變壓器線圈 故溫度偏高(67.0度)). at C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into \"ir...', Array) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('insert into \"ir...', Array, Object(Closure)) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run('insert into \"ir...', Array, Object(Closure)) #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(346): Illuminate\\Database\\Connection->select('insert into \"ir...', Array, false) #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Processors\\PostgresProcessor.php(24): Illuminate\\Database\\Connection->selectFromWriteConnection('insert into \"ir...', Array) #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(3028): Illuminate\\Database\\Query\\Processors\\PostgresProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into \"ir...', Array, 'id') #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(1657): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id') #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(1188): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(1153): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array) #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(994): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder)) #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(896): Illuminate\\Database\\Eloquent\\Model->save() #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\helpers.php(263): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\IrReportRecordDetect)) #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(897): tap(Object(App\\Models\\IrReportRecordDetect), Object(Closure)) #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create(Array) #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2132): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'create', Array) #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2144): Illuminate\\Database\\Eloquent\\Model->__call('create', Array) #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Repositories\\IrResultExportRepository.php(143): Illuminate\\Database\\Eloquent\\Model::__callStatic('create', Array) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Services\\IrResultExportService.php(260): App\\Repositories\\IrResultExportRepository->updateOrCreate('88', Array) #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Http\\Controllers\\ApiThermalResultController.php(185): App\\Services\\IrResultExportService->updateOrCreate('88', Array) #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalResultController->updatebyId(Object(Illuminate\\Http\\Request), '88') #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('updatebyId', Array) #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalResultController), 'updatebyId') #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(63): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_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)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #53 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #54 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #55 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #56 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #57 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #58 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #59 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #60 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #61 {main} "} [2024-09-03 16:13:37] local.ERROR: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "box_name" of relation "ir_report_records" violates not-null constraint DETAIL: Failing row contains (530, 54, 275, 2024-06-15, FLIR THERMOGRAPHY, 會議室, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., 2024-09-03 16:13:24, 2024-09-03 16:13:37, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., 0, 1, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., null). (SQL: update "ir_report_records" set "box_name" = ?, "updated_at" = 2024-09-03 16:13:37 where "id" = 530) {"userId":9,"exception":"[object] (Illuminate\\Database\\QueryException(code: 23502): SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"box_name\" of relation \"ir_report_records\" violates not-null constraint DETAIL: Failing row contains (530, 54, 275, 2024-06-15, FLIR THERMOGRAPHY, 會議室, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., 2024-09-03 16:13:24, 2024-09-03 16:13:37, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., 0, 1, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., null). (SQL: update \"ir_report_records\" set \"box_name\" = ?, \"updated_at\" = 2024-09-03 16:13:37 where \"id\" = 530) at C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('update \"ir_repo...', Array, Object(Closure)) #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(533): Illuminate\\Database\\Connection->run('update \"ir_repo...', Array, Object(Closure)) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(466): Illuminate\\Database\\Connection->affectingStatement('update \"ir_repo...', Array) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(3063): Illuminate\\Database\\Connection->update('update \"ir_repo...', Array) #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(921): Illuminate\\Database\\Query\\Builder->update(Array) #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(1072): Illuminate\\Database\\Eloquent\\Builder->update(Array) #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(987): Illuminate\\Database\\Eloquent\\Model->performUpdate(Object(Illuminate\\Database\\Eloquent\\Builder)) #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(509): Illuminate\\Database\\Eloquent\\Model->save() #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\helpers.php(263): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\IrReportRecord)) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(510): tap(Object(App\\Models\\IrReportRecord), Object(Closure)) #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->updateOrCreate(Array, Array) #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2132): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'updateOrCreate', Array) #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2144): Illuminate\\Database\\Eloquent\\Model->__call('updateOrCreate', Array) #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Repositories\\IrResultExportRepository.php(131): Illuminate\\Database\\Eloquent\\Model::__callStatic('updateOrCreate', Array) #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Services\\IrResultExportService.php(260): App\\Repositories\\IrResultExportRepository->updateOrCreate('54', Array) #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Http\\Controllers\\ApiThermalResultController.php(185): App\\Services\\IrResultExportService->updateOrCreate('54', Array) #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalResultController->updatebyId(Object(Illuminate\\Http\\Request), '54') #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('updatebyId', Array) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalResultController), 'updatebyId') #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(63): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_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)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #53 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #54 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #55 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #56 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #57 {main} [previous exception] [object] (PDOException(code: 23502): SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"box_name\" of relation \"ir_report_records\" violates not-null constraint DETAIL: Failing row contains (530, 54, 275, 2024-06-15, FLIR THERMOGRAPHY, 會議室, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., 2024-09-03 16:13:24, 2024-09-03 16:13:37, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., 0, 1, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., null). at C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:526) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(526): PDOStatement->execute() #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('update \"ir_repo...', Array) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('update \"ir_repo...', Array, Object(Closure)) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(533): Illuminate\\Database\\Connection->run('update \"ir_repo...', Array, Object(Closure)) #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(466): Illuminate\\Database\\Connection->affectingStatement('update \"ir_repo...', Array) #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(3063): Illuminate\\Database\\Connection->update('update \"ir_repo...', Array) #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(921): Illuminate\\Database\\Query\\Builder->update(Array) #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(1072): Illuminate\\Database\\Eloquent\\Builder->update(Array) #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(987): Illuminate\\Database\\Eloquent\\Model->performUpdate(Object(Illuminate\\Database\\Eloquent\\Builder)) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(509): Illuminate\\Database\\Eloquent\\Model->save() #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\helpers.php(263): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\IrReportRecord)) #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(510): tap(Object(App\\Models\\IrReportRecord), Object(Closure)) #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->updateOrCreate(Array, Array) #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2132): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'updateOrCreate', Array) #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2144): Illuminate\\Database\\Eloquent\\Model->__call('updateOrCreate', Array) #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Repositories\\IrResultExportRepository.php(131): Illuminate\\Database\\Eloquent\\Model::__callStatic('updateOrCreate', Array) #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Services\\IrResultExportService.php(260): App\\Repositories\\IrResultExportRepository->updateOrCreate('54', Array) #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Http\\Controllers\\ApiThermalResultController.php(185): App\\Services\\IrResultExportService->updateOrCreate('54', Array) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalResultController->updatebyId(Object(Illuminate\\Http\\Request), '54') #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('updatebyId', Array) #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalResultController), 'updatebyId') #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(63): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_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)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #53 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #54 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #55 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #56 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #57 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #58 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #59 {main} "} [2024-09-03 16:13:48] local.ERROR: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "box_name" of relation "ir_report_records" violates not-null constraint DETAIL: Failing row contains (530, 54, 275, 2024-06-15, FLIR THERMOGRAPHY, 會議室, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., 2024-09-03 16:13:24, 2024-09-03 16:13:48, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., 0, 1, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., null). (SQL: update "ir_report_records" set "box_name" = ?, "updated_at" = 2024-09-03 16:13:48 where "id" = 530) {"userId":9,"exception":"[object] (Illuminate\\Database\\QueryException(code: 23502): SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"box_name\" of relation \"ir_report_records\" violates not-null constraint DETAIL: Failing row contains (530, 54, 275, 2024-06-15, FLIR THERMOGRAPHY, 會議室, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., 2024-09-03 16:13:24, 2024-09-03 16:13:48, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., 0, 1, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., null). (SQL: update \"ir_report_records\" set \"box_name\" = ?, \"updated_at\" = 2024-09-03 16:13:48 where \"id\" = 530) at C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('update \"ir_repo...', Array, Object(Closure)) #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(533): Illuminate\\Database\\Connection->run('update \"ir_repo...', Array, Object(Closure)) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(466): Illuminate\\Database\\Connection->affectingStatement('update \"ir_repo...', Array) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(3063): Illuminate\\Database\\Connection->update('update \"ir_repo...', Array) #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(921): Illuminate\\Database\\Query\\Builder->update(Array) #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(1072): Illuminate\\Database\\Eloquent\\Builder->update(Array) #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(987): Illuminate\\Database\\Eloquent\\Model->performUpdate(Object(Illuminate\\Database\\Eloquent\\Builder)) #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(509): Illuminate\\Database\\Eloquent\\Model->save() #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\helpers.php(263): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\IrReportRecord)) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(510): tap(Object(App\\Models\\IrReportRecord), Object(Closure)) #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->updateOrCreate(Array, Array) #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2132): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'updateOrCreate', Array) #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2144): Illuminate\\Database\\Eloquent\\Model->__call('updateOrCreate', Array) #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Repositories\\IrResultExportRepository.php(131): Illuminate\\Database\\Eloquent\\Model::__callStatic('updateOrCreate', Array) #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Services\\IrResultExportService.php(260): App\\Repositories\\IrResultExportRepository->updateOrCreate('54', Array) #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Http\\Controllers\\ApiThermalResultController.php(185): App\\Services\\IrResultExportService->updateOrCreate('54', Array) #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalResultController->updatebyId(Object(Illuminate\\Http\\Request), '54') #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('updatebyId', Array) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalResultController), 'updatebyId') #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(63): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_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)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #53 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #54 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #55 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #56 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #57 {main} [previous exception] [object] (PDOException(code: 23502): SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"box_name\" of relation \"ir_report_records\" violates not-null constraint DETAIL: Failing row contains (530, 54, 275, 2024-06-15, FLIR THERMOGRAPHY, 會議室, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., 2024-09-03 16:13:24, 2024-09-03 16:13:48, null, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_th..., 0, 1, thermal_results/9/12/54/76/xdehQx6E2A1QcEB60aN8E2d9vY4QSd_box_vi..., null). at C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:526) [stacktrace] #0 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(526): PDOStatement->execute() #1 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('update \"ir_repo...', Array) #2 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('update \"ir_repo...', Array, Object(Closure)) #3 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(533): Illuminate\\Database\\Connection->run('update \"ir_repo...', Array, Object(Closure)) #4 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(466): Illuminate\\Database\\Connection->affectingStatement('update \"ir_repo...', Array) #5 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(3063): Illuminate\\Database\\Connection->update('update \"ir_repo...', Array) #6 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(921): Illuminate\\Database\\Query\\Builder->update(Array) #7 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(1072): Illuminate\\Database\\Eloquent\\Builder->update(Array) #8 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(987): Illuminate\\Database\\Eloquent\\Model->performUpdate(Object(Illuminate\\Database\\Eloquent\\Builder)) #9 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(509): Illuminate\\Database\\Eloquent\\Model->save() #10 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\helpers.php(263): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\IrReportRecord)) #11 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(510): tap(Object(App\\Models\\IrReportRecord), Object(Closure)) #12 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->updateOrCreate(Array, Array) #13 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2132): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'updateOrCreate', Array) #14 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Model.php(2144): Illuminate\\Database\\Eloquent\\Model->__call('updateOrCreate', Array) #15 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Repositories\\IrResultExportRepository.php(131): Illuminate\\Database\\Eloquent\\Model::__callStatic('updateOrCreate', Array) #16 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Services\\IrResultExportService.php(260): App\\Repositories\\IrResultExportRepository->updateOrCreate('54', Array) #17 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\app\\Http\\Controllers\\ApiThermalResultController.php(185): App\\Services\\IrResultExportService->updateOrCreate('54', Array) #18 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ApiThermalResultController->updatebyId(Object(Illuminate\\Http\\Request), '54') #19 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('updatebyId', Array) #20 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ApiThermalResultController), 'updatebyId') #21 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #22 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #23 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #24 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(63): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #28 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), '500', '1') #29 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'sub-api') #31 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #32 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #33 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #34 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #35 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #36 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #37 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #38 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #39 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_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)) #40 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #44 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #45 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #46 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #53 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #54 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #55 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #56 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #57 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #58 C:\\AppServ\\Apache\\2.4.58\\htdocs\\isha_hotbee\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #59 {main} "}