Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

vshsolutions's avatar

UUID spark sessions table

After adding migration for sessions table and setting session_driver to database getting exception: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for uuid: "xfUjKVfw6LDIp1NHPASbmIoYfiZg1I75LhfCDB6n" (SQL: select * from "sessions" where "id" = xfUjKVfw6LDIp1NHPASbmIoYfiZg1I75LhfCDB6n limit 1)

Here is the migration: Schema::create('sessions', function (Blueprint $table) { $table->uuid('id')->unique(); $table->uuid('user_id')->nullable(); $table->string('ip_address', 45)->nullable(); $table->text('user_agent')->nullable(); $table->text('payload'); $table->integer('last_activity'); });

0 likes
1 reply
vshsolutions's avatar
vshsolutions
OP
Best Answer
Level 1

Reply from spark:

Spark doesn't use UUId for the base models, you'll need to do that manually if you want and apply the required changes.

Please or to participate in this conversation.