Invalid text representation: canvas_users:id -> sessions:user_id

[scrappy]

Is there an existing issue for this?

• [X] I have searched the existing issues

Current Behavior

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "7f3aeeeb-ec17-42d2-95c9-dfd777c65cea" CONTEXT: unnamed portal parameter $3 = '...'

Looking at the database, the session table has user_id defined as bigint, same as the users table .. but canvas_users has id set as UUID ...

`

\d sessions

                     Table "public.sessions"
Column     |          Type          | Collation | Nullable | Default

---------------+------------------------+-----------+----------+--------- id | character varying(255) | | not null | user_id | bigint | | | ip_address | character varying(45) | | | user_agent | text | | | payload | text | | not null | last_activity | integer | | not null | Indexes: "sessions_pkey" PRIMARY KEY, btree (id) "sessions_last_activity_index" btree (last_activity) "sessions_user_id_index" btree (user_id) `

Database backend is PostgreSQL ... from git, doesn't look like canvas' schema has changed in 4 years, so did something change in newer laravel ... ?

Expected Behavior

No response

Steps To Reproduce

Install canvas on top of laravel 11.7.0 and try and login.

Fresh install of both as of today, using composer to install ...

Environment

> php artisan --version
Laravel Framework 11.7.0

Anything else?

No response