APID

Internal Server Error

Illuminate\Database\QueryException

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

SQLSTATE[HY000] [1040] Too many connections (Connection: mysql_forums, Host: 127.0.0.1, Port: 3306, Database: apidforums, SQL: select `post_id` from `sone_forums_trans_posts` where `slug` = minimalisticheskiy-dizayn-kottedzha and (`site_id` = 8 or `site_id` is null) and `deleted_at` is null limit 1)

LARAVEL 13.17.0

PHP 8.4.15

UNHANDLED

CODE 1040

500

GET

https://apid.im/v1/forums/posts/minimalisticheskiy-dizayn-kottedzha?lang=ru&page=1&per_page=20&site_id=8

Exception trace

1 previous exception

6 vendor frames

Illuminate\Database\Connection->runQueryCallback()

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

Illuminate\Database\Connection->runQueryCallback()

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

Illuminate\Database\Connection->run()

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

Illuminate\Database\Connection->select()

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

Illuminate\Database\Query\Builder->runSelect()

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

Illuminate\Database\Query\Builder->get()

vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:366

Illuminate\Database\Query\Builder->first()

packages/sonecms/sone-forums/src/app/Support/ForumApiPayload.php:925

920            ->where('slug', $slug)921            ->when($siteId > 0, static fn ($q) => $q->where(function ($w) use ($siteId) {922                $w->where('site_id', $siteId)->orWhereNull('site_id');923            }))924            ->whereNull('deleted_at')925            ->first(['post_id']);926927        return $row ? (int) $row->post_id : null;928    }929930    private function breadcrumbs(object $forum, ?object $category, array $forumTrans, array $forumSlugs, array $categoryTrans, array $categorySlugs, ?array $post = null): array931    {932        $items = [[933            'label' => 'Community',934            'to' => '/community',935        ]];936937

sOne\Forums\app\Support\ForumApiPayload->resolvePostId()

packages/sonecms/sone-forums/src/app/Support/ForumApiPayload.php:203

198199    public function post(Request $request, string $slug): array200    {201        $siteId = $this->siteId($request);202        $this->locale = $this->locale($request);203        $postId = $this->resolvePostId($slug, $siteId);204205        if (!$postId) {206            abort(404, 'Forum post not found');207        }208209        $post = $this->table('forums_posts')210            ->where('id', $postId)211            ->when($siteId > 0, static fn ($q) => $q->where('site_id', $siteId))212            ->where('status', 1)213            ->whereNull('deleted_at')214            ->first();215

sOne\Forums\app\Support\ForumApiPayload->post()

packages/sonecms/sone-forums/src/app/Http/Controllers/Api/v1/ForumsPostsController.php:26

21        return $this->json($payload['posts'] ?? ['data' => []]);22    }2324    public function show(Request $request, string $slug, ForumApiPayload $api): JsonResponse25    {26        return $this->json($api->post($request, $slug));27    }2829    public function create(Request $request, ForumApiPayload $api): JsonResponse30    {31        return $this->json($api->createPost($request), 201);32    }3334    public function count(Request $request): JsonResponse35    {36        $query = Post::query()->where('status', 1);37        if ($request->filled('site_id')) {38

12 vendor frames

sOne\Forums\app\Http\Controllers\Api\v1\ForumsPostsController->show()

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

Illuminate\Routing\ControllerDispatcher->dispatch()

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

Illuminate\Routing\Route->runController()

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

Illuminate\Routing\Route->run()

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

Illuminate\Routing\Router->{closure:Illuminate\Routing\Router::runRouteWithinStack():821}()

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

Illuminate\Pipeline\Pipeline->{closure:Illuminate\Pipeline\Pipeline::prepareDestination():178}()

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

Illuminate\Pipeline\Pipeline->then()

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

Illuminate\Routing\Router->runRouteWithinStack()

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

Illuminate\Routing\Router->runRoute()

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

Illuminate\Routing\Router->dispatchToRoute()

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

Illuminate\Routing\Router->dispatch()

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

Illuminate\Foundation\Http\Kernel->{closure:Illuminate\Foundation\Http\Kernel::dispatchToRouter():197}()

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

Illuminate\Pipeline\Pipeline->{closure:Illuminate\Pipeline\Pipeline::prepareDestination():178}()

packages/sonecms/sone-api/src/app/Http/Middleware/ApiKeyAuth.php:65

60        $request->attributes->set('api_key_id', $keyId);61        $request->attributes->set('api_key_pk', $cached['id']);62        $request->attributes->set('api_owner_site_id', $cached['owner_site_id']);63        $request->attributes->set('api_scope', $cached['scope'] ?? []);6465        return $next($request);66    }6768    private function forbidden(string $msg): Response69    {70        return response()->json([71            'error' => true,72            'message' => $msg,73        ], 403);74    }75}76

sOne\Api\app\Http\Middleware\ApiKeyAuth->handle()

packages/sonecms/sone-api/src/app/Http/Middleware/ApiKeyGate.php:42

3738        if (!$shouldProtect) {39            return $next($request);40        }4142        return app(ApiKeyAuth::class)->handle($request, $next);43    }44}45

23 vendor frames

sOne\Api\app\Http\Middleware\ApiKeyGate->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()

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

Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()

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

Illuminate\Foundation\Http\Middleware\TrimStrings->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Http\Middleware\ValidatePostSize->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Http\Middleware\HandleCors->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Http\Middleware\TrustProxies->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Foundation\Http\Middleware\InvokeDeferredCallbacks->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php:28

Illuminate\Http\Middleware\ValidatePathEncoding->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Pipeline\Pipeline->then()

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

Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()

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

Illuminate\Foundation\Http\Kernel->handle()

vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1220

Illuminate\Foundation\Application->handleRequest()

public/index.php:17

12// Register the Composer autoloader...13require __DIR__.'/../vendor/autoload.php';1415// Bootstrap Laravel and handle the request...16(require_once __DIR__.'/../bootstrap/app.php')17    ->handleRequest(Request::capture());18

Previous exception

PDOException

SQLSTATE[HY000] [1040] Too many connections

15 vendor frames

PDO::connect()

vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:67

PDO::connect()

vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:67

Illuminate\Database\Connectors\Connector->createPdoConnection()

vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:44

Illuminate\Database\Connectors\Connector->createConnection()

vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php:24

Illuminate\Database\Connectors\MySqlConnector->connect()

vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:220

call_user_func()

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

Illuminate\Database\Connection->getPdo()

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

Illuminate\Database\Connection->getReadPdo()

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

Illuminate\Database\Connection->getPdoForSelect()

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

Illuminate\Database\Connection->{closure:Illuminate\Database\Connection::select():426}()

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

Illuminate\Database\Connection->runQueryCallback()

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

Illuminate\Database\Connection->run()

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

Illuminate\Database\Connection->select()

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

Illuminate\Database\Query\Builder->runSelect()

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

Illuminate\Database\Query\Builder->get()

vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:366

Illuminate\Database\Query\Builder->first()

packages/sonecms/sone-forums/src/app/Support/ForumApiPayload.php:925

920            ->where('slug', $slug)921            ->when($siteId > 0, static fn ($q) => $q->where(function ($w) use ($siteId) {922                $w->where('site_id', $siteId)->orWhereNull('site_id');923            }))924            ->whereNull('deleted_at')925            ->first(['post_id']);926927        return $row ? (int) $row->post_id : null;928    }929930    private function breadcrumbs(object $forum, ?object $category, array $forumTrans, array $forumSlugs, array $categoryTrans, array $categorySlugs, ?array $post = null): array931    {932        $items = [[933            'label' => 'Community',934            'to' => '/community',935        ]];936937

sOne\Forums\app\Support\ForumApiPayload->resolvePostId()

packages/sonecms/sone-forums/src/app/Support/ForumApiPayload.php:203

198199    public function post(Request $request, string $slug): array200    {201        $siteId = $this->siteId($request);202        $this->locale = $this->locale($request);203        $postId = $this->resolvePostId($slug, $siteId);204205        if (!$postId) {206            abort(404, 'Forum post not found');207        }208209        $post = $this->table('forums_posts')210            ->where('id', $postId)211            ->when($siteId > 0, static fn ($q) => $q->where('site_id', $siteId))212            ->where('status', 1)213            ->whereNull('deleted_at')214            ->first();215

sOne\Forums\app\Support\ForumApiPayload->post()

packages/sonecms/sone-forums/src/app/Http/Controllers/Api/v1/ForumsPostsController.php:26

21        return $this->json($payload['posts'] ?? ['data' => []]);22    }2324    public function show(Request $request, string $slug, ForumApiPayload $api): JsonResponse25    {26        return $this->json($api->post($request, $slug));27    }2829    public function create(Request $request, ForumApiPayload $api): JsonResponse30    {31        return $this->json($api->createPost($request), 201);32    }3334    public function count(Request $request): JsonResponse35    {36        $query = Post::query()->where('status', 1);37        if ($request->filled('site_id')) {38

12 vendor frames

sOne\Forums\app\Http\Controllers\Api\v1\ForumsPostsController->show()

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

Illuminate\Routing\ControllerDispatcher->dispatch()

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

Illuminate\Routing\Route->runController()

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

Illuminate\Routing\Route->run()

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

Illuminate\Routing\Router->{closure:Illuminate\Routing\Router::runRouteWithinStack():821}()

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

Illuminate\Pipeline\Pipeline->{closure:Illuminate\Pipeline\Pipeline::prepareDestination():178}()

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

Illuminate\Pipeline\Pipeline->then()

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

Illuminate\Routing\Router->runRouteWithinStack()

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

Illuminate\Routing\Router->runRoute()

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

Illuminate\Routing\Router->dispatchToRoute()

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

Illuminate\Routing\Router->dispatch()

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

Illuminate\Foundation\Http\Kernel->{closure:Illuminate\Foundation\Http\Kernel::dispatchToRouter():197}()

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

Illuminate\Pipeline\Pipeline->{closure:Illuminate\Pipeline\Pipeline::prepareDestination():178}()

packages/sonecms/sone-api/src/app/Http/Middleware/ApiKeyAuth.php:65

60        $request->attributes->set('api_key_id', $keyId);61        $request->attributes->set('api_key_pk', $cached['id']);62        $request->attributes->set('api_owner_site_id', $cached['owner_site_id']);63        $request->attributes->set('api_scope', $cached['scope'] ?? []);6465        return $next($request);66    }6768    private function forbidden(string $msg): Response69    {70        return response()->json([71            'error' => true,72            'message' => $msg,73        ], 403);74    }75}76

sOne\Api\app\Http\Middleware\ApiKeyAuth->handle()

packages/sonecms/sone-api/src/app/Http/Middleware/ApiKeyGate.php:42

3738        if (!$shouldProtect) {39            return $next($request);40        }4142        return app(ApiKeyAuth::class)->handle($request, $next);43    }44}45

23 vendor frames

sOne\Api\app\Http\Middleware\ApiKeyGate->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()

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

Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()

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

Illuminate\Foundation\Http\Middleware\TrimStrings->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Http\Middleware\ValidatePostSize->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Http\Middleware\HandleCors->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Http\Middleware\TrustProxies->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Foundation\Http\Middleware\InvokeDeferredCallbacks->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php:28

Illuminate\Http\Middleware\ValidatePathEncoding->handle()

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

Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()

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

Illuminate\Pipeline\Pipeline->then()

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

Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()

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

Illuminate\Foundation\Http\Kernel->handle()

vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1220

Illuminate\Foundation\Application->handleRequest()

public/index.php:17

12// Register the Composer autoloader...13require __DIR__.'/../vendor/autoload.php';1415// Bootstrap Laravel and handle the request...16(require_once __DIR__.'/../bootstrap/app.php')17    ->handleRequest(Request::capture());18

Queries

// No queries executed

Headers

cf-visitor

{"scheme":"https"}

cf-ipcountry

cf-connecting-ip

2003:f5:a700:f600:be24:11ff:fef8:f23

cdn-loop

cloudflare; loops=1

x-api-key

01K3JX4C40FEVRN49CBMVF0HF4.979993859b7655877fd354a109066889b64268453e82adea153d77c26a3f9833

sec-fetch-mode

cors

cf-ray

a2fde4c74b26ec0d-LHR

user-agent

node

accept-encoding

gzip, br

accept-language

*/*

x-forwarded-server

apid.im

connection

x-forwarded-proto

https

x-forwarded-for

2003:f5:a700:f600:be24:11ff:fef8:f23, 172.68.229.221, 172.68.229.221

x-real-ip

172.68.229.221

x-forwarded-host

apid.im

host

apid.im

Body

{
    "site_id": "8",
    "lang": "ru",
    "page": "1",
    "per_page": "20"
}

Routing

controller

sOne\Forums\app\Http\Controllers\Api\v1\ForumsPostsController@show

route name

forums.posts.by-slug

Routing parameters

{
    "slug": "minimalisticheskiy-dizayn-kottedzha"
}