This is a public shared error.
PHP
SQLSTATE[42883]: Undefined function: 7 ERROR: could not identify an equality operator for type json
LINE 1: select distinct "products".* from "products" left join "guid...
^
select distinct "products".* from "products" left join "guide_product" on "products"."id" = "guide_product"."product_id" where "products"."deleted_at" is null order by "products"."name" asc
// took to execute and log the query SQL, bindings and time in our memory.
try {
return $callback($query, $bindings);
}
// If an exception occurs when attempting to run a query, we'll format the error
// message to include the bindings with SQL, which will make this exception a
// lot more helpful to the developer instead of just the database's errors.
catch (Exception $e) {
if ($this->isUniqueConstraintError($e)) {
throw new UniqueConstraintViolationException(
$this->getName(), $query, $this->prepareBindings($bindings), $e
);
}
throw new QueryException(
$this->getName(), $query, $this->prepareBindings($bindings), $e
);
}
}
/**
* Determine if the given database exception was caused by a unique constraint violation.
*
* @param \Exception $exception
* @return bool
*/
protected function isUniqueConstraintError(Exception $exception)
{
return false;
App
Routing
- Action
App\Filament\Admin\Resources\GuideResource\Pages\EditGuide@__invoke
- Route name
filament.admin.resources.guides.edit
- Route parameters
- record
1
- Middleware
panel:admin
Illuminate\Cookie\Middleware\EncryptCookies
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse
Illuminate\Session\Middleware\StartSession
Illuminate\Session\Middleware\AuthenticateSession
Illuminate\View\Middleware\ShareErrorsFromSession
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken
Illuminate\Routing\Middleware\SubstituteBindings
Filament\Http\Middleware\DisableBladeIconComponents
Filament\Http\Middleware\DispatchServingFilamentEvent
Jeffgreco13\FilamentBreezy\Middleware\MustTwoFactor
Filament\Http\Middleware\Authenticate
Request
http://localhost/admin/guides/1/edit
GET
curl "http://localhost/admin/guides/1/edit" \
-X GET \
-H 'host: localhost:8000' \
-H 'accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7' \
-H 'cookie: _ga=GA1.1.782263078.1651609006; Webstorm-368b7e78=1f3aeacf-4d6e-4356-8a23-e3def2ab9c9e; ph_phc_Yv1UeiekJBVX6mJL1LogDiibTfOMum3eRAO6Xe5OpmB_posthog=%7B%22distinct_id%22%3A%2218880c736b873-0a2aab5732d88b-26031a51-1fa400-18880c736b92193%22%2C%22%24device_id%22%3A%2218880c736b873-0a2aab5732d88b-26031a51-1fa400-18880c736b92193%22%2C%22%24user_state%22%3A%22anonymous%22%2C%22%24sesid%22%3A%5B1685796125445%2C%2218881477b05cbd-0d3c7a06890455-26031a51-1fa400-18881477b0612d8%22%2C1685796125445%5D%2C%22%24session_recording_enabled_server_side%22%3Atrue%2C%22%24console_log_recording_enabled_server_side%22%3Atrue%2C%22%24session_recording_recorder_version_server_side%22%3A%22v1%22%2C%22%24autocapture_disabled_server_side%22%3Afalse%2C%22%24active_feature_flags%22%3A%5B%5D%2C%22%24enabled_feature_flags%22%3A%7B%7D%2C%22%24feature_flag_payloads%22%3A%7B%7D%7D; _ga_DXN4Y6FGYN=GS1.1.1689011943.4.0.1689011943.0.0.0; remember_filament_59ba36addc2b2f9401580f014c7f58ea4e30989d=eyJpdiI6IlVWUC9NdjR4ZUMyNGRDMHNOdmR0Nnc9PSIsInZhbHVlIjoicGZjRElUMVR6eTRlOGxIaEtnUDIvc3BQWVk5QkVoV2JvVytER1ZMVnp3THBZUDBJOWk1anFxNUZIMGFZTEZhUlRndjVRaWhkdDJsTStTajA0UWtiSm81bVBRS0dvc3huMVV1d05jZXcvUUlPcG4zdVg0NjVSK05jalc0bllwTjI3TVplV09VVUxwYndMdzJrb1hTNWJCR1Y5NUNXQXpjVWtCS2xSN1hyZERzPSIsIm1hYyI6IjhkYjFmNDhmMTYzMmJlNDdmYjdiY2VmOTVkMGNlNDIzOWUxMzZmZTQ0MWNhZjJhODE5MzAzMTBiNDBlNjE2NTEiLCJ0YWciOiIifQ%3D%3D; _pk_id.2.1fff=1fee1cb973428a9a.1693067438.; Phpstorm-40bb1d96=1bc5aa52-9200-422d-8de4-2138de9f44ad; _ga_GV5HEV69V0=GS1.1.1695282758.9.0.1695282773.0.0.0; default-theme=ngax; username-localhost-8888=2|1:0|10:1705071711|23:username-localhost-8888|188:eyJ1c2VybmFtZSI6ICIzYjE3OWE1MzIwNDg0MTEyYmM4ODc0ZTYxMWRjNGYzYSIsICJuYW1lIjogIkFub255bW91cyBFcnNhIiwgImRpc3BsYXlfbmFtZSI6ICJBbm9ueW1vdXMgRXJzYSIsICJpbml0aWFscyI6ICJBRSIsICJjb2xvciI6IG51bGx9|e85074b57963cb315939a6b0f60a1e13413c5c1c5216062f6a6c6e40be9f6011; _xsrf=2|c6169fd3|0218b5020123493c840299e63a037a87|1705071711; XSRF-TOKEN=eyJpdiI6IlJSVENMdGhNSTJBRlhjejdtTzZ6T0E9PSIsInZhbHVlIjoiaDBhcjVBb1BNTDVwY0FRSTdISkt2VDNaK25oL01wT3dTMnRyV0V2U3Nnc3oyaDdtZzUxYy9zODFNM3IzQ1hlZU9rOW9QZGxZdXJrWWduK0ZlMUlwaVJROXZqNzlHYVhNZHppNVdlRWVzNVNUeGd1MERqdG5mUURDVm5PRmMxOGQiLCJtYWMiOiJiNzg0Yjk2Yjc0Mjc0Yjg0ZDA4NmYxNmVmNTg5ZDdmNjIzNDdmZDAwNTEyM2U5Njk4ZmJiODQxNmY5MzVjYTdlIiwidGFnIjoiIn0%3D; mcmodels_session=eyJpdiI6InhyanY3LzRiSkQxWUVwSXcxZWsrZEE9PSIsInZhbHVlIjoiMS9YeGlNMlhtdy9hSWJwTzVXb1hVcTdwZU05eGk3NzIyaUthSFM3YklhNE1Rbm4yVHl4TzFWSFFRcEpLckwzRnRvQU5GeFh1TmlhN3I3YXUyRVhjb0RKc0p5a1JXZFh5dWpRaTBFK1oyMThDamZCcFQ2ekdIVXBnTjNCaWY3cGMiLCJtYWMiOiJhMmEyMWRmMjFkNDNlMzllMmFhMzc4YjgxMGRjZWJjNjhhNTRmY2RlODE3OTk1Yzk0MzkzNTIzZjRhNWE2YjIzIiwidGFnIjoiIn0%3D' \
-H 'referer: http://localhost:8000/admin/guides' \
-H 'sec-ch-ua: "Not_A Brand";v="8", "Chromium";v="120", "Google Chrome";v="120"' \
-H 'connection: keep-alive' \
-H 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36' \
-H 'cache-control: max-age=0' \
-H 'sec-fetch-dest: document' \
-H 'sec-fetch-mode: navigate' \
-H 'sec-fetch-site: same-origin' \
-H 'sec-fetch-user: ?1' \
-H 'accept-encoding: gzip, deflate, br' \
-H 'accept-language: en-US,en;q=0.9,nl-NL;q=0.8,nl;q=0.7' \
-H 'sec-ch-ua-mobile: ?0' \
-H 'sec-ch-ua-platform: "Windows"' \
-H 'upgrade-insecure-requests: 1';
Headers
- host
localhost:8000
- accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7
- cookie
_ga=GA1.1.782263078.1651609006; Webstorm-368b7e78=1f3aeacf-4d6e-4356-8a23-e3def2ab9c9e; ph_phc_Yv1UeiekJBVX6mJL1LogDiibTfOMum3eRAO6Xe5OpmB_posthog=%7B%22distinct_id%22%3A%2218880c736b873-0a2aab5732d88b-26031a51-1fa400-18880c736b92193%22%2C%22%24device_id%22%3A%2218880c736b873-0a2aab5732d88b-26031a51-1fa400-18880c736b92193%22%2C%22%24user_state%22%3A%22anonymous%22%2C%22%24sesid%22%3A%5B1685796125445%2C%2218881477b05cbd-0d3c7a06890455-26031a51-1fa400-18881477b0612d8%22%2C1685796125445%5D%2C%22%24session_recording_enabled_server_side%22%3Atrue%2C%22%24console_log_recording_enabled_server_side%22%3Atrue%2C%22%24session_recording_recorder_version_server_side%22%3A%22v1%22%2C%22%24autocapture_disabled_server_side%22%3Afalse%2C%22%24active_feature_flags%22%3A%5B%5D%2C%22%24enabled_feature_flags%22%3A%7B%7D%2C%22%24feature_flag_payloads%22%3A%7B%7D%7D; _ga_DXN4Y6FGYN=GS1.1.1689011943.4.0.1689011943.0.0.0; remember_filament_59ba36addc2b2f9401580f014c7f58ea4e30989d=eyJpdiI6IlVWUC9NdjR4ZUMyNGRDMHNOdmR0Nnc9PSIsInZhbHVlIjoicGZjRElUMVR6eTRlOGxIaEtnUDIvc3BQWVk5QkVoV2JvVytER1ZMVnp3THBZUDBJOWk1anFxNUZIMGFZTEZhUlRndjVRaWhkdDJsTStTajA0UWtiSm81bVBRS0dvc3huMVV1d05jZXcvUUlPcG4zdVg0NjVSK05jalc0bllwTjI3TVplV09VVUxwYndMdzJrb1hTNWJCR1Y5NUNXQXpjVWtCS2xSN1hyZERzPSIsIm1hYyI6IjhkYjFmNDhmMTYzMmJlNDdmYjdiY2VmOTVkMGNlNDIzOWUxMzZmZTQ0MWNhZjJhODE5MzAzMTBiNDBlNjE2NTEiLCJ0YWciOiIifQ%3D%3D; _pk_id.2.1fff=1fee1cb973428a9a.1693067438.; Phpstorm-40bb1d96=1bc5aa52-9200-422d-8de4-2138de9f44ad; _ga_GV5HEV69V0=GS1.1.1695282758.9.0.1695282773.0.0.0; default-theme=ngax; username-localhost-8888=2|1:0|10:1705071711|23:username-localhost-8888|188:eyJ1c2VybmFtZSI6ICIzYjE3OWE1MzIwNDg0MTEyYmM4ODc0ZTYxMWRjNGYzYSIsICJuYW1lIjogIkFub255bW91cyBFcnNhIiwgImRpc3BsYXlfbmFtZSI6ICJBbm9ueW1vdXMgRXJzYSIsICJpbml0aWFscyI6ICJBRSIsICJjb2xvciI6IG51bGx9|e85074b57963cb315939a6b0f60a1e13413c5c1c5216062f6a6c6e40be9f6011; _xsrf=2|c6169fd3|0218b5020123493c840299e63a037a87|1705071711; XSRF-TOKEN=eyJpdiI6IlJSVENMdGhNSTJBRlhjejdtTzZ6T0E9PSIsInZhbHVlIjoiaDBhcjVBb1BNTDVwY0FRSTdISkt2VDNaK25oL01wT3dTMnRyV0V2U3Nnc3oyaDdtZzUxYy9zODFNM3IzQ1hlZU9rOW9QZGxZdXJrWWduK0ZlMUlwaVJROXZqNzlHYVhNZHppNVdlRWVzNVNUeGd1MERqdG5mUURDVm5PRmMxOGQiLCJtYWMiOiJiNzg0Yjk2Yjc0Mjc0Yjg0ZDA4NmYxNmVmNTg5ZDdmNjIzNDdmZDAwNTEyM2U5Njk4ZmJiODQxNmY5MzVjYTdlIiwidGFnIjoiIn0%3D; mcmodels_session=eyJpdiI6InhyanY3LzRiSkQxWUVwSXcxZWsrZEE9PSIsInZhbHVlIjoiMS9YeGlNMlhtdy9hSWJwTzVXb1hVcTdwZU05eGk3NzIyaUthSFM3YklhNE1Rbm4yVHl4TzFWSFFRcEpLckwzRnRvQU5GeFh1TmlhN3I3YXUyRVhjb0RKc0p5a1JXZFh5dWpRaTBFK1oyMThDamZCcFQ2ekdIVXBnTjNCaWY3cGMiLCJtYWMiOiJhMmEyMWRmMjFkNDNlMzllMmFhMzc4YjgxMGRjZWJjNjhhNTRmY2RlODE3OTk1Yzk0MzkzNTIzZjRhNWE2YjIzIiwidGFnIjoiIn0%3D
- referer
http://localhost:8000/admin/guides
- sec-ch-ua
"Not_A Brand";v="8", "Chromium";v="120", "Google Chrome";v="120"
- connection
keep-alive
- user-agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36
- cache-control
max-age=0
- sec-fetch-dest
document
- sec-fetch-mode
navigate
- sec-fetch-site
same-origin
- sec-fetch-user
?1
- accept-encoding
gzip, deflate, br
- accept-language
en-US,en;q=0.9,nl-NL;q=0.8,nl;q=0.7
- sec-ch-ua-mobile
?0
- sec-ch-ua-platform
"Windows"
- upgrade-insecure-requests
1
Session
- url
[]
- _flash
{ "new": [], "old": [] }
- _token
jDzJkJtakhxoKH2XLkJh1rgabz6dMF0KpZKL1bPp
- _previous
{ "url": "http://localhost:8000/admin/guides/1/edit" }
- password_hash_web
$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi
- login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d
1
Cookies
- _ga
null
- _xsrf
null
- XSRF-TOKEN
jDzJkJtakhxoKH2XLkJh1rgabz6dMF0KpZKL1bPp
- _pk_id_2_1fff
null
- default-theme
null
- _ga_DXN4Y6FGYN
null
- _ga_GV5HEV69V0
null
- mcmodels_session
OtfggDO8TDWZnX8lv0tnD8sfL57nJbTguzgKuGxD
- Phpstorm-40bb1d96
null
- Webstorm-368b7e78
null
- username-localhost-8888
null
- ph_phc_Yv1UeiekJBVX6mJL1LogDiibTfOMum3eRAO6Xe5OpmB_posthog
null
- remember_filament_59ba36addc2b2f9401580f014c7f58ea4e30989d
null
Context
User
contact@danielvdspoel.nl
ID: 1
{
"id": 1,
"type": "admin",
"email": "contact@danielvdspoel.nl",
"full_name": "Christiana Sauer",
"last_name": "Sauer",
"created_at": "2023-11-18T10:32:18.000000Z",
"first_name": "Christiana",
"updated_at": "2023-11-18T10:32:18.000000Z",
"display_name": null,
"wordpress_id": null,
"breezy_sessions": [],
"email_verified_at": "2023-11-18T10:32:18.000000Z"
}
11:48:07 AM
31.47008ms
pgsql
select * from "users" where "id" = 1 limit 1
11:48:41 AM
1.6ms
pgsql
select * from "breezy_sessions" where "breezy_sessions"."authenticatable_id" in (1) and "breezy_sessions"."authenticatable_type" = App\Models\User
11:48:51 AM
1.87008ms
pgsql
select * from "guides" where "id" = 1 limit 1
11:49:36 AM
2.870016ms
pgsql
select "products".*, "guide_product"."guide_id" as "pivot_guide_id", "guide_product"."product_id" as "pivot_product_id" from "products" inner join "guide_product" on "products"."id" = "guide_product"."product_id" where "guide_product"."guide_id" = 1 and "products"."deleted_at" is null