SQLSTATE 42S22 Column not found 1054 Unknown column - Laravel

Question

I m using the framework Laravel   I have 2 tables  Users and Members   When I want to login  I get the error message      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        Table Users  CREATE TABLE IF NOT EXISTS  festival aid   users       user id  BIGINT NOT NULL AUTO INCREMENT     user email  VARCHAR 45  NOT NULL     user created  TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP     user modified  TIMESTAMP NULL     user deleted  TIMESTAMP NULL     user lastlogin  TIMESTAMP NULL     user locked  TIMESTAMP NULL    PRIMARY KEY   user id      UNIQUE INDEX  user email UNIQUE    user email  ASC   ENGINE   InnoDB    Table Members  CREATE TABLE IF NOT EXISTS  festival aid   members       member id  BIGINT NOT NULL AUTO INCREMENT     member password  CHAR 32  NOT NULL     member salt  CHAR 22  NOT NULL     member token  VARCHAR 128  NULL     member confirmed  TIMESTAMP NULL     user id  BIGINT NOT NULL    PRIMARY KEY   member id    user id      INDEX  fk members users1 idx    user id  ASC     CONSTRAINT  fk members users1      FOREIGN KEY   user id       REFERENCES  festival aid   users    user id       ON DELETE NO ACTION     ON UPDATE NO ACTION  ENGINE   InnoDB    Migration User  public function up                 Schema  table  users   function Blueprint  table                         table- gt increments  user id                  table- gt string  user email                 table- gt timestamp  user created                 table- gt timestamp  user modified                 table- gt timestamp  user deleted                 table- gt timestamp  user lastlogin                 table- gt timestamp  user locked                        Migration Member  public function up                 Schema  table  members   function Blueprint  table                         table- gt increments  member id                  table- gt string  member password                 table- gt string  member salt                 table- gt string  member token                  table- gt foreign  user id                   - gt references  id  - gt on  users                  - gt onDelete  cascade                  table- gt timestamp  member confirmed                        Model User  class User extends Eloquent        protected  table    users                   The primary key for the model                 var string             protected  primaryKey    user id        public  timestamps   false      Model Member  use Illuminate Auth UserInterface  use Illuminate Auth Reminders RemindableInterface   class Member extends Eloquent implements UserInterface  RemindableInterface        protected  table    members                   The attributes excluded from the model s JSON form                 var array             protected  hidden   array  member password                    Get the unique identifier for the user                 return mixed             public function getAuthIdentifier                 return  this- gt getKey                          Get the password for the user                 return string             public function getAuthPassword                 return  this- gt member password                        Get the e-mail address where password reminders are sent                 return string             public function getReminderEmail                 return  this- gt email                        The primary key for the model                 var string             protected  primaryKey    member id        public  timestamps   false       public function users                 return  this- gt hasOne  User              The Member model uses  use Illuminate Auth UserInterface    lt  php namespace Illuminate Auth   interface UserInterface                   Get the unique identifier for the user                 return mixed             public function getAuthIdentifier                    Get the password for the user                 return string             public function getAuthPassword         Controller  public function store                  input   Input  all              rules   array  user email    gt   required    member password    gt   required              v   Validator  make  input   rules            if  v- gt passes                           credentials   array  user email    gt   input  user email     member password    gt   input  member password                  if Auth  attempt  credentials                                 return Redirect  to   home                   else                    return Redirect  to  login                             else                return Redirect  to  login  - gt withErrors  v                     auth php    return array               --------------------------------------------------------------------------       Default Authentication Driver      --------------------------------------------------------------------------             This option controls the authentication driver that will be utilized        This drivers manages the retrieval and authentication of the users       attempting to get access to protected areas of your application              Supported   database    eloquent                     driver    gt   eloquent                --------------------------------------------------------------------------       Authentication Model      --------------------------------------------------------------------------             When using the  Eloquent  authentication driver  we need to know which       Eloquent model should be used to retrieve your users  Of course  it       is often just the  User  model but you may use whatever you like                     model    gt   Member                --------------------------------------------------------------------------       Authentication Table      --------------------------------------------------------------------------             When using the  Database  authentication driver  we need to know which       table should be used to retrieve your users  We have chosen a basic       default value but you may easily change it to any table you like                     table    gt   members                --------------------------------------------------------------------------       Password Reminder Settings      --------------------------------------------------------------------------             Here you may set the settings for password reminders  including a view       that should be used as your password reminder e-mail  You will also       be able to set the name of the table that holds the reset tokens              The  expire  time is the number of minutes that the reminder should be       considered valid  This security feature keeps tokens short-lived so       they have less time to be guessed  You may change this as needed                     reminder    gt  array            email    gt   emails auth reminder             table    gt   password reminders             expire    gt  60                What am I doing wrong here

User · Accepted Answer

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

User · Answer

Try to change where Member class  public function users         return  this- gt hasOne  User        return  this- gt belongsTo  User

User · Answer

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

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

Examples related to php

Examples related to sql

Examples related to laravel

Examples related to where

Examples related to where-clause