This is a public shared error.
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
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":[]}]}
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": []
}
]
}
Context
User
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
}
}
]
}
10:31:22 PM
115.620096ms
pgsql
select * from "users" where "id" = 1 limit 1
10:33:36 PM
5.520128ms
pgsql
select * from "breezy_sessions" where "breezy_sessions"."authenticatable_id" in (1) and "breezy_sessions"."authenticatable_type" = App\Models\User
10:35:27 PM
3.689984ms
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
3.510016ms
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
2.050048ms
pgsql
select count(*) as aggregate from "care_takers"
10:36:17 PM
0.64ms
pgsql
select count(*) as aggregate from "care_takers" where "stopped_at" is null
10:36:20 PM
0.620032ms
pgsql
select count(*) as aggregate from "care_takers" where "stopped_at" is not null