Laravel Sanctum : column not found: 1054 Unknown column 'api_token' in 'where clause'

Question

package: Sanctum

After generate token when request for get data its throw me error like this

Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'api_token' in   
'where clause' (SQL: select * from `users` where `api_token` = XAzuNGUeOJ8CXbIoGEWhBTtWIFr0lFr8jjwScXQ4B0Qxfmu
2cHm9LaUwGX96zy0AnXhLLcCnBFCodQaOlimit 1) in file

import EnsureFrontendRequestsAreStateful in kernel.php for token verification. use Laravel\Sanctum\Http\Middleware\EnsureFrontendRequestsAreStatefulin api section — Parth kharecha, May 03 '20 at 03:28
@hakiko Yes check this link https://stackoverflow.com/a/65472868/9077019 — Parth kharecha, Dec 28 '20 at 04:01

score 27 · Answer 1 · answered Aug 07 '20 at 12:38

27

go to config/auth.php

and change the api array in guards to sanctum example:

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

        'api' => [
            'driver' => 'sanctum',
            'provider' => 'users',
            'hash' => false,
        ],
    ],

answered Aug 07 '20 at 12:38

Sven Tjeerdsma

283
4
8

2

Yeah indeed. Nice that they put this in their documentation. Wasted a few hours on this. – Digital Human Nov 04 '20 at 11:48
It did not solve my problem. I clear every cache. I'm using v8 :( – hakki Dec 27 '20 at 00:37
Thanks! In the latest laravel version, they have removed the API guard as default. Thanks, it works. ```php artisan config:clear php artisan cache:clear php artisan config:cache``` – LogGurkha Sep 28 '21 at 13:07

score 7 · Answer 2 · edited Oct 15 '20 at 05:08

7

Go to routes/api.php and use this

Route::middleware('auth:sanctum')->get('/user', function (Request $request) {
    return $request->user();
});

instead of

Route::middleware('auth:api')->get('/user', function (Request $request) {
    return $request->user();
});

edited Oct 15 '20 at 05:08

linktoahref

7,812
3
29
51

answered Jul 07 '20 at 18:54

ALI MURTAZA

71
1
2

Ramsey Jiang · Answer 3 · 2021-05-03T08:20:07.637

3

In the api.php

Route::middleware('auth:sanctum')->get('/user', function (Request $request) {
    return $request->user();
});

In the config/auth.php

'api' => [
    'driver' => 'sanctum',
    'provider' => 'users',
    'hash' => false,
],

After that, it will fix the issue. I have uploaded the code to my GitHub.https://github.com/ramseyjiang/laravel_8_api

edited May 03 '21 at 08:20

answered May 03 '21 at 08:03

Ramsey Jiang

81
1
7

While this code may answer the question, adding some explanation on how and why it solves it will improve the quality of your answer – ᴄʀᴏᴢᴇᴛ May 03 '21 at 08:36
@ᴄʀᴏᴢᴇᴛ you need to make sure that the `api -> driver` is set to *sanctum* – arhakim Mar 09 '22 at 09:59

score 1 · Answer 4 · edited Dec 28 '20 at 15:51

1

import EnsureFrontendRequestsAreStateful in kernel.php for token verification

use Laravel\Sanctum\Http\Middleware\EnsureFrontendRequestsAreStateful;

class Kernel extends HttpKernel
{

    'api' => [
               ------
               EnsureFrontendRequestsAreStateful::class,
               ------
             ],
}

edited Dec 28 '20 at 15:51

hakki

6,181
6
62
106

answered Dec 28 '20 at 04:00

Parth kharecha

6,135
4
25
41

score 0 · Answer 5 · answered Apr 10 '20 at 14:00

0

Run the migration and then check, if there was still the issue then either users table don't have api_token field or it's not defined in the User model inside $fillable array.

answered Apr 10 '20 at 14:00

engrhussainahmad

1,008
10
19

score 0 · Answer 6 · edited Apr 16 '21 at 13:00

0

You can try add "middleware(auth:sanctum)" for your api route.

Example:

Route::middleware('auth:sanctum')->get('products', function() {
      //code
})->name('api.products');

edited Apr 16 '21 at 13:00

Dharman

30,962
25
85
135

answered Apr 16 '21 at 12:54

irfanyy

49
5

score 0 · Answer 7 · answered Jul 14 '21 at 09:12

0

Run

php artisan cache:clear
php artisan config:clear
php artisan route:clear

Then restart Apache and Mysql (for XAMPP/WAMPP) and run artisan serve command again it worked for me.make sure you read their docs first

answered Jul 14 '21 at 09:12

Echo User

11
5

This is a typical cache clearing method, but how does it help solve the problem posed? – Gleb Kemarsky Jul 14 '21 at 19:05

score 0 · Answer 8 · answered Jul 19 '21 at 11:51

1.So to answer this question, after racking my brain, I decided to clear the application, configuration, and route caches,that did the trick for me.

  php artisan cache:clear

2.You can run the above statement in your console when you wish to clear the application cache. What it does is that this statement clears all caches inside storage\framework\cache.

  php artisan route:cache

3.This clears your route cache. So if you have added a new route or have changed a route controller or action you can use this one to reload the same.

  php artisan config:cache

score 0 · Answer 9 · answered Aug 09 '22 at 22:22

0

First drop table personal_access_tokens
Second delete row that contain "%create_personal_access_tokens_table%" in your table migrations.
Third execute again php artisan migrate.

answered Aug 09 '22 at 22:22

Pid

1

score 0 · Answer 10 · answered Feb 02 '23 at 13:00

0

In my case I had messed with the config\sanctum.php file. Specifically I had changed the guard to 'guard' => ['api'],.

reverting to 'guard' => ['web'], fixed it. Not sure why I changed it in the first place tbh.

answered Feb 02 '23 at 13:00

Edgar

472
6
17

Laravel Sanctum : column not found: 1054 Unknown column 'api_token' in 'where clause'

10 Answers10

Linked