SQLSTATE[42S22]: Column not found: 1054 Unknown column – Laravel
Posted by
Dharmendra Kumar, Senior Software Engineer & Co founder at MyhospitalNow
–
Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider' in 'field list' (Connection: mysql, SQL: insert into `oauth_clients` (`user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `updated_at`, `created_at`) values (?, MyHospitalNow.com Personal Access Client, nS6QBk2lNjAyUIuUX2TH4z0CjXiEn8aucive8Mav, ?, http://localhost, 1, 0, 0, 2023-11-25 06:52:01, 2023-11-25 06:52:01)) at vendor/laravel/framework/src/Illuminate/Database/Connection.php:822
Solution:
Go to phpMyadmin and insert the column “provider” oauth_clients table
the purpose of theĀ providerĀ column inĀ oauth_clientsĀ table
Problem is solved
Dharmendra Kumar, Senior Software Engineer & Co founder at MyhospitalNow
Experienced software developer proficient in HTML, CSS, and Bootstrap for crafting elegant and responsive user interfaces.
Skilled in Laravel and PHP, with a focus on building robust and scalable web applications.
Proficient in JavaScript for both frontend and backend development, leveraging frameworks like React and Vue.js.
Experienced in designing and consuming RESTful APIs to enable seamless communication between client and server.
Expertise in integrating payment gateways such as PayPal, Stripe, and Paytm for secure online transactions.
Familiar with Flutter, enabling the creation of natively compiled applications for mobile, web, and desktop.
Proficient in Android Studio, the primary IDE for developing Android applications.
Knowledgeable in Linux and Docker for efficient server management and application deployment.
Experienced in using Redis as an in-memory data structure store, enhancing application performance.
Passionate about staying updated with the latest technologies and continuously learning to deliver high-quality solutions.