Level 55
@armani it migrated this table, or just didn't removed it? Did you see it in console output and migrations table?
any chance you use schema:dump for migrations?
Sep 1, 2021
27
Level 17
Can't remove personal_access_tokens from migration
Today I created a new project and noticed that in migration folder there is a new file named: personal_access_tokens I know it belongs to Sanctum package, and because I don't use Sanctum I removed the migration, then run php artisan migrate but it migrated this table also.
I couldn't find out how to remove this migration entirely.
Any help?
Level 17
I removed it from migration folder, after running php artisan migrate it will output the table that migrated successfully. I didn't use schema:dump.
Level 55
php artisan optimize:clear
php artisan migrate:fresh
Level 17
didn't work
Level 55
@armani if you do not have migration for this table and do not have /database/schema/mysql-schema.dump file - it should works.
Show the screen of your migrations folder and output of php artisan migrate:fresh
Level 17
I found another copy of migration file in this address:
\vendor\laravel\sanctum\database\migrations19_12_14_000001_create_personal_access_tokens_table.php
I think this file will migrate to database
2 likes
Level 55
@armani it will not
Level 17
I uploaded screen shots: https://imgur.com/a/22k81vY
Level 55
@armani maybe you are in another project in console? try also
composer dump-autoload
Level 17
I'm sure that I'm in the right project in console. I also used composer dump-autoload but nothing changed.
I created another fresh project but it was the same.
Level 80
@armani Well if you install Sanctum then yes, Sanctum is going to run its migrations.
Why have you installed Sanctum if you don’t actually want Sanctum’s database tables?
Level 17
I didn't install Sanctum, I think in the newest version it is already installed.
Level 80
@armani Sanctum is only installed if you install it. It doesn’t come pre-installed with Laravel.
Level 17
Check out here: https://github.com/laravel/laravel/blob/8.x/composer.json
Level 80
Well knock me down. That’s gross. Not every project needs Sanctum so why Taylor’s decided it should come pre-installed in every Laravel application now, I have no idea.
Simple answer is to remove it if you don’t need it: composer remove laravel/sanctum
10 likes
Level 17
Not knowing why it was installed, I didn't know whether I could remove it. Thanks!
One thing to note when you do uninstall it though, the default User model is calling Laravel\Sanctum\HasApiTokens, but it's not doing anything with it. Hopefully there aren't any more little Sanctum tendrils I'm missing!
Level 3
In case someone ends up here for this issue, add the following line into your App\Providers\AppServiceProvider.php file
public function register()
{
Sanctum::ignoreMigrations();
}
From : https://laravel.com/docs/8.x/sanctum#migration-customization
31 likes
Level 2
@William77470 To add to that, make sure you import it in the provider as well:
use Laravel\Sanctum\Sanctum;
or
\Laravel\Sanctum\Sanctum::ignoreMigrations();
7 likes
Level 1
@William77470 Thanks for saving my day.
Level 1
Thank U @William77470 You saved me a bunch of time
Level 7
Thank you for this because i am wondering why there is a personal token even if i didn't install laravel sanctum
Level 1
composer remove laravel/sanctum php artisan migrate:fresh
Level 1
dont you delete migration file from file directory, you can delete migration file from terminal using this code:
rm database/migrations/2019_12_14_000001_create_personal_access_tokens_table.php
Level 1
@syarifhd_ Please read whole the discussion before giving an solution next time. That file was deleted but the migration 2019_12_14_000001_create_personal_access_tokens_table still ran.
The right solution so far for this case cames from @william77470
Level 1
Its very simple! Just create a new migration with:
php artisan make:migation drop_personal_access_tokens_table
and then:
public function up(): void {
Schema::dropIfExists('personal_access_tokens');
}
2 likes
Level 1
Call the Sanctum::ignoreMigrations method in the register method of your App\Providers\AppServiceProvider class. Then remove database/migrations/2019_12_14_000001_create_personal_access_tokens_table.php https://laravel.com/docs/10.x/sanctum#migration-customization
Level 1
@william77470 @ancarofl5 Thank you. I was able to solve the problem.
Please or to participate in this conversation.