Flare Laravel Error Tracking
Get all these insights and more when you sign up for FlareLearn more
This is a public shared error.
Illuminate \ Database \ QueryException
PHP 
SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "person" LINE 1: ...t(*) as aggregate from "care_takers" where (lower(person.fir... ^
select count(*) as aggregate from "care_takers" where (lower(person.first_name::text)::text like %sear% or lower(person.middle_name::text)::text like %sear% or lower(person.last_name::text)::text like %sear% or exists (select * from "people" where "care_takers"."person_id" = "people"."id" and lower(email::text)::text like %sear% and "people"."deleted_at" is null))

App

Routing

Action
Livewire\Mechanisms\HandleRequests\HandleRequests@handleUpdate
Route name
livewire.update
Middleware
  • web

Browser

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36

Request

http://127.0.0.1/admin/care-takers
GET
curl "http://127.0.0.1/admin/care-takers" \
   -X GET \
   -H 'host: 127.0.0.1:8000' \
   -H 'connection: keep-alive' \
   -H 'content-length: 1956' \
   -H 'sec-ch-ua: "Google Chrome";v="125", "Chromium";v="125", "Not.A/Brand";v="24"' \
   -H 'content-type: application/json' \
   -H 'sec-ch-ua-mobile: ?0' \
   -H 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36' \
   -H 'sec-ch-ua-platform: "Windows"' \
   -H 'accept: */*' \
   -H 'origin: http://127.0.0.1:8000' \
   -H 'sec-fetch-site: same-origin' \
   -H 'sec-fetch-mode: cors' \
   -H 'sec-fetch-dest: empty' \
   -H 'referer: http://127.0.0.1:8000/admin/care-takers?tableSearch=sear' \
   -H 'accept-encoding: gzip, deflate, br, zstd' \
   -H 'accept-language: en-US,en;q=0.9,nl-NL;q=0.8,nl;q=0.7' \
   -H 'cookie: <CENSORED>' \
   -d {"_token":"IIvfRVwJpZeBDqFtrRzNa9DtybqNT3XxrV5tQ6zx","components":[{"snapshot":"{\"data\":{\"isTableReordering\":false,\"tableFilters\":null,\"tableGrouping\":null,\"tableGroupingDirection\":null,\"tableSearch\":\"\",\"tableSortColumn\":null,\"tableSortDirection\":null,\"activeTab\":\"all\",\"mountedActions\":[[],{\"s\":\"arr\"}],\"mountedActionsArguments\":[[],{\"s\":\"arr\"}],\"mountedActionsData\":[[],{\"s\":\"arr\"}],\"defaultAction\":null,\"defaultActionArguments\":null,\"componentFileAttachments\":[[],{\"s\":\"arr\"}],\"mountedFormComponentActions\":[[],{\"s\":\"arr\"}],\"mountedFormComponentActionsArguments\":[[],{\"s\":\"arr\"}],\"mountedFormComponentActionsData\":[[],{\"s\":\"arr\"}],\"mountedFormComponentActionsComponents\":[[],{\"s\":\"arr\"}],\"mountedInfolistActions\":[[],{\"s\":\"arr\"}],\"mountedInfolistActionsData\":[[],{\"s\":\"arr\"}],\"mountedInfolistActionsComponent\":null,\"mountedInfolistActionsInfolist\":null,\"isTableLoaded\":false,\"tableRecordsPerPage\":10,\"tableColumnSearches\":[[],{\"s\":\"arr\"}],\"toggledTableColumns\":[[],{\"s\":\"arr\"}],\"mountedTableActions\":[[],{\"s\":\"arr\"}],\"mountedTableActionsData\":[[],{\"s\":\"arr\"}],\"mountedTableActionsArguments\":[[],{\"s\":\"arr\"}],\"mountedTableActionRecord\":null,\"defaultTableAction\":null,\"defaultTableActionArguments\":null,\"defaultTableActionRecord\":null,\"selectedTableRecords\":[[],{\"s\":\"arr\"}],\"mountedTableBulkAction\":null,\"mountedTableBulkActionData\":[[],{\"s\":\"arr\"}],\"tableDeferredFilters\":null,\"paginators\":[{\"page\":1},{\"s\":\"arr\"}]},\"memo\":{\"id\":\"hdJwI795M1WqjToX1xFg\",\"name\":\"app.filament.resources.care-taker-resource.pages.list-care-takers\",\"path\":\"admin\\/care-takers\",\"method\":\"GET\",\"children\":[],\"scripts\":[],\"assets\":[],\"errors\":[],\"locale\":\"nl\"},\"checksum\":\"61e2ff2ba13b4253dbc649ef0b7c4f4b1715572f5de5a9995717e8adf82b39ca\"}","updates":{"tableSearch":"sear"},"calls":[]}]}

Views

File

Headers

host
127.0.0.1:8000
connection
keep-alive
content-length
1956
sec-ch-ua
"Google Chrome";v="125", "Chromium";v="125", "Not.A/Brand";v="24"
content-type
application/json
sec-ch-ua-mobile
?0
user-agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36
sec-ch-ua-platform
"Windows"
accept
*/*
origin
http://127.0.0.1:8000
sec-fetch-site
same-origin
sec-fetch-mode
cors
sec-fetch-dest
empty
referer
http://127.0.0.1:8000/admin/care-takers?tableSearch=sear
accept-encoding
gzip, deflate, br, zstd
accept-language
en-US,en;q=0.9,nl-NL;q=0.8,nl;q=0.7
cookie
<CENSORED>

Body

{
    "_token": "IIvfRVwJpZeBDqFtrRzNa9DtybqNT3XxrV5tQ6zx",
    "components": [
        {
            "snapshot": "{\"data\":{\"isTableReordering\":false,\"tableFilters\":null,\"tableGrouping\":null,\"tableGroupingDirection\":null,\"tableSearch\":\"\",\"tableSortColumn\":null,\"tableSortDirection\":null,\"activeTab\":\"all\",\"mountedActions\":[[],{\"s\":\"arr\"}],\"mountedActionsArguments\":[[],{\"s\":\"arr\"}],\"mountedActionsData\":[[],{\"s\":\"arr\"}],\"defaultAction\":null,\"defaultActionArguments\":null,\"componentFileAttachments\":[[],{\"s\":\"arr\"}],\"mountedFormComponentActions\":[[],{\"s\":\"arr\"}],\"mountedFormComponentActionsArguments\":[[],{\"s\":\"arr\"}],\"mountedFormComponentActionsData\":[[],{\"s\":\"arr\"}],\"mountedFormComponentActionsComponents\":[[],{\"s\":\"arr\"}],\"mountedInfolistActions\":[[],{\"s\":\"arr\"}],\"mountedInfolistActionsData\":[[],{\"s\":\"arr\"}],\"mountedInfolistActionsComponent\":null,\"mountedInfolistActionsInfolist\":null,\"isTableLoaded\":false,\"tableRecordsPerPage\":10,\"tableColumnSearches\":[[],{\"s\":\"arr\"}],\"toggledTableColumns\":[[],{\"s\":\"arr\"}],\"mountedTableActions\":[[],{\"s\":\"arr\"}],\"mountedTableActionsData\":[[],{\"s\":\"arr\"}],\"mountedTableActionsArguments\":[[],{\"s\":\"arr\"}],\"mountedTableActionRecord\":null,\"defaultTableAction\":null,\"defaultTableActionArguments\":null,\"defaultTableActionRecord\":null,\"selectedTableRecords\":[[],{\"s\":\"arr\"}],\"mountedTableBulkAction\":null,\"mountedTableBulkActionData\":[[],{\"s\":\"arr\"}],\"tableDeferredFilters\":null,\"paginators\":[{\"page\":1},{\"s\":\"arr\"}]},\"memo\":{\"id\":\"hdJwI795M1WqjToX1xFg\",\"name\":\"app.filament.resources.care-taker-resource.pages.list-care-takers\",\"path\":\"admin\\/care-takers\",\"method\":\"GET\",\"children\":[],\"scripts\":[],\"assets\":[],\"errors\":[],\"locale\":\"nl\"},\"checksum\":\"61e2ff2ba13b4253dbc649ef0b7c4f4b1715572f5de5a9995717e8adf82b39ca\"}",
            "updates": {
                "tableSearch": "sear"
            },
            "calls": []
        }
    ]
}

Session

_token
IIvfRVwJpZeBDqFtrRzNa9DtybqNT3XxrV5tQ6zx
url
[]
_previous
{
    "url": "http://127.0.0.1:8000/admin/care-takers"
}
_flash
{
    "old": [],
    "new": []
}
login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d
1
password_hash_web
$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi

Cookies

filament_language_switch_locale
null
remember_web_59ba36addc2b2f9401580f014c7f58ea4e30989d
1|XPDzNfCi4Q|$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi
XSRF-TOKEN
IIvfRVwJpZeBDqFtrRzNa9DtybqNT3XxrV5tQ6zx
laravel_session
WgOxx2W62u6p1cf5XbMKDngCNGPQbuMCeVqAamFu

Context

User

contact@danielvdspoel.nl

contact@danielvdspoel.nl

ID: 1

{
    "id": 1,
    "name": "Daniël van der Spoel2",
    "email": "contact@danielvdspoel.nl",
    "email_verified_at": "2024-06-08T12:02:34.000000Z",
    "avatar_url": null,
    "oauth_provider": null,
    "oauth_provider_id": null,
    "type": null,
    "created_at": "2024-06-08T12:02:34.000000Z",
    "updated_at": "2024-06-08T12:02:34.000000Z",
    "person_id": null,
    "breezy_sessions": [],
    "permissions": [],
    "roles": [
        {
            "id": 1,
            "name": "super_admin",
            "guard_name": "web",
            "created_at": "2024-06-08T12:02:33.000000Z",
            "updated_at": "2024-06-08T12:02:33.000000Z",
            "pivot": {
                "model_type": "App\\Models\\User",
                "model_id": 1,
                "role_id": 1
            }
        }
    ]
}

Versions

laravel version
10.48.12
Laravel locale
nl
Laravel config cached
false
Laravel debug
true
10:31:22 PM
Runtime 115.620096ms
Connection pgsql
select * from "users" where "id" = 1 limit 1
10:33:36 PM
Runtime 5.520128ms
Connection pgsql
select * from "breezy_sessions" where "breezy_sessions"."authenticatable_id" in (1) and "breezy_sessions"."authenticatable_type" = App\Models\User
10:35:27 PM
Runtime 3.689984ms
Connection pgsql
select "permissions".*, "model_has_permissions"."model_id" as "pivot_model_id", "model_has_permissions"."permission_id" as "pivot_permission_id", "model_has_permissions"."model_type" as "pivot_model_type" from "permissions" inner join "model_has_permissions" on "permissions"."id" = "model_has_permissions"."permission_id" where "model_has_permissions"."model_id" = 1 and "model_has_permissions"."model_type" = App\Models\User
10:35:34 PM
Runtime 3.510016ms
Connection pgsql
select "roles".*, "model_has_roles"."model_id" as "pivot_model_id", "model_has_roles"."role_id" as "pivot_role_id", "model_has_roles"."model_type" as "pivot_model_type" from "roles" inner join "model_has_roles" on "roles"."id" = "model_has_roles"."role_id" where "model_has_roles"."model_id" in (1) and "model_has_roles"."model_type" = App\Models\User
10:36:12 PM
Runtime 2.050048ms
Connection pgsql
select count(*) as aggregate from "care_takers"
10:36:17 PM
Runtime 0.64ms
Connection pgsql
select count(*) as aggregate from "care_takers" where "stopped_at" is null
10:36:20 PM
Runtime 0.620032ms
Connection pgsql
select count(*) as aggregate from "care_takers" where "stopped_at" is not null