Laravel

Internal Server Error

Illuminate\Database\QueryException

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

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'onmedia_laravel.insights' doesn't exist (Connection: mysql, SQL: select count(*) as aggregate from `insights` where `status` = published and `published_at` is not null and `published_at` <= 2026-02-10 00:45:58)

LARAVEL 12.39.0

PHP 8.3.6

UNHANDLED

CODE 42S02

500

GET

https://backofficeapi.onmedia.dev/api/public/insights?page=1&per_page=9&sort_by=created_at&sort_order=desc

Exception trace

10 vendor frames

Illuminate\Database\Connection->runQueryCallback()

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

Illuminate\Database\Connection->run()

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

Illuminate\Database\Connection->select()

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

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

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

Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()

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

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

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

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

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

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

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

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

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

Illuminate\Database\Eloquent\Builder->paginate()

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

App\Http\Controllers\Public\InsightController->index()

app/Http/Controllers/Public/InsightController.php:64

59                $q->where('slug', $authorSlug);60            });61        }6263        $perPage = $request->get('per_page', 9);64        $insights = $query->paginate($perPage);6566        return InsightResource::collection($insights);67    }6869    /**70     * Resolve the locale to use for search (query param or Accept-Language header).71     * Allowed: es, en, pt. Default: es.72     */73    private function resolveSearchLocale(Request $request): string74    {75        $allowed = ['es', 'en', 'pt'];76

7 vendor frames

Illuminate\Routing\ControllerDispatcher->dispatch()

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

Illuminate\Routing\Route->runController()

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

Illuminate\Routing\Route->run()

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

Illuminate\Routing\Router->Illuminate\Routing\{closure}()

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

Illuminate\Routing\Middleware\SubstituteBindings->handle()

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

App\Http\Middleware\SetLocale->handle()

app/Http/Middleware/SetLocale.php:36

3132        // Set application locale33        App::setLocale($locale);3435        // Process request36        $response = $next($request);3738        // Save locale preference in cookie (30 days)39        if ($response instanceof Response) {40            $response->headers->setCookie(41                Cookie::make('locale', $locale, 43200, null, null, false, false)42            );43        }4445        return $response;46    }4748

32 vendor frames

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

Illuminate\Pipeline\Pipeline->then()

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

Illuminate\Routing\Router->runRouteWithinStack()

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

Illuminate\Routing\Router->runRoute()

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

Illuminate\Routing\Router->dispatchToRoute()

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

Illuminate\Routing\Router->dispatch()

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

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

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

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

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()

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

Illuminate\Pipeline\Pipeline->then()

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

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

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

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

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

Illuminate\Foundation\Application->handleRequest()

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

public/index.php

public/index.php:20

1516// Bootstrap Laravel and handle the request...17/** @var Application $app */18$app = require_once __DIR__.'/../bootstrap/app.php';1920$app->handleRequest(Request::capture());21

Queries

// No queries executed

Headers

accept-encoding

br, gzip, deflate

user-agent

node

sec-fetch-mode

cors

accept-language

*/*

connection

keep-alive

host

backofficeapi.onmedia.dev

Body

{
    "per_page": "9",
    "page": "1",
    "sort_by": "created_at",
    "sort_order": "desc"
}

Routing

controller

App\Http\Controllers\Public\InsightController@index

route name

generated::8O1EBuRW1QQRqONv

middleware

api

Routing parameters

// No routing parameters

Insights