DEV Community


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

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)

Sloan, the sloth mascot
Comment deleted
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.

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