SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type json DETAIL: The input string ended unexpectedly. CONTEXT: JSON data, line 1: (Connection: pgsql, SQL: insert into "response_error_logs" ("ind_id", "station_id", "device_id", "response", "vendor_id", "message") values (JRC_0_4_1, 1, , , 19, SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type json DETAIL: The input string ended unexpectedly. CONTEXT: JSON data, line 1: (Connection: pgsql, SQL: insert into "response_error_logs" ("ind_id", "station_id", "device_id", "response", "vendor_id", "message") values (JRC_0_4_1, 1, , , 19, No data to provided in response) returning "id")) returning "id")

Notice: Undefined variable: payload in C:\xampp\htdocs\PPCB\test.php on line 19
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type json DETAIL: The input string ended unexpectedly. CONTEXT: JSON data, line 1: (Connection: pgsql, SQL: insert into "response_error_logs" ("ind_id", "station_id", "device_id", "response", "vendor_id", "message") values (JRC_0_4_1, 1, , , 19, SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type json DETAIL: The input string ended unexpectedly. CONTEXT: JSON data, line 1: (Connection: pgsql, SQL: insert into "response_error_logs" ("ind_id", "station_id", "device_id", "response", "vendor_id", "message") values (JRC_0_4_1, 1, , , 19, No data to provided in response) returning "id")) returning "id")

Illuminate\Database\QueryException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type json DETAIL: The input string ended unexpectedly. CONTEXT: JSON data, line 1: (Connection: pgsql, SQL: insert into "response_error_logs" ("ind_id", "station_id", "device_id", "response", "vendor_id", "message") values (JRC_0_4_1, 1, , , 19, SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type json DETAIL: The input string ended unexpectedly. CONTEXT: JSON data, line 1: (Connection: pgsql, SQL: insert into "response_error_logs" ("ind_id", "station_id", "device_id", "response", "vendor_id", "message") values (JRC_0_4_1, 1, , , 19, No data to provided in response) returning "id")) returning "id") in file /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 829 #0 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback('insert into "re...', Array, Object(Closure)) #1 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\Database\Connection->run('insert into "re...', Array, Object(Closure)) #2 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(401): Illuminate\Database\Connection->select('insert into "re...', Array, false) #3 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/PostgresProcessor.php(24): Illuminate\Database\Connection->selectFromWriteConnection('insert into "re...', Array) #4 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3549): Illuminate\Database\Query\Processors\PostgresProcessor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into "re...', Array, 'id') #5 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1982): Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #6 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1334): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #7 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1299): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #8 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder)) #9 /opt/lampp/htdocs/ppcpcb-api/app/Models/ResponseErrorLog.php(31): Illuminate\Database\Eloquent\Model->save() #10 /opt/lampp/htdocs/ppcpcb-api/app/Http/Controllers/ResponseController.php(602): App\Models\ResponseErrorLog->logError(Array, 19, 'JRC_0_4_1', '1', NULL, 'SQLSTATE[22P02]...') #11 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\ResponseController->getHrStationResponse(Object(Illuminate\Http\Request), 'JRC_0_4_1', '1') #12 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction('getHrStationRes...', Array) #13 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\ResponseController), 'getHrStationRes...') #14 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #15 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\Routing\Route->run() #16 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #17 /opt/lampp/htdocs/ppcpcb-api/app/Http/Middleware/Cors.php(29): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #18 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\Cors->handle(Object(Illuminate\Http\Request), Object(Closure)) #19 /opt/lampp/htdocs/ppcpcb-api/app/Http/Middleware/ValidateVendorToken.php(33): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #20 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\ValidateVendorToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #21 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #22 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(159): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(125): Illuminate\Routing\Middleware\ThrottleRequests->handleRequest(Object(Illuminate\Http\Request), Object(Closure), Array) #25 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\Http\Request), Object(Closure), 'api', Object(Closure)) #26 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), 'api') #27 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #28 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Laravel\Sanctum\Http\Middleware\EnsureFrontendRequestsAreStateful->Laravel\Sanctum\Http\Middleware\{closure}(Object(Illuminate\Http\Request)) #29 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(24): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #31 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Laravel\Sanctum\Http\Middleware\EnsureFrontendRequestsAreStateful->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #34 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #35 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #36 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #37 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #38 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #39 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #40 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure)) #42 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #43 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure)) #45 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #46 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #50 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure)) #51 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #52 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #53 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #54 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #55 /opt/lampp/htdocs/ppcpcb-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #56 /opt/lampp/htdocs/ppcpcb-api/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #57 {main}