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[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

Browser

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

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';

Views

File

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

Body

[]

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

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"
}

Versions

laravel version
10.39.0
Laravel locale
en
Laravel config cached
false
Laravel debug
true
11:48:07 AM
Runtime 31.47008ms
Connection pgsql
select * from "users" where "id" = 1 limit 1
11:48:41 AM
Runtime 1.6ms
Connection pgsql
select * from "breezy_sessions" where "breezy_sessions"."authenticatable_id" in (1) and "breezy_sessions"."authenticatable_type" = App\Models\User
11:48:51 AM
Runtime 1.87008ms
Connection pgsql
select * from "guides" where "id" = 1 limit 1
11:49:36 AM
Runtime 2.870016ms
Connection 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