SQLSTATE[42S22]: Column not found: 1054 Unknown column – Laravel

by

You have configured the auth.php and used members table for authentication but there is no user_email field in the members table so, Laravel says

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘user_email’ in
‘where clause’ (SQL: select * from members where user_email = ? limit
1) (Bindings: array ( 0 => ‘[email protected]’, ))

Because, it tries to match the user_email in the members table and it’s not there. According to your auth configuration, laravel is using members table for authentication not users table.

More Related Contents:

  1. How do I get the query builder to output its raw SQL query as a string?
  2. How to insert multiple rows from a single query using eloquent/fluent
  3. Laravel Advanced Wheres how to pass variable into function?
  4. Laravel Eloquent get results grouped by days
  5. Im trying to create some temporary tables in mysql using php
  6. How to Convert string response to array laravel
  7. How can I prevent SQL injection in PHP?
  8. SQL injection that gets around mysql_real_escape_string()
  9. Examples of SQL Injections through addslashes()?
  10. “The page has expired due to inactivity” – Laravel 5.5
  11. Difference between method calls $model->relation(); and $model->relation;
  12. Laravel, sync() – how to sync an array and also pass additional pivot fields?
  13. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  14. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  15. How can I paginate a merged collection in Laravel 5?
  16. Laravel 4 removing public from URL
  17. ReflectionException: Class ClassName does not exist – Laravel
  18. Laravel 5.2 CORS, GET not working with preflight OPTIONS
  19. laravel model callbacks after save, before save, etc
  20. Laravel 5.1: keep uploaded file as old input
  21. How to store and retrieve image contents from the database using Laravel
  22. Route [login] not defined
  23. Fatal error: Call to a member function query() on null
  24. My Laravel 5.2.10 Sessions wont persist
  25. How to install all required PHP extensions for Laravel?
  26. Log the actual SQL query using ActiveRecord with Yii2?
  27. Laravel Carbon Data Missing
  28. MYSQL select a piece of a string and order by that piece
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment