{"id":1307,"date":"2023-11-29T10:31:38","date_gmt":"2023-11-29T10:31:38","guid":{"rendered":"https:\/\/www.devopssupport.in\/blog\/?p=1307"},"modified":"2023-11-29T10:31:39","modified_gmt":"2023-11-29T10:31:39","slug":"resolving-sqlstate42s22-column-not-found-1054-unknown-column-provider-in-field","status":"publish","type":"post","link":"https:\/\/www.devopssupport.in\/blog\/resolving-sqlstate42s22-column-not-found-1054-unknown-column-provider-in-field\/","title":{"rendered":"Resolving SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘provider’ in ‘field’"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

The error indicates that there’s an attempt to access a column named ‘provider’ in a database table, but this column doesn’t exist. Laravel Passport, starting from version 10.0, introduces support for multiple guard user providers, requiring the addition of a ‘provider’ column to the ‘oauth_clients’ database table.<\/p>\n\n\n\n

Solution: Upgrading Passport and Adding the ‘provider’ Column<\/h2>\n\n\n\n

To resolve this issue, you need to upgrade Passport to version 10.0 or later and add the ‘provider’ column to the ‘oauth_clients’ table. Here are the steps:<\/p>\n\n\n\n

1. Upgrade Passport to Version 10.0<\/h3>\n\n\n\n

In your terminal, navigate to your Laravel project’s root directory and run the following Composer command to upgrade Passport:<\/p>\n\n\n\n

composer require laravel\/passport:^your version\r\n<\/code><\/pre>\n\n\n\n
2. Add the ‘provider’ Column to the ‘oauth_clients’ Table<\/h3>\n\n\n\n
After upgrading Passport, you need to add the ‘provider’ column to the ‘oauth_clients’ table. If you have not previously published the Passport migrations, you can manually add the column using a migration.<\/p>\n\n\n\n
Create a new migration using the following command:<\/p>\n\n\n\n
php artisan make:migration add_provider_to_oauth_clients --table=oauth_clients\r\n<\/code><\/pre>\n\n\n\n
Open the generated migration file (located in the ‘database\/migrations’ directory) and add the ‘provider’ column definition:<\/p>\n\n\n\n
use Illuminate\\Database\\Migrations\\Migration;\r\nuse Illuminate\\Database\\Schema\\Blueprint;\r\nuse Illuminate\\Support\\Facades\\Schema;\r\n\r\nclass AddProviderToOauthClients extends Migration\r\n{\r\n    \/**\r\n     * Run the migrations.\r\n     *\r\n     * @return void\r\n     *\/\r\n    public function up()\r\n    {\r\n        Schema::table('oauth_clients', function (Blueprint $table) {\r\n            $table->string('provider')->after('secret')->nullable();\r\n        });\r\n    }\r\n\r\n    \/**\r\n     * Reverse the migrations.\r\n     *\r\n     * @return void\r\n     *\/\r\n    public function down()\r\n    {\r\n        Schema::table('oauth_clients', function (Blueprint $table) {\r\n            $table->dropColumn('provider');\r\n        });\r\n    }\r\n}\r\n<\/code><\/pre>\n\n\n\n
Run the migration to apply the changes:<\/p>\n\n\n\n
php artisan migrate\r\n<\/code><\/pre>\n\n\n\n
After completing these steps, retry the operation that resulted in the ‘Column not found: 1054 Unknown column ‘provider’ in ‘field” error. The ‘provider’ column should now exist in the ‘oauth_clients’ table, resolving the issue.<\/p>\n","protected":false},"excerpt":{"rendered":"
The error indicates that there’s an attempt to access a column named ‘provider’ in a database table, but this column doesn’t exist. Laravel Passport, starting from version… <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1307","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/1307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/comments?post=1307"}],"version-history":[{"count":1,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/1307\/revisions"}],"predecessor-version":[{"id":1309,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/1307\/revisions\/1309"}],"wp:attachment":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/media?parent=1307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/categories?post=1307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/tags?post=1307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}