I'meters making use of the construction Laravel.
I have 2 desks (Users and Members). When I need to login, I obtain the mistake information:
SQLSTATE42S22: Line not discovered: 1054 Mystery column 'useremail' in 'where clause' (SQL: select. from
members
whereuseremail
= ? restriction 1) (Bindings: number ( 0 =gt; '[email protected]', ))The content of this field is kept private and will not be shown publicly. If you have a Gravatar account associated with the e-mail address you provide, it will be used to display your avatar. Oct 04, 2013 General questions relating to Joomla! Note: All 1.6 and 1.7 releases have reached end of life and should be updated to 2.5. There are other boards for.
Table Users
Desk Associates
Migration User
Migration Associate
Design Consumer
Design Associate
The Associate model uses:use IlluminateAuthUserInterface;
Controller
auth.php
![A.note A.note](/uploads/1/2/4/6/124692604/358400526.png)
What was I performing wrong here?
Gilko
GilkoGilko
3 Answers
You have configured the
auth.php
and utilizedassociates
desk for authentication but there is usually nouseremail
industry in thepeople
table so, Laravel statesSQLSTATE42S22: Line not discovered: 1054 Mystery column 'useremail' in 'where term' (SQL: select. from users where useremail = ? limit 1) (Bindings: number ( 0 =gt; '[email protected]', ))
Because, it attempts to match the
useremail
in theusers
table and it's not there. Regarding to yourauth
construction,laravel
is usually making use ofmembers
desk for authentication not reallycustomers
desk.The Alpha dogThe Alpha dog
You put on't have got a industry called
useremail
in the associates table. as for why, I'm not sure as the program code 'looks' like it should try to sign up for on different fieldsWill the Auth::attempt method perform a sign up for of the schema?Run
grep -Rl 'course Auth' /route/to/framework
and discover where thetry
technique is and what it will.![Unknown Column Unknown Column](/uploads/1/2/4/6/124692604/250005678.jpg)
CezCez
bandzibandzi