Laravel

Internal Server Error

Illuminate\Database\QueryException

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

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sustainability_documents" does not exist LINE 1: select count(*) as aggregate from "sustainability_documents"... ^ (Connection: pgsql, Host: cambodia-destination-db-uo8e5u, Port: 5432, Database: postgres, SQL: select count(*) as aggregate from "sustainability_documents" where "status" = 1)

LARAVEL 12.58.0

PHP 8.3.31

UNHANDLED

CODE 42P01

500

GET

https://api.angkordestination.com/api/v1/web/get-sustainability?page=1

Exception trace

10 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:3505

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

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

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

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

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

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

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

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

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

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

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

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

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

app/Http/Controllers/Api/V1/Website/Content/SustainabilityController.php:19

14{15    public function index()16    {17        $pageContent = PageContent::where('slug', 'sustainability')->first();18        $sustainability = Sustainability::where('status', 1)->orderBy('id', 'asc')->get();19        $sustainabilityDocument = SustainabilityDocument::where('status', 1)->orderBy('order', 'asc')->paginate(4);20        return response()->json([21            'pageContent' => $pageContent ? new PageContentResource($pageContent) : null,22            'sustainability' => SustainabilityResource::collection($sustainability),23            'sustainabilityDocuments' => SustainabilityDocumentResource::collection($sustainabilityDocument),24            'sustainabilityDocument_pagination' => [25                'current_page' => $sustainabilityDocument->currentPage(),26                'last_page' => $sustainabilityDocument->lastPage(),27                'per_page' => $sustainabilityDocument->perPage(),28                'total' => $sustainabilityDocument->total(),29            ],30        ]);31

48 vendor frames

App\Http\Controllers\Api\V1\Website\Content\SustainabilityController->index()

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\Content\SustainabilityController), 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')

19.59ms

pgsql

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

1.13ms

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.31ms

pgsql

select * from "page_contents" where "slug" = 'sustainability' limit 1

1.65ms

pgsql

select * from "sustainabilities" where "status" = 1 order by "id" asc

1.33ms

Headers

x-real-ip

172.20.0.1

x-forwarded-server

650fdd9421ea

x-forwarded-proto

https

x-forwarded-port

443

x-forwarded-host

api.angkordestination.com

x-forwarded-for

172.20.0.1

sec-fetch-mode

cors

locale

accept-language

accept-encoding

br, gzip, deflate

*/*

user-agent

node

host

api.angkordestination.com

Body

{
    "page": "1"
}

Routing

controller

App\Http\Controllers\Api\V1\Website\Content\SustainabilityController@index

route name

generated::OKbYnzOE2w6p4O3P

middleware

api

Routing parameters

// No routing parameters

Sustainability Framework

Ready to Explore Cambodia?