This is a public shared error.

Illuminate \ Database \ QueryException

PHP

SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text ->> unknown LINE 1: ...ifications"."notifiable_id" is not null and "data"->>'format... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

select * from "notifications" where "notifications"."notifiable_type" = App\Models\User and "notifications"."notifiable_id" = 1 and "notifications"."notifiable_id" is not null and "data"->>'format' = filament order by "created_at" desc limit 51 offset 0

<?php

namespace App\Http\Middleware;

use Closure;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Symfony\Component\HttpFoundation\Response;

class LandingPageMiddleware
{
    public function handle(Request $request, Closure $next): Response
    {
        // User is logged in and has not seen the landing page yet.
        if ($request->path() != 'landing-page' && Auth::check() && !Auth::user()->landing_page) {
            Auth::user()->landing_page = true;
            Auth::user()->save();
            return redirect('landing-page');
        }
        return $next($request);

    }
}

App

Routing

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

Browser

Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36

Request

https://staging.work.alltrons.com/app

GET

curl "https://staging.work.alltrons.com/app" \
   -X GET \
   -H 'host: staging.work.alltrons.com' \
   -H 'scheme: https' \
   -H 'x-forwarded-for: 62.194.251.93' \
   -H 'connection: close' \
   -H 'content-length: 786' \
   -H 'sec-ch-ua: "Not A(Brand";v="99", "Google Chrome";v="121", "Chromium";v="121"' \
   -H 'content-type: application/json' \
   -H 'dnt: 1' \
   -H 'sec-ch-ua-mobile: ?0' \
   -H 'user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36' \
   -H 'sec-ch-ua-platform: "Linux"' \
   -H 'accept: */*' \
   -H 'origin: https://staging.work.alltrons.com' \
   -H 'sec-fetch-site: same-origin' \
   -H 'sec-fetch-mode: cors' \
   -H 'sec-fetch-dest: empty' \
   -H 'referer: https://staging.work.alltrons.com/app' \
   -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,el;q=0.6' \
   -d {"_token":"9FPXN76MTzmVbVW7LO86v3HYDOYiO8kbyZHv6jl0","components":[{"snapshot":"{\"data\":{\"paginators\":[[],{\"s\":\"arr\"}]},\"memo\":{\"id\":\"KdAmB8R0JUe0J7qrBtIa\",\"name\":\"filament.livewire.database-notifications\",\"path\":\"app\",\"method\":\"GET\",\"children\":[],\"scripts\":[],\"assets\":[],\"lazyLoaded\":false,\"lazyIsolated\":true,\"errors\":[],\"locale\":\"en\"},\"checksum\":\"79f7077936e65fd8b5e27707a4c6a85c0ab51f4f036ea6ae0d99d618ad9a8d36\"}","updates":[],"calls":[{"path":null,"method":"__lazyLoad","params":["eyJkYXRhIjp7ImZvck1vdW50IjpbW10seyJzIjoiYXJyIn1dfSwibWVtbyI6eyJpZCI6InY5dVZHb0h1aEJxNlQ0T29YUDlFIiwibmFtZSI6Il9fbW91bnRQYXJhbXNDb250YWluZXIifSwiY2hlY2tzdW0iOiI2NDcyMDFlOGYwM2IxNjE1ZTQ1MDI0MzQxMmUxNGI0ZTcyZjllYWU4Y2Q3YTcwMTI5MWFiMjQxNjdkN2YyZTFmIn0="]}]}]}

Views

File

Headers

host: staging.work.alltrons.com
scheme: https
x-forwarded-for: 62.194.251.93
connection: close
content-length: 786
sec-ch-ua: "Not A(Brand";v="99", "Google Chrome";v="121", "Chromium";v="121"
content-type: application/json
dnt: 1
sec-ch-ua-mobile: ?0
user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36
sec-ch-ua-platform: "Linux"
accept: */*
origin: https://staging.work.alltrons.com
sec-fetch-site: same-origin
sec-fetch-mode: cors
sec-fetch-dest: empty
referer: https://staging.work.alltrons.com/app
accept-encoding: gzip, deflate, br, zstd
accept-language: en-US,en;q=0.9,nl-NL;q=0.8,nl;q=0.7,el;q=0.6

Body

{
    "_token": "9FPXN76MTzmVbVW7LO86v3HYDOYiO8kbyZHv6jl0",
    "components": [
        {
            "snapshot": "{\"data\":{\"paginators\":[[],{\"s\":\"arr\"}]},\"memo\":{\"id\":\"KdAmB8R0JUe0J7qrBtIa\",\"name\":\"filament.livewire.database-notifications\",\"path\":\"app\",\"method\":\"GET\",\"children\":[],\"scripts\":[],\"assets\":[],\"lazyLoaded\":false,\"lazyIsolated\":true,\"errors\":[],\"locale\":\"en\"},\"checksum\":\"79f7077936e65fd8b5e27707a4c6a85c0ab51f4f036ea6ae0d99d618ad9a8d36\"}",
            "updates": [],
            "calls": [
                {
                    "path": null,
                    "method": "__lazyLoad",
                    "params": [
                        "eyJkYXRhIjp7ImZvck1vdW50IjpbW10seyJzIjoiYXJyIn1dfSwibWVtbyI6eyJpZCI6InY5dVZHb0h1aEJxNlQ0T29YUDlFIiwibmFtZSI6Il9fbW91bnRQYXJhbXNDb250YWluZXIifSwiY2hlY2tzdW0iOiI2NDcyMDFlOGYwM2IxNjE1ZTQ1MDI0MzQxMmUxNGI0ZTcyZjllYWU4Y2Q3YTcwMTI5MWFiMjQxNjdkN2YyZTFmIn0="
                    ]
                }
            ]
        }
    ]
}

Session

_token: 9FPXN76MTzmVbVW7LO86v3HYDOYiO8kbyZHv6jl0
_previous: { "url": "https://staging.work.alltrons.com/app" }
_flash: { "old": [], "new": [] }
url: []
login_web_3dc7a913ef5fd4b890ecabe3487085573e16cf82: 1
password_hash_web: $2y$12$ohuYYPVTJHA6VYxMD2C9AOQmKb0EGHE9E/D5dc4/aKRhWYSsVU2Aq

Cookies

XSRF-TOKEN: 9FPXN76MTzmVbVW7LO86v3HYDOYiO8kbyZHv6jl0
laravel_session: ufGOirFHo80LofcCoq8yBBNED4nA6Vd3NM8Xrk29

Context

User

adminUser@gmail.com

ID: 1

{
    "id": 1,
    "name": "Mateo",
    "email": "adminUser@gmail.com",
    "email_verified_at": null,
    "created_at": "2024-03-06T02:55:12.000000Z",
    "updated_at": "2024-03-06T02:55:35.000000Z",
    "role_id": null,
    "time_registration_last_project_id": null,
    "time_registration_last_activity_id": null,
    "has_advanced_time_input": false,
    "bug_reports_last_project_id": null,
    "avatar_url": null,
    "theme": "default",
    "theme_color": null,
    "birthday_date": null,
    "landing_page": true,
    "tickets_last_project_id": null
}

Versions

laravel version: 10.45.1
Laravel locale: en
Laravel config cached: false
Laravel debug: true

3:30:40 PM

1.060096ms

pgsql

select * from "users" where "id" = 1 limit 1