Laravel

Illuminate\Database\QueryException QueryException

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "administraciia-veleiskoi-volosti" CONTEXT: unnamed portal parameter $3 = '...' (Connection: pgsql, SQL: select count(*) as aggregate from "publications" where "is_published" = 1 and "banned" = 0 and exists (select * from "companies" where "publications"."company_id" = "companies"."id" and "ogrn" = administraciia-veleiskoi-volosti))

GET api.marketplace.stranke.ru

PHP 8.4.14 — Laravel 11.44.2

10 vendor frames collapsed

5 vendor frames collapsed

33 vendor frames collapsed

vendor/laravel/framework/src/Illuminate/Database/Connection.php :825

vendor/laravel/framework/src/Illuminate/Database/Connection.php :779

vendor/laravel/framework/src/Illuminate/Database/Connection.php :398

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3106

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3091

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3676

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3090

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3285

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3244

vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php :1029

app/Services/Front/Public/PublicationService.php :41

app/Http/Controllers/Front/V1/Public/PublicationController.php :28

vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php :47

vendor/laravel/framework/src/Illuminate/Routing/Route.php :266

vendor/laravel/framework/src/Illuminate/Routing/Route.php :212

vendor/laravel/framework/src/Illuminate/Routing/Router.php :808

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :170

app/Http/Middleware/OptionalJwtAuth.php :52

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209

vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php :51

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :127

vendor/laravel/framework/src/Illuminate/Routing/Router.php :807

vendor/laravel/framework/src/Illuminate/Routing/Router.php :786

vendor/laravel/framework/src/Illuminate/Routing/Router.php :750

vendor/laravel/framework/src/Illuminate/Routing/Router.php :739

vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :201

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :170

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php :31

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php :51

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209

vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php :27

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php :110

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209

vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php :62

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209

vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php :58

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php :22

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :127

vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :176

vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :145

vendor/laravel/octane/src/ApplicationGateway.php :36

vendor/laravel/octane/src/Worker.php :84

vendor/laravel/octane/bin/frankenphp-worker.php :53

vendor/laravel/octane/bin/frankenphp-worker.php :74

public/frankenphp-worker.php :7

Request

GET /api/front/v1/publications

Headers

host

api.marketplace.stranke.ru

x-real-ip

172.17.0.2

x-forwarded-host

api.marketplace.stranke.ru

x-forwarded-port

*/*

accept-encoding

br, gzip, deflate

connection

close

forwarded

for=172.17.0.2

x-forwarded-for

172.17.0.2

x-forwarded-proto

https

accept-language

sec-fetch-mode

cors

user-agent

node

Body

{
    "page": "1",
    "limit": "4",
    "order": "desc",
    "key": "id",
    "ogrn": "administraciia-veleiskoi-volosti"
}

Application

Routing

controller

App\Http\Controllers\Front\V1\Public\PublicationController@index

middleware

api, App\Http\Middleware\OptionalJwtAuth

Database Queries

No query data

Публикации