Laravel

Internal Server Error

Illuminate\Database\QueryException

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

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "destination_detail_section" does not exist LINE 1: select * from "destination_detail_section" where "status" = ... ^ (Connection: pgsql, Host: dev-cambodia-destination-db-tpobds, Port: 5432, Database: postgres, SQL: select * from "destination_detail_section" where "status" = 1 order by "id" desc)

LARAVEL 12.52.0

PHP 8.3.30

UNHANDLED

CODE 42P01

500

GET

https://api.cambodia-destination.d.aditidemo.asia/api/v1/web/get-destination/phnom-penh-tes

Exception trace

9 vendor frames

Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))

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

Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))

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

Illuminate\Database\Connection->run(string, array, object(Closure))

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

Illuminate\Database\Connection->select(string, array, boolean)

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

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

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

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

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

Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))

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

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

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

Illuminate\Database\Eloquent\Builder->getModels(array)

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

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

app/Http/Controllers/Api/V1/Website/Destination/DestinationController.php:153

148        if (!$user && ($token = request()->bearerToken())) {149            $accessToken = PersonalAccessToken::findToken($token);150            $user = $accessToken?->tokenable;151        }152153        $destinationDetailSection = DestinationDetailSection::where('status', '1')->orderBy('id','desc')->get();154155156        $destination = Destination::where('slug', $slug)157            ->where('status', 1)158            ->with([159                'tours' => function ($q) use ($user) {160                    $q->with(['categories', 'extraActivity', 'foods'])161                        ->withCount(['reviews' => fn ($r) => $r->where('status', '2')])162                        ->withAvg(['reviews' => fn ($r) => $r->where('status', '2')], 'rating');163                    if ($user) {164                        $q->withExists(['wishlists as is_wishlisted' => fn ($w) => $w->where('user_id', $user->id)]);165

48 vendor frames

App\Http\Controllers\Api\V1\Website\Destination\DestinationController->show(string)

vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Illuminate\Routing\Controller->callAction(string, array)

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

Illuminate\Routing\ControllerDispatcher->dispatch(object(Illuminate\Routing\Route), object(App\Http\Controllers\Api\V1\Website\Destination\DestinationController), string)

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

Illuminate\Routing\Route->runController()

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

Illuminate\Routing\Route->run()

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

Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Pipeline\Pipeline->then(object(Closure))

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

Illuminate\Routing\Router->runRouteWithinStack(object(Illuminate\Routing\Route), object(Illuminate\Http\Request))

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

Illuminate\Routing\Router->runRoute(object(Illuminate\Http\Request), object(Illuminate\Routing\Route))

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

Illuminate\Routing\Router->dispatchToRoute(object(Illuminate\Http\Request))

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

Illuminate\Routing\Router->dispatch(object(Illuminate\Http\Request))

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

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

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Http\Middleware\ValidatePostSize->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Http\Middleware\TrustProxies->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustHosts.php:78

Illuminate\Http\Middleware\TrustHosts->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Http\Middleware\ValidatePostSize->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Http\Middleware\HandleCors->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Http\Middleware\TrustProxies->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Foundation\Http\Middleware\InvokeDeferredCallbacks->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Http\Middleware\ValidatePathEncoding->handle(object(Illuminate\Http\Request), object(Closure))

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

Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))

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

Illuminate\Pipeline\Pipeline->then(object(Closure))

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

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

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

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

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

Illuminate\Foundation\Application->handleRequest(object(Illuminate\Http\Request))

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

pgsql

select * from "cache" where "key" in ('laravel_cache_telescope:dump-watcher')

28.36ms

pgsql

select * from "cache" where "key" in ('laravel_cache_telescope:pause-recording')

0.93ms

pgsql

select exists (select 1 from pg_class c, pg_namespace n where n.nspname = current_schema() and c.relname = 'permissions' and c.relkind in ('r', 'p') and n.oid = c.relnamespace)

2.64ms

Headers

x-real-ip

172.17.0.1

x-forwarded-server

fa47a3e973d8

x-forwarded-proto

https

x-forwarded-port

443

x-forwarded-host

api.cambodia-destination.d.aditidemo.asia

x-forwarded-for

172.17.0.1

sec-fetch-mode

cors

locale

accept-language

accept-encoding

br, gzip, deflate

*/*

user-agent

node

host

api.cambodia-destination.d.aditidemo.asia

Body

// No request body

Routing

controller

App\Http\Controllers\Api\V1\Website\Destination\DestinationController@show

route name

generated::QI1bCJs5M0dVfvqa

middleware

api

Routing parameters

{
    "slug": "phnom-penh-tes"
}

About

Quick Facts

Ready to Explore Cambodia?