DEV Community

loading...

Laravel Passport don`t work. Error: column "api_token" does not exist

Pavel Olnyov
I publish posts about Laravel and CMS Bitrix in order to share my experience.
・1 min read

I want to create API with OAuth 2.0 authentication.

Use Laravel Passport tutorial https://laravel.com/docs/6.x/passport.

Set up the configuration on config/auth.php:

'guards' => [
    'web' => [
        'driver' => 'session',
        'provider' => 'users',
    ],

    'api' => [
        'driver' => 'passport',
        'provider' => 'users',
    ],
],
Enter fullscreen mode Exit fullscreen mode

When testing, I use a fresh token, but in response I get an error:

SQLSTATE[42703]: Undefined column: 7 ERROR:  column "api_token" does not exist↵LINE 1: select * from "users" where "api_token" = $1 limit 1
Enter fullscreen mode Exit fullscreen mode

Solution: clear the cache with command:

php artisan config:clear
Enter fullscreen mode Exit fullscreen mode

Discussion (3)

Collapse
Sloan, the sloth mascot
Comment deleted
Collapse
olnyov profile image
Pavel Olnyov Author

Laravel 6.x Passport does not require adding the api_token column to the users table, there is no need to create a migration with adding the api_token column.

Collapse
lmadrid0289 profile image
Luis Madrid

ohh man I was struggling with that, all the basic answers were "change the driver" but php artisan config:clear was the deal yoooo!!! thanx!!