DEV Community

Pavel Olnyov
Pavel Olnyov

Posted on

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

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

Top comments (3)

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

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!!