Level 3
It could be that you made a user table and Laravel is connecting to a users table.
In your User model - put this: protected $table = 'user' and see if it works then.
Apr 24, 2017
6
Level 1
SQLSTATE[42S22]: Column not found/QueryException in Connection.php line 647:
i have a problem in resetting password mainly beacause email of users not stored in users table ,so when ressetting password laravel check on wrong table which is users , so how do i make it check on right on containing mail (user_emails)in order to reset password that error i get
in Connection.php line 647
at Connection->runQueryCallback('select * from `users` where `email` = ? limit 1', array('123@123.com'), object(Closure)) in Connection.php line 607
at Connection->run('select * from `users` where `email` = ? limit 1', array('123@123.com'), object(Closure)) in Connection.php line 326
at Connection->select('select * from `users` where `email` = ? limit 1', array('123@123.com'), true) in Builder.php line 1710
at Builder->runSelect() in Builder.php line 1694
at Builder->get(array('*')) in Builder.php line 452
at Builder->getModels(array('*')) in Builder.php line 436
at Builder->get(array('*')) in BuildsQueries.php line 71
at Builder->first() in EloquentUserProvider.php line 110
at EloquentUserProvider->retrieveByCredentials(array('email' => '123@123.com')) in PasswordBroker.php line 190
at PasswordBroker->getUser(array('email' => '123@123.com')) in PasswordBroker.php line 60
at PasswordBroker->sendResetLink(array('email' => '123@123.com')) in ForgotPasswordController.php line 60
at ForgotPasswordController->sendResetLinkEmail(object(Request))
at call_user_func_array(array(object(ForgotPasswordController), 'sendResetLinkEmail'), array(object(Request))) in Controller.php line 55
at Controller->callAction('sendResetLinkEmail', array(object(Request))) in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(ForgotPasswordController), 'sendResetLinkEmail') in Route.php line 204
at Route->runController() in Route.php line 160
at Route->run() in Router.php line 559
at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in RedirectIfAuthenticated.php line 24
at RedirectIfAuthenticated->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 102
at Pipeline->then(object(Closure)) in Router.php line 561
at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 520
at Router->dispatchToRoute(object(Request)) in Router.php line 498
at Router->dispatch(object(Request)) in Kernel.php line 174
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 102
at Pipeline->then(object(Closure)) in Kernel.php line 149
at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 116
at Kernel->handle(object(Request)) in index.php line 54
at require_once('C:\\wamp\\www\\Menoon1\\public\\index.php') in server.php line 21
2/3
PDOException in PDOConnection.php line 79:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'where clause'
in PDOConnection.php line 79
at PDOConnection->prepare('select * from `users` where `email` = ? limit 1') in Connection.php line 319
at Connection->Illuminate\Database\{closure}('select * from `users` where `email` = ? limit 1', array('123@123.com')) in Connection.php line 640
at Connection->runQueryCallback('select * from `users` where `email` = ? limit 1', array('123@123.com'), object(Closure)) in Connection.php line 607
at Connection->run('select * from `users` where `email` = ? limit 1', array('123@123.com'), object(Closure)) in Connection.php line 326
at Connection->select('select * from `users` where `email` = ? limit 1', array('123@123.com'), true) in Builder.php line 1710
at Builder->runSelect() in Builder.php line 1694
at Builder->get(array('*')) in Builder.php line 452
at Builder->getModels(array('*')) in Builder.php line 436
at Builder->get(array('*')) in BuildsQueries.php line 71
at Builder->first() in EloquentUserProvider.php line 110
at EloquentUserProvider->retrieveByCredentials(array('email' => '123@123.com')) in PasswordBroker.php line 190
at PasswordBroker->getUser(array('email' => '123@123.com')) in PasswordBroker.php line 60
at PasswordBroker->sendResetLink(array('email' => '123@123.com')) in ForgotPasswordController.php line 60
at ForgotPasswordController->sendResetLinkEmail(object(Request))
at call_user_func_array(array(object(ForgotPasswordController), 'sendResetLinkEmail'), array(object(Request))) in Controller.php line 55
at Controller->callAction('sendResetLinkEmail', array(object(Request))) in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(ForgotPasswordController), 'sendResetLinkEmail') in Route.php line 204
at Route->runController() in Route.php line 160
at Route->run() in Router.php line 559
at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in RedirectIfAuthenticated.php line 24
at RedirectIfAuthenticated->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 102
at Pipeline->then(object(Closure)) in Router.php line 561
at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 520
at Router->dispatchToRoute(object(Request)) in Router.php line 498
at Router->dispatch(object(Request)) in Kernel.php line 174
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 102
at Pipeline->then(object(Closure)) in Kernel.php line 149
at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 116
at Kernel->handle(object(Request)) in index.php line 54
at require_once('C:\\wamp\\www\\Menoon1\\public\\index.php') in server.php line 21
Level 1
actually i have users table(laravel defult ) and user_emails and i want to query on user_emails not users. but i dont know how to do that or what controller shall i change it?
Level 3
You want to check the email field from user_emails for a user?
Level 1
@Mittensoff yes
Level 3
I assume you have a User model. Make an Email model and make a hasMany relationship between User and Email models. Then select a Userand then just do $user->model.
Or if you want a MySQL query do it like this:
//assuming user's id is in $id
$user_emails = DB::select(DB::raw('select * from user_emails where user_id = ' . $id));
If you want more help you need to share more code (your Controllers/Models).
Level 1
where to put that query (in which controller)?
i already have an email model.i cant make relation since email model has composite key . laraval controlller makes checking for me i want to change that but i dont know which controller to change or where to add
Please or to participate in this conversation.