data truncated when trying to create personal access client for passport

the id 913a0ac7-5e2b-4d0c-abcd-aa6eb4d52085 is too big for your id column so it can't store it. It also contains hyphens which won't work as I'm assuming your id column type is BIGINT?

Do you have a code example?

@chr15k thanks for your reply below is the migration file

$this->schema->create('oauth_clients', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id')->nullable()->index();
            $table->string('name');
            $table->string('secret', 100)->nullable();
            $table->string('provider')->nullable();
            $table->text('redirect');
            $table->boolean('personal_access_client');
            $table->boolean('password_client');
            $table->boolean('revoked');
            $table->timestamps();
        });

So in stead of using id(), do you think what should I use ? Sorry I am a bit confusing now

@kenphanith I recomment to keep your id as it is now (it is a good way to have primary key with auto-increment). Instead create one more column, named for example auth_id, and store you value in it

$table->string('auth_id')->unique();

@chr15k I changed $table->id() to $table->uuid('id')->primary(); and it works thank you very much for your answer. I appreciate it 💜

@silencebringer thank you for your answer. that would also do the trick I think

@kenphanith no worries, glad you got that sorted

This thing happened to me, It's because I use this command : php artisan passport:install --uuids I wanted to use uuid for my PK at the beginning but I changed my mind.

So, To Fix it I had to edit de Passport Config file. To see the passport config file, you must publish the config file with the next command: php artisan vendor:publish --tag=passport-config

The before command generates the config/passport.php. So edit it!

client_uuids: false

Finally execute php artisan passport:install without --uuid option

It works!