Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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
like image 808
Parth kharecha Avatar asked Apr 10 '20 13:04

Parth kharecha


2 Answers

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,
        ],
    ],
like image 166
Sven Tjeerdsma Avatar answered Sep 21 '22 04:09

Sven Tjeerdsma


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();
});
like image 33
ALI MURTAZA Avatar answered Sep 23 '22 04:09

ALI MURTAZA