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

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


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 => 'test@hotmail.com', ))

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.


You don't have a field named user_email in the members table... as for why, I'm not sure as the code "looks" like it should try to join on different fields

Does the Auth::attempt method perform a join of the schema?Run grep -Rl 'class Auth' /path/to/framework and find where the attempt method is and what it does.


Try to change where Member class

public function users() {    return $this->hasOne('User');} return $this->belongsTo('User');